timeoutsasp

Numbersandsymbols!
(exclamationpoint)codeproblems,200ASPdelimiters,46AAbandonstatement,ASPSessiondeletingsessionvariables,79AccesskeyfieldInputTagAccessibilityAttributesdialog,204,205accesslevelsdefining,229Dreamweaverrecording,231Access,MicrosoftcreatingAccessdatabase,84creatingrelationshipsin,98–100creatingtables,93–95databaseconnectionwithDreamweaver,115handlingdates,113namingconventions,104queries,102settingupDSNto,114SQLServercompared,87accessibilityfeaturesInputTagAccessibilityAttributesdialog,178,204,205turningoff,178Actionattribute,formtag,134Addseparatorbutton,Insertbar,33Adduserform,234AddAddressmethod,AspEmailsendingccandbcc,154sendinge-mail,152AddAddressproperty,AspEmail,152addalbum.
asp,301–303AddCcmethod,AspEmail,154adding_numbers.
asp,55additionoperator,VBScript,55,65AddRecipientproperty,JMailsendingccandbcc,155sendinge-mail,155AddRecipientBccproperty,JMail,156327INDEXAddRecipientCcmethod,JMail,155AddReplyToproperty,AspEmail,154adduser.
aspregisteringnewusers,233administrationblogs,266–276creatingloginsystem,225–232restrictingaccesstopages,223–243administratorsdatabasetable,224ADOcursortypes,217ADOrecordsetinformation,217AdvancedRecordsetbuilderdialog,121Afterinserting,gotofieldInsertRecorddialogbox,179albumsseeimagegallerywebapplicationAllview,CSSpanel,21allquotes.
asppageaddingLogOutUserserverbehavior,231linkingtodelete.
asp,190linkingtoeditquote.
asp,184,188loginsystemrestrictingaccess,229registeringnewusers,234RepeatRegionserverbehavior,182ANDkeyword,SQL,105ANDoperator,VBScript,62andor.
asp,62,63anonymousdomainsgeneralrequirementsformailcomponents,147Applicationpanel,16,22–25Bindingspanel,16,23blogsecurity,279contextmenuillustrated,209myphotos_main.
asp,298onews_main.
asp,257pastingrecordsetusingpanelgroup,209upload.
asp,310Componentspanel,16,25Databasespanel,16,22connectingDreamweavertoblogdatabase,253connectingDreamweavertoimagegallerydatabase,294ServerBehaviorspanel,16,24Applicationtab,Insertbar,14–16Commandicon,14DeleteRecordicon,15DynamicDataicon,14GoToicon,15InsertRecordseticon,15MasterDetailPageSeticon,15Recordseticon,14Recordsetnavigationstatusicon,15RecordsetPagingicon,15RepeatedRegionicon,14ShowasMenuview,11ShowRegionicon,15UpdateRecordicon,15UserAuthenticationicon,16XSLTransformationicon,16arrayfunctions,VBScript,58ASCkeyword,SQLORDERBYclause,110ASPASPbrackets,5commentingcode,57cookies,72–76creatingsimpledynamicASPpage,4descriptionofbasicfunction,5Dreamweaver8benefitsfordeveloper,9environmentvariables,79–80featuressupportedbyDreamweaver,10resources,323scriptingASPinJavaScript,46servermodelssupportedbyDreamweaver,8sessionvariables,76–79specifyingscriptinglanguage,46ASPblocks/delimiters,46,47ASPdirectiveDreamweaverinserting,46specifyingscriptinglanguage,46ASPJavaScriptservermodelgettingsupportfor,8ASPmailcomponents,146ASPshortcut(ASPtab,Insertbar,12–14CodeBlockicon,13If,ElseIf,Else,Endicons,13Includeicon,12Outputicon,13Response.
Writeicon,13ServerVariablesicon,12Server.
CreateObjecticon,13ShowasTabsview,12TrimmedFormElementicon,13TrimmedQueryStringElementicon,13ASPvariablesseevariables,VBScriptASPVBScriptseeunderVBScriptAspEmailformattinge-mailwithHTMLin,153propertiesandmethodsAddAddressmethod,152AddAddressproperty,152,154AddCcmethod,153AddReplyToproperty,154FromNameproperty,154Hostproperty,152sendingccandbccwith,153sendinge-mailwith,151–154AspUploadcodedelete_action.
asp,321downloading,287upload_action.
asp,314Assetspanel,28assignmentoperators,VBScript,61–62attributesformtag,134Attributespanel,26authenticationUserAuthenticationicon,16authenticationmethodsconfiguringSMTPserver,144Authordrop-downmenubindingdynamicselectlistswithselecteditem,211building,206buildingdynamicselectlists,204AuthorIDfield,tblQuotesforeignkeys,196authorsaddingtoeditpage,210AuthorIDfield,tblQuotes,176creatinginsertauthor.
asp,199Authorsrecordsetbuilding,203updatingeditquote.
asppage,208AuthorstableseetblAuthorstableAutonumberdatatypecreatingprimarykeysinAccess,94Bbehaviors,27seealsoserverbehaviorsBehaviorspanel,26BETWEENkeyword,SQL,108INDEX328Bindingspanel,16,23blogsecurity,279buildingQuotesrecordset,217,218buildingSQLstatementswithRecordsetbuilder,116,119contextmenuillustrated,209myphotos_main.
asp,298onews_main.
asp,257pastingrecordsetusingpanelgroup,209"rememberme"feature,240upload.
asp,310blindcarboncopies(bcc)sendingwithAspEmail,153sendingwithCDO,151sendingwithJMail,155blogsecuritytimeouts,280blogs,245–285administration,266–276onews_admin_archives.
asp,266–271onews_admin_details.
asp,270–276overview,247applicationoverview,246–247databaseconnectingDreamweaverto,253–254creating,247,253creatingdatabasetables,249–250overview,246populatingdatabasetables,250–251settinguserpermissionsfortables,251tbl_onewstable,249,251tbl_userstable,250,251description,246displayingblogentries,255–266onews_archives.
asp,264–266onews_details.
asp,261–263onews_main.
asp,255–260overview,246login/logoutfunctionality,276–280overview,247ONewsblogapplication,246searchingblogs,281–284overview,247security,276–280third-partysolutions,245Booleandatatype,VBScript,53BrowserCheckbuttonDocumenttoolbar,34browserviewaddalbum.
asp,303edit_caption.
asp,319myphotos_main.
asp,301onews_admin_archives.
asp,270,280onews_admin_details.
asp,275onews_archives.
asp,266,284onews_details.
asp,263onews_main.
asp,260onews_searchresults.
asp,284upload.
asp,312upload_action.
asp,315,316bugsavoidingDreamweaverbug,177getmethod,134buttonssendinge-mailviaformbutton,158–160bytedatatype,VBScript,53Ccarboncopies(cc)sendingwithAspEmail,153sendingwithCDO,151sendingwithJMail,155cascadingcreatingrelationshipsinSQLServer,101casesensitivityprogramminglanguages,48VBScript,47,48categoriesaddingtoeditpage,210CategoryIDfield,tblQuotes,176creatinginsertcategory.
asp,201Categoriesrecordsetbuilding,204updatingeditquote.
asppage,208CategoriestableseetblCategoriestableCategorydrop-downmenubindingdynamicselectlistswithselecteditem,212building,207CategoryIDfield,tblQuotesforeignkeys,196CDO(CollaborationDataObjects)CDONTSandCDOSYS,147formattinge-mailwithHTMLinCDO,150propertiesandmethodsFromproperty,149myMail.
Bccproperty,151myMail.
Ccproperty,151Sendmethod,149Subjectproperty,149TextBodyproperty,149Toproperty,149sendingccandbccwithCDO,151sendinge-mailwith,148–151INDEX329CDOSYS,147chardatatypecreatingtablesinSQLServer,96checkboxescreatingformelementswithpostmethod,139–141CheckInicon,Filespanel,27CheckNewUsernamedialog,235CheckNewUsernameserverbehavior,235CheckOuticon,Filespanel,27CodeBlockiconASPtab,Insertbar,13Codeview,10Documenttoolbarand,34Codingtoolbar,36–37CollaborationDataObjectsseeCDOcolumnsdatabasenamingconventions,92Commanddialogdelete_action.
asp,320upload_action.
asp,313CommandiconApplicationtab,Insertbar,14inserting/updating/deletingrecords,15commands,SQLDELETE,128–130INSERT,124–125manipulatingdatabaserecords,122–130UPDATE,125–128commentingcodeASP,57VBScript,57comparisonoperators,VBScript,64–65description,61Componentspanel,16,25concatenation,VBScript,54,55concurrencySQLServer/Accesscompared,87conditionalcodeInsertRecordserverbehavior,180conditionalcommentsafterinsertion,188afterinsertionofquote,181conditionallogicmenuelement,138conditionallogic,VBScript,68–71Elsekeyword,69,71ElseIfkeyword,69If.
.
.
Then.
.
.
Elsestatement,69If.
.
.
Then.
.
.
ElseIfstatement,69Ifstatement,68If,ElseIf,Else,Endicons,13Configurationfieldsendinge-mailwithCDO,149connectionsseedatabaseconnectionsContentTypepropertyformattinge-mailwithHTMLinJMail,155contextmenuillustrated,209conversionfunctions,VBScript,58–59convert_to_int.
asp,59cookies,ASP,72–76deleting,76expirationofcookies,75Netscape'slegalnoticeabout,76"rememberme"loginfeature,241Request.
Cookiesstatement,73Response.
Cookiesstatement,73updating,75warningaboutusing,76COUNTkeyword,SQL,107CREATEDATABASEcommandcreatingSQLServerdatabase,85–88CreateRelationshipdialogcreatingrelationshipsinSQLServer,101imagegallerywebapplication,293CreateObjecticonASPtab,Insertbar,13CSSpanel,21currencydatatype,VBScript,53Currentview,CSSpanel,22cursortypes,217CustomizeFavoriteObjectsdialog,33DdataDynamicDatadialogbox,184DynamicDataicon,14datacheckingDreamweaver8benefitsforASPdeveloper,9dataexchangedynamicwebsites,2datatypes,VBScript,52specifying,54webbrowserviewof,54databaseconnectionsconnectingwithDreamweaver,115toblogdatabase,253–254toimagegallerydatabase,294–295creating,113–116Databasespanel,22Dreamweaver8benefitsforASPdeveloper,9settingupDSNtoAccessdatabase,114settingupDSNtoSQLServerdatabase,114DatabaseDiagramrelationshipsinSQLServer,100INDEX330DatabasePropertiesdialogcreatingSQLServerdatabase,87SQLServerdatabase,248databaserecordsaddingvaluesofrows,107buildingSQLstatementswithRecordsetbuilder,116–122choosingrowsinarange,108choosingrowswithsetvalues,110choosingsubsetofrows,108countingnumberofrowsaffected,107deletingfromdatabase,128–130groupingrowsintocategories,111ignoringduplicatedrows,112insertingintodatabase,124–125manipulating,122–130orderingrows,109reversingstatementlogicwhenchoosing,112selecting,103–106updatingindatabase,125–128databasesAccessqueries,102addingdatato,177creatingAccessdatabase,84creatingblogdatabase,247–253creatingforimagegallery,289–293creatingrelationshipsinAccess,98–100creatingrelationshipsinSQLServer,100–102creatingSQLServerdatabase,85–88creatingtables,92–97designing,91–97handlingdates,113introduction,83namingconventions,91relationaldatabases,97–103SQLServerviews,102SQLServer,preparingforInternetuse,88–91Databasespanel,16,22connectingDreamweavertoblogdatabase,253connectingDreamweavertoimagegallerydatabase,294datedatatype,VBScript,53datefunctions,VBScript,58dates,SQL,113DeleteRecorddialogedit_photo_album.
asp,306illustrated,190onews_admin_details.
asp,274DeleteRecordiconApplicationtab,Insertbar,15DeleteRecordserverbehavior,189–192DELETEstatement,SQL,128–130Deletewebpageillustrated,192delete.
asppageDeleteRecordserverbehavior,189linkingfromallquotes.
asp,190delete_action.
asp,320–322delete_cookie.
asp,76delimitersASPdelimiters,46DESCkeyword,SQLORDERBYclause,110Designviewaddalbum.
asp,301,303Documenttoolbarand,34Dreamweaverpagein,10edit_caption.
asp,319edit_photo_album.
asp,306Guidesfeature,37Handtool,37login.
asp,277Magnificationlist,37myphotos_main.
asp,297onews_admin_archives.
asp,268,269onews_admin_details.
asp,272,275onews_archives.
asp,265,281onews_details.
asp,262,263onews_main.
asp,256,260RefreshDesignViewbutton,34searchingblogs,281tbl_photoalbums,290tbl_photos,291tools,37upload.
asp,309,312Zoomtool,37Dimkeyword,VBScript,49DimacDevelopmentsendinge-mailwithJMail,154Disconnect(fromremotehost)iconFilespanel,27display_sex.
asp,138DISTINCTkeyword,SQL,112divideoperator,VBScript,65divide_operators.
asp,66Do.
.
.
Loopstatement,VBScript,71Documenttoolbar,33–35BrowserCheckbutton,34buttonfunctionality,34FileManagementbutton,34LiveDataViewbutton,34Preview/DebuginBrowserbutton,34RefreshDesignViewbutton,34ValidateMarkupbutton,34ViewOptionsbutton,34VisualAidsbutton,35doubledatatype,VBScript,53dowhile.
asp,72INDEX331DreamweaverASPfeaturessupportedby,10communitysites,323creatingnewdocument,3creatingdatabaseconnection,115definingASPVBScriptsitein,39–42MacromediaExchangefor,324MultipleDocumentInterface,20–32resources,323servermodels,7ASPVBScriptservermodel,7listofsupportedservermodels,8specifyingscriptinglanguage,46toolbars,32–38workspacelayout,19Dreamweaver8benefitsforASPdeveloper,9newsabout,323DSN(datasourcename)connectingDreamweavertoblogdatabase,254connectingDreamweavertoimagegallerydatabase,295creatingdatabaseconnections,113–116Accessdatabase,114connectionwithDreamweaver,115SQLServerdatabase,114dynamicASPApplicationpanel,16CodeBlockiconcreating,13Insertbar,11–16dynamicASPpagescreatingsimple,4database-drivendataexchange,6flowofdatawith,6myphotos_main.
asp,298–301onews_admin_archives.
asp,269onews_admin_details.
asp,275onews_archives.
asp,265onews_details.
asp,263onews_main.
asp,260webbrowserview,5Dynamicbutton,Propertyinspector,206DynamicDatadialogmyphotos_main.
asp,299onews_main.
asp,259selecting,184selectingcolumn,212DynamicDataiconApplicationtab,Insertbar,14DynamicList/Menudialogaddingcodetospecifyselection,212bindingdynamicselectlistswithselecteditem,211buildingAuthordrop-downmenu,206buildingCategorydrop-downmenu,207buildingdynamicselectlists,206dynamicselectlistsbindingwithselecteditem,211building,204–207dynamicwebsitesdataexchange,2meaningof,1dynamic_values_in_email.
asp,160Ee-mailASPmailcomponents,146creatingmailinglist,170–173dynamicinteraction,156–167formattingwithHTMLinAspEmail,153formattingwithHTMLinCDO,150formattingwithHTMLinJMail,155generalrequirementsforcomponents,147makingpropertyvaluesdynamic,160–167sendingbyhyperlink,156–158sendingviaformbutton,158–160sendingwithAspEmail,151–154sendingwithCDO,148–151sendingwithdynamicformfieldvalues,162–163sendingwithdynamicvalues,160–161sendingwithJMail,154–156sendingwithmailcomponents,148–156sendingformvaluesto,143–156sendingpagetofriend,164–167settingupSMTPserver,143–146EditDiagramdialogimagegallerywebapplication,292,293EditRelationshipsdialog,99,198editquote.
asppagelinkingfromallquotes.
asp,184,188UpdateRecordserverbehavior,186updatingforauthors/categories,208–214edit_caption.
asp,317–320linkfromupload.
asp,319edit_photo_album.
asp,304–306Elsekeyword,VBScript,69,71Else,ElseIficonsASPtab,Insertbar,13ElseIfkeyword,VBScript,69email_frmbutton.
asp,158,159email_hyperlink.
asp,156,158emptydatatype,VBScript,53enableDeletefunction,JavaScriptonews_admin_details.
asp,272EndiconASPtab,Insertbar,13INDEX332EnterpriseManager,SQLServercreatingSQLServerdatabase,85,86environmentvariables,ASP,79–80HTTP_REFERER,79QUERY_STRING,79REMOTE_HOST,79SCRIPT_NAME,80SERVER_NAME,80URL,80env_variables.
asp,80equaltooperator,VBScript,64exclamationpoint(!
)codeproblems,200execute_aspemail.
asp,152,153execute_cdo.
asp,148,149,151execute_jmail.
asp,154,155Expand(toshowlocalandremotesites)iconFilespanel,28ExpandAlltoolbarInsertbar,37expectedoutput.
asp,69FFavoritestabCustomizeFavoriteObjectsdialog,32FileManagementbuttonDocumenttoolbar,34Filespanelgroup,27–29Assetspanel,28iconsexplained,27Snippetspanel,28foldericonillustrated,184foreignkeyssettinguprelationships,98tablerelationships,220tblQuotestable,196valuesheldin,98forgotten_pwd.
asp,168,170formfieldsnamingconventions,162Formstatement,ASPRequest,135formtag/elementActionattribute,134addingtopage,177attributes,134buildingdynamicselectlists,204,205creatingwithpostmethod,135–141getmethod,134Methodattribute,134methods,134postmethod,135URLparametersname/valuesyntax,134formvaluessendingtoe-mail,143–156formatfunctions,VBScript,58formssubmittinginformationbetweenpages,177workingwith,133Formstab,Insertbar,177List/Menubutton,204forumspostingquestions,323Frompropertysendinge-mailwithAspEmail,152sendinge-mailwithCDO,149FromNameproperty,AspEmail,154FTPLogpanel,31functions,VBScript,58–61arrayfunctions,58completelistof,websitesfor,58conversionfunctions,58–59datefunctions,58formatfunctions,58mathfunctions,58stringfunctions,58,59–61GGETsubmittinginformationbetweenpages,177Getfileicon,Filespanel,27getmethodcomparisonwithpostmethod,135formtag,134receivingdatafromURLparameter,141retrievingURLparameters,141troubleshooting,134GettingStartedpanelAccess,Microsoft,84GoToiconApplicationtab,Insertbar,15Grannell,Craig,322greaterthanoperator,VBScript,64GROUPBYclause,SQL,111Guidesfeature,Designview,37HHandtool,Designview,37HandheldoptionStyleRenderingtoolbar,36helppostingquestions,323Hostproperty,AspEmail,152INDEX333HTMLformattinge-mailwithHTMLinCDO,150staticHTMLpage,4HTMLBodypropertyformattinge-mailwithHTMLinCDO,150HTTPheaderpostmethod,135HTTP_REFERERenvironmentvariables,ASP,79hyperlinkssendinge-mailbyhyperlink,156–158IIdentitydatatypecreatingprimarykeysinSQLServer,96If.
.
.
Then.
.
.
Elsestatement,VBScript,69If.
.
.
Then.
.
.
ElseIfstatement,VBScript,69Ifstatement,VBScript,68If,ElseIf,Else,EndiconsASPtab,Insertbar,13ifstatement.
asp,68imagegallerywebapplication,287–324ASPpagesaddalbum.
asp,301–303delete_action.
asp,320–322edit_caption.
asp,317–320edit_photo_album.
asp,304–306myphotos_main.
asp,295–301upload.
asp,307–312upload_action.
asp,312–316connectingDreamweaverto,294–295creatingdatabasefor,289–293tbl_photoalbums,289tbl_photos,290creatingphotoalbums,288,301–303deletingphotoalbums,288,304–306deletingphotos,288,320–322displayingphotoalbums,288,295–301displayingphotos,288,312–316editingphotoalbums,288,304–306editingphotocaptions,288,317–320relationshipbetweentbl_photosandtbl_photoalbums,292storinginformationindatabase,288uploadingphotos,288,307–316INkeyword,SQL,110IncludeiconASPtab,Insertbar,12includes,12InputTagAccessibilityAttributesdialog,178,205addingauthorsandcategoriestoeditpage,210buildingdynamicselectlists,204,205buildingloginform,225Insert(author)pageillustrated,201Insert(category)pageillustrated,202Insert(quote)pageillustrated,189Insertbar,11–16Applicationtab,14–16ASPtab,12–14Codingtoolbar,36Documenttoolbar,33ExpandAlltoolbar,37Formstab,177List/Menuicon,204ShowasMenuview,11ShowasTabsview,11,12Standardtoolbar,35StyleRenderingtoolbar,35stylesfor,11Insertpanelgroup,32–37InsertRecorddialog,180addalbum.
asp,302Afterinserting,gotofield,179buildinginsertauthor.
asp,200insertingcategories,202registeringnewusers,234updatedtoaddauthor/category,208InsertRecordserverbehavior,179–182addingdatatodatabase,177conditionalcode,180forcingpagetoreloadafterinsertion,179onews_admin_archives.
asp,269selecting,186updating,207InsertRecordseticonApplicationtab,Insertbar,15INSERTstatement,SQL,124–125insert.
asppage,177addingauthorsandcategoriestoeditpage,210addingconditionalcode,180basicQuotesubmissionform,179InsertRecordserverbehavior,179savingtowebsite,177updatingforauthors/categories,203–208insertauthor.
asppage,199insertcategory.
asppage,201intdatatypecreatingtablesinSQLServer,96integerdatatype,VBScript,53InternetUser(IUSR)account,89INDEX334IPaddressesconfiguringSMTPserver,145findingyourIPaddress,152ipconfigcommand,152IUSRaccount,89JJavaScriptscriptingASPin,46JavaScriptservermodel,ASPgettingsupportfor,8JMailformattinge-mailwithHTMLin,155propertiesandmethodsAddRecipientproperty,155AddRecipientBccproperty,156AddRecipientCcmethod,155ContentTypeproperty,155Senderproperty,155ServerAddressproperty,155sendingccandbccwith,155sendinge-mailwith,154–156JOINkeyword,216joins,databasetablesrandomquoteselector,214Kkeywordsdatabasenamingconventions,91LLeftfunction,VBScript,60Lenfunction,VBScript,59len.
asp,59lessthanoperator,VBScript,64LinkCheckerpanelResultspanelgroup,31Linkfield,Propertyinspectorillustrated,191listelementcreatingformelementswithpostmethod,137–139List/Menuicon,Insertbarbuildingdynamicselectlists,204LiveDataViewbuttonDocumenttoolbar,34LocalInfoscreenSiteDefinitiondialog,39Localview,Filespanel,27lockingSQLServer/Accesscompared,87,88LogInUserdialog,228LogInUserserverbehavioradding,227–229blogsecurity,278expandingcode,237–238LogOutUserserverbehavioradding,231–232blogsecurity,279logicaloperators,VBScript,61,62–64ANDoperator,62NOToperator,63ORoperator,62precedence,67LoginPropertiesdialogboxSQLServerdatabase,252loginsystemblogapplication,276–280buildingloginform,225–227checkingnewusername,235cookies,241creating,225–232creatinguser-friendlylogin,236–237LogInUserserverbehavior,227–229,237–238LogOutUserserverbehavior,231–232redirectingfailedlogins,227registeringnewusers,233–236"rememberme"feature,239–242restrictingaccess,229–231login.
aspblogsecurity,276,277–279buildingloginform,225login_create_cookies.
asp,74login_create_sessions.
asp,77,78login_user.
asp,136logout.
asp,278–280longdatatype,VBScript,53loopinglogic,VBScript,71–72Do.
.
.
Loopstatement,71While.
.
.
Wendstatement,72LTrimfunction,VBScript,60MMacromediaExchangeforDreamweaver,324Magnificationlist,Designview,37mailcomponentsASPmailcomponents,146generalrequirementsfor,147sendinge-mailwith,148–156INDEX335mailinglistscreating,170–173mailing_list.
asp,170,172,173ManageSitesdialog,27showingnewlycreatedsite,42many-to-manyrelationship,198Mapview,Filespanel,27MasterDetailPageSeticonApplicationtab,Insertbar,15mathfunctions,VBScript,58mathematicaloperators,VBScript,61,65–66precedence,66MDI(MultipleDocumentInterface),20–32Applicationpanelgroup,22–25CSSpanel,21Filespanelgroup,27–29Resultspanelgroup,30–32TagInspectorpanelgroup,25–27menuelementconditionallogic,138creatingformelementswithpostmethod,137–139Methodattribute,formtag,134methodsformtag,134MicrosoftManagementConsole(MMC),86MM_redirectLoginSuccess,237MM_rsUserrecordset,237,238MM_UserAuthorizationvariable,228MM_Username,228modulusoperator,VBScript,65MultipleDocumentInterfaceseeMDImyMail.
BccpropertysendingccandbccwithCDO,151myMail.
CcpropertysendingccandbccwithCDO,151myphotos_main.
asp,295–301implementingdynamicfeatures,298–301my_first_cookie.
asp,73,75my_name.
asp,54Nnamingconventions,205databases,91formfields,162prefixingsessionvariables,238SQLServerobjects,103variables,VBScript,56navigationRecordsetnavigationstatusicon,15NewFilepanelMicrosoftAccess,84NOTkeyword,SQL,112NOToperator,VBScript,63nulldescriptionof,96nulldatatype,VBScript,53Numberdatatypesubtypesof,94OONewsblogapplication,246–284seealsoblogsODBC/OLEDBconnectionstringsDreamweavertoblogdatabase,253Dreamweavertoimagegallerydatabase,294one-to-manyrelationship,198creatingrelationshipsinAccess,99onews_admin_archives.
asp,266–270,276,280onews_admin_details.
asp,270–276onews_archives.
asp,264–266,281onews_details.
asp,261–263onews_main.
asp,255–260onews_searchresults.
asp,281–284onlinediaryseeblogsoperatorprecedence,VBScript,66–67parentheses,67operators,VBScript,61–67additionoperator,55assignmentoperators,61,62comparisonoperators,61,64–65concatenationoperator,54logicaloperators,61,62–64mathematicaloperators,61,65–66operatorprecedence,66–67parentheses,67operator_order.
asp,67ORkeyword,SQL,105ORoperator,VBScript,62ORDERBYclause,SQL,109ASC/DESCkeywords,110outputprintingVBScriptvariables,50OutputiconASPtab,Insertbar,13INDEX336Ppagesrestrictingaccessto,223–243submittinginformationbetweenpages,177pagingRecordsetPagingicon,15panelgroupmenuoptionpastingrecordsetusing,209PanelGroupOptionsmenuicon,21panelgroupingsRenamePanelGroupdialog,20restrictionson,21panelgroupsApplicationpanelgroup,22–25Filespanelgroup,27–29Insertpanelgroup,32–37Resultspanelgroup,30–32TagInspectorpanelgroup,25–27Parametersdialogillustrated,185myphotos_main.
asp,299onews_main.
asp,259onews_searchresults.
asp,283upload.
asp,310,311passwordssendinguserforgottenpassword,167–170PersitsSoftwaresendinge-mailwithAspEmail,151PersonalWebServer(PWS),143photogalleryseeimagegallerywebapplicationPIseePropertyinspectorPointtoFileiconillustrated,188POSTsubmittinginformationbetweenpages,177postmethodcomparisonwithgetmethod,135creatingformelementswith,135–141checkboxes,139–141list/menuelement,137–139textboxes,136–137formtag,135HTTPheader,135Request.
Formstatement,135prefixesVBScriptvariablenamingconventions,56Preview/DebuginBrowserbuttonDocumenttoolbar,34primarykeyscreatinginAccess,94creatinginSQLServer,95foreignkeysand,98tablerelationships,220useof,92PrintoptionStyleRenderingtoolbar,36programminglanguagescasesensitivity,48ProjectionoptionStyleRenderingtoolbar,36Propertiespanelupload.
asp,308Propertyinspector(PI),29Dynamicbutton,206recordsetproperties,217Resultspanelgroup,30–32publicuserrole,90Putfileicon,Filespanel,27PWS(PersonalWebServer),143QqueriesAccess,102QueryAnalyzer,85Querydesignerwindow,215QueryStringstatement,ASPRequestretrievingURLparameterswith,141–143querystrings,13,141QUERY_STRINGenvironmentvariables,ASP,79Quotetextfieldproperties,178quoteswww.
brainyquote.
com,180QuotesdatabasetableseetblQuotestableQuotesrecordsetbuilding,217–220Quoteswebpagebuildingallquotes.
asppage,182–185buildingdelete.
asppage,189–192buildingeditquote.
asppage,186–189buildinginsert.
asppage,177–182buildinginsertauthor.
asp,199buildinginsertcategory.
asp,201creatingtblQuotesdatabasetable,176displayingrandomquote,220illustrated,185illustratedwithDeletelinks,191randomquoteselector,214–220updatingeditquote.
asppage,208–214updatinginsert.
asppage,203–208INDEX337Rrandomquoteselector,214–220Randomizefunction,219randomquote.
asppage,216bindingsshown,218RecordUpdatedialogedit_caption.
asp,318edit_photo_album.
asp,305records,databaseseedatabaserecordsRecordsetbuilderAdvancedRecordsetbuilderdialog,121buildingSQLstatements,116–122SQLServerviews/Accessqueries,102,103RecordsetdialogbuildingQuotesrecordset,217buildingrsCategoriesrecordset,204edit_caption.
asp,317edit_photo_album.
asp,304illustrated,182,187myphotos_main.
asp,296onews_admin_archives.
asp,267onews_admin_details.
asp,271onews_archives.
asp,264onews_details.
asp,261onews_main.
asp,255RepeatRegionserverbehavior,182retrievingauthors,203searchingblogs,282updatingrsQuotesrecordset,211upload.
asp,307RecordseticonApplicationtab,Insertbar,14RecordsetnavigationstatusiconApplicationtab,Insertbar,15RecordsetPagingiconApplicationtab,Insertbar,15recordsetsbuildingAuthorsrecordset,203buildingCategoriesrecordset,204buildingQuotesrecordset,217–220description,14MM_rsUserrecordset,237recordsetproperties,217updatingeditquote.
asppage,208updatingrsQuotesrecordset,211redirectcodedelete_action.
asp,322upload_action.
asp,315Referencepanel,20,32referentialintegritytblQuotes/tblAuthors/tblCategories,198RefreshDesignViewbuttonDocumenttoolbar,34Refreshicon,Filespanel,27regionsRepeatedRegionicon,14ShowRegionicon,15relationaldatabases,97–103relationshipsinAccess,98–100relationshipsinSQLServer,100–102relationshipscreatingjoinindatabase,214EditRelationshipsdialogbox,99,198effectofmovingtablesindialogwindow,199many-to-manyrelationship,198one-to-manyrelationship,198Querydesignerwindow,215settingup,97,98tblQuotes/tblAuthors/tblCategories,198tbl_photos/tbl_photoalbums,292Relationshipsdialog,199Relationshipsicon,197Relationshipstoolbarbutton,98relayrestrictionsoptionsconfiguringSMTPserver,145"rememberme"loginfeature,239–242RemoteInfoscreenSiteDefinitiondialog,40Remoteview,Filespanel,27REMOTE_HOSTenvironmentvariables,ASP,79Removestatement,ASPSession.
Contents,78RenamePanelGroupdialog,20RepeatRegiondialogillustrated,183myphotos_main.
asp,300RepeatRegionserverbehavior,182–185onews_main.
asp,258repeatedregion,14RepeatedRegioniconApplicationtab,Insertbar,14Request.
Cookiesstatement,ASP,73Request.
Formstatement,ASP,135retrievingvaluesofformelements,137Request.
QueryStringstatement,ASPretrievingURLparameterswith,141–143Request.
ServerVariablesstatement,ASPretrievingenvironmentvariables,80reservedwordsdatabasenamingconventions,91Response.
Cookiesstatement,ASP,73Response.
WritecodeprintingVBScriptvariables,50Response.
WriteiconASPtab,Insertbar,13INDEX338RestrictAccessToPagedialog,230blogsecurity,276RestrictAccessToPageserverbehavior,231creatinguser-friendlylogin,236Resultspanelgroup,30–32FTPLogpanel,31LinkCheckerpanel,31Referencepanel,20,32Searchpanel,30ServerDebugpanel,32SiteReportspanel,31TargetBrowserCheckpanel,31Validationpanel,30rewrite_cookie.
asp,75rewrite_session.
asp,78rolesSQLServerforInternetuse,89rsAuthorsrecordset,203rsCategoriesrecordset,204rsQuotesrecordset,183buildingQuotesrecordset,217–220updatingtoretrievespecificquote,211RTrimfunction,VBScript,60SSaveAscontextmenuoptioncreatinginsertauthor.
asp,199ScreenoptionStyleRenderingtoolbar,36SCRIPT_NAMEenvironmentvariables,ASP,80Searchpanel,30searchingblogs,281–284securityblogs,276–280creatingloginsystem,225–232creatingtblAdmintable,224restrictingaccesstopages,223–243URLparameters,134selectlists,dynamicbindingwithselecteditem,211building,204–207SELECTstatements,SQL,103–106ANDkeyword,105ORkeyword,105WHEREkeyword,104Sendmethodsendinge-mailwithCDO,149Senderproperty,JMail,155sendnameback.
asp,51send_email_form.
asp,162send_note.
asp,139,140send_page_form.
asp,164,167serverbehaviorsDeleteRecord,189–192InsertRecord,179–182,207LogInUser,227–229,237–238LogOutUser,231–232RepeatRegion,182–185RestrictAccessToPage,231UpdateRecord,186–189,213usingcommandsinsteadof,122ServerBehaviorspanel,16,24ServerDebugpanel,32servermodels,7ServerSideIncludes(SSI),12ServerVariablesiconASPtab,Insertbar,12Server.
CreateObjecticonASPtab,Insertbar,13ServerAddressproperty,JMail,155ServerVariablesstatement,ASPRequestretrievingenvironmentvariables,80SERVER_NAMEenvironmentvariables,ASP,80sessionobject,ASP,77sessionvariables,76–79blogsecurity,278creating,77deleting,78prefixing,238retrieving,77servermemory,79settingsessiontimeoutinterval,77timeoutscope,79updating,78wordsofwarningforusing,79Session.
Abandonstatement,ASPdeletingsessionvariables,79Session.
Contents.
Removestatement,ASPdeletingsessionvariables,78Session.
Timeoutstatement,ASP,77sex_selection.
asp,137ShowasMenuview,Insertbar,11ShowasTabsview,Insertbar,11ShowRegionbehavioronews_main.
asp,258ShowRegiondialogmyphotos_main.
asp,300ShowRegioniconApplicationtab,Insertbar,15ShowTabledialog,197addingtablestoquerydesign,214creatingrelationships,197singledatatype,VBScript,53INDEX339SiteDefinitiondialogcreatingnewsite,42LocalInfoscreen,39RemoteInfoscreen,40TestingServerscreen,41SiteReportspanel,31SMTP(SimpleMailTransferProtocol)serverconfiguring,143relayinge-mailmessages,145settingup,143–146Snippetspanel,28Splitview,10Documenttoolbarand,34Dreamweaverpagein,11SQL(StructuredQueryLanguage)ANDkeyword,105BETWEENkeyword,108COUNTkeyword,107DELETEstatement,128–130description,14DISTINCTkeyword,112GROUPBYclause,111handlingdates,113INkeyword,110INSERTstatement,124–125manipulatingdatabaserecords,122–130NOTkeyword,112ORkeyword,105ORDERBYclause,109ASC/DESCkeywords,110Recordsetbuilder,116–122SELECTstatements,103–106SUMkeyword,107TOPkeyword,108UPDATEstatement,125–128WHEREkeyword,104SQLServerdatabaseAccesscomparedto,87creatingrelationshipsin,100–102creatingSQLServerdatabase,85–88creatingtables,95–97databaseconnectionwithDreamweaver,116DatabasePropertieswindow,248handlingdates,113LoginPropertiesdialogbox,252namingconventions,91,103preparingforInternetuse,88–91settingupDSNto,114viewofconsoleroot,248views,102SQLServerServiceManager,247SQLServertablestructureDreamweavertablecomparedto,176SSI(ServerSideIncludes),12Standardtoolbar,35staticHTMLpage,4descriptionoflimitation,6flowofdatawith,6Staticoptionsbindingdynamicselectlistswithselecteditem,211buildingdynamicselectlists,206,207storedprocedures,SQLmanipulatingdatabaserecords,122stringdatatype,VBScript,53concatenation,54quotationmarks,53stringfunctions,VBScript,58,59–61Leftfunction,60Lenfunction,59LTrimfunction,60RTrimfunction,60Trimfunction,60StyleRenderingtoolbar,35options,36Subjectpropertysendinge-mailwithCDO,149SUMkeyword,SQL,107TTabIndexfieldInputTagAccessibilityAttributesdialog,204,205tablerelationshipsprimary/foreignkeys,220Querydesignerwindow,215tablesblogdatabasetables,249–253creating,92–97Access,93–95SQLServer,95–97databasenamingconventions,91primarykeys,92ShowTabledialogbox,197,214TagChooser,183TagInspectorpanelgroup,25–27Attributespanel,26Behaviorspanel,26TargetBrowserCheckpanel,31tblAdmintable,224tblAuthorstable,197creatingjoinsindatabase,216creatingrelationshipwithtblQuotes,197,198tblCategoriestable,197creatingrelationshipwithtblQuotes,197,198tblQuotestable,176,196basicQuotesubmissionform,179buildingformforaddingquotes,177INDEX340creatingrelationshipwithtblAuthors,197,198creatingrelationshipwithtblCategories,197,198DeleteRecordserverbehavior,189Dreamweavertablestructure,176enforcingreferentialintegrityfor,198foreignkeys,196InsertRecordserverbehavior,179RepeatRegionserverbehavior,182rsQuotesrecordset,183SQLServertablestructure,176UpdateRecordserverbehavior,186updating,196tbl_onewstableaddingdatato,251creatingblogdatabase,249settingpermissionsfor,251tbl_photoalbumsimagegallerydatabase,289relationshipwithtbl_photos,292tbl_photosimagegallerydatabase,290relationshipwithtbl_photoalbums,292tbl_userstableaddingdatato,251creatingblogdatabase,250settingpermissionsfor,251TestingserverFilespanel,27TestingServerscreenSiteDefinitiondialog,41textboxescreatingformelementswithpostmethod,136–137TextBodypropertyformattinge-mailwithHTMLinCDO,150sendinge-mailwithCDO,149timedatatype,VBScript,53Timeoutstatement,ASPSession,77timeoutsblogsecurity,280Topropertysendinge-mailwithCDO,149ToggleCSSoptionStyleRenderingtoolbar,36toolbars,32–38Codingtoolbar,36–37Documenttoolbar,33–35Inserttoolbar/panelgroup,32–37Standardtoolbar,35StyleRenderingtoolbar,35TOPkeyword,SQL,108transactionlogfilesSQLServer/Accesscompared,87transformationsXSLTransformationicon,16Trimfunction,VBScript,60TrimmedFormElementiconASPtab,Insertbar,13TrimmedQueryStringElementiconASPtab,Insertbar,13troubleshootingavoidingDreamweaverbug,177getmethod,134TTYoptionStyleRenderingtoolbar,36TVoptionStyleRenderingtoolbar,36TypeNamefunction,59UUpdateRecorddialogillustrated,188updated,213UpdateRecordiconApplicationtab,Insertbar,15UpdateRecordserverbehavior,186–189onews_admin_details.
asp,273updating,213UPDATEstatement,SQL,125–128upload.
asp,307–312edit_caption.
asplink,319upload_action.
asp,312–316URLenvironmentvariable,ASP,80URLparametersdescription,141name/valuesyntax,134,141receivingdatafrom,141retrievingwithRequest.
QueryString,141–143security,134UserAuthenticationiconApplicationtab,Insertbar,16userscreatingloginsystem,225–232creatinguser-friendlylogin,236–237expandingLogInUserserverbehaviorcode,237–238registeringnewusers,233–236checkingnewusername,235"rememberme"loginfeature,239–242sendinguserforgottenpassword,167–170UsersobjectpreparingSQLServerdatabaseforInternetuse,89user_rating.
asp,69,70INDEX341VValidateMarkupbuttonDocumenttoolbar,34validationcreatingloginsystem,225–232Validationpanel,30varchardatatype,96variabletypes,VBScript,53variablesASPrequestingservervariables,12variables,VBScript,48–57additionoperator,55concatenation,54datatypes,52declaring,49implicitly,52printingvariables,51syntaxrules,52namingconventions,56meaningfulnames,56prefixes,56printing,50ASPshortcut(ASPVBScriptservermodel,7casesensitivity,47,48commentingcode,57conditionallogic,68–71If,ElseIf,Else,Endicons,13cookies,ASP,72–76definingASPVBScriptsiteinDreamweaver,39–42functions,58–61loopinglogic,71–72operators,61–67sessionvariables,ASP,76–79specifyingscriptinglanguage,46variables,48–57ViewOptionsbuttonDocumenttoolbar,34viewprefixexplained,216views,SQLServer,102VisualAidsbuttonDocumenttoolbar,35Wwebbrowsersseebrowserviewweblogseeblogswebpagesseepageswebsitesrestrictingaccesstopages,223–243weblogseeblogswelcome_user.
asp,136,137WHEREkeyword,SQL,104While.
.
.
Wendstatement,VBScript,72whitespaceTrimmedFormElementicon,13workspacelayout,19XXSLTransformationiconApplicationtab,Insertbar,16ZZoomtoolDesignview,37INDEX342