User Updating Their Own Record (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

evanesnard -> User Updating Their Own Record (5/3/2006 16:12:34)

I'm having a hard time figuring out how to write a command that allows a User to update their own record.

Example
1) DONE - User sets up their account in Spooky Login
2) DONE - User sets up an Ad and it is attached to their Account by a unique UserID/AdID
3) DONE - User accesses their personal Account Management page where all of their Ads are displayed in a DBR table
4) DONE - User can click on a link and View any Ad
5) HAVEN'T BEEN ABLE TO GET THIS ONE - User can click on a link and Update any Ad. Click on the Update link and it takes the User to an Ad_Update page which is a form with all the same form fields as the original Ad_Setup page. I already have the Ad_Update page built. I just can't get the page to write the specific Ad data to the form fields.

I have already tried the following two commands in the form inputs on Ad_Update.asp and neither one of them is writing the data to the form field.

<%Response.Write FP_FieldVal (fp_rs," Ad_State")%>
<%=FP_FieldVal(fp_rs,"Ad_State")%>

Any help with this would be much appreciated. Thanks in advance.



rdouglass -> RE: User Updating Their Own Record (5/3/2006 16:20:39)

quote:

Click on the Update link and it takes the User to an Ad_Update page which is a form with all the same form fields as the original Ad_Setup page


Can you give a URL for that page? If not, how about posting the code for that form here.



evanesnard -> RE: User Updating Their Own Record (5/3/2006 16:30:31)

Hi, thanks.

Here's the code. I'm using the same form that I use for Ad_Setup so you'll still see the response.write Session's in there. 

<td bgcolor="#DDEEFF" width="200" height="20"><b>
						<font face="Arial" color="#CC0000" style="font-size: 8.5pt">  Ad Country</font></b><font face="Arial" style="font-size: 8.5pt">
						</font></td>
						<td bgcolor="#DDEEFF" width="270" colspan="2" height="20">
						<b>
						<font face="Arial" color="#145C9E" style="font-size: 8.5pt"> Ad State 
						/ Province</font></b></td>
						<td bgcolor="#DDEEFF" width="200" height="20" colspan="2">
						<b>
						<font face="Arial" color="#CC0000" style="font-size: 8.5pt">
						 
						Ad City or Town</font></b></td>
					</tr>
					<tr>
						<td bgcolor="#DDEEFF" width="200">
						 <!--webbot bot="Validation" s-display-name="Ad Country" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Ad_Country" style="color: #CC0000; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; font-family:Arial" tabindex="1">
						<option>Select An Ad Country</option>						
						<option <%If Session("Ad_Country")="Afghanistan" then response.write "Selected"%>>Afghanistan</option>
						<option <%If Session("Ad_Country")="Albania" then response.write "Selected"%>>Albania</option>
						<option <%If Session("Ad_Country")="Algeria" then response.write "Selected"%>>Algeria</option>
						<option <%If Session("Ad_Country")="American Samoa" then response.write "Selected"%>>American Samoa</option>
						<option <%If Session("Ad_Country")="Andorra" then response.write "Selected"%>>Andorra</option>
						<option <%If Session("Ad_Country")="Angola" then response.write "Selected"%>>Angola</option>
						<option <%If Session("Ad_Country")="Anguilla" then response.write "Selected"%>>Anguilla</option>
						<option <%If Session("Ad_Country")="Antarctica" then response.write "Selected"%>>Antarctica</option>
						<option <%If Session("Ad_Country")="Antigua and Barbuda" then response.write "Selected"%>>Antigua and Barbuda</option>
						<option <%If Session("Ad_Country")="Argentina" then response.write "Selected"%>>Argentina</option>
						<option <%If Session("Ad_Country")="Armenia" then response.write "Selected"%>>Armenia</option>
						<option <%If Session("Ad_Country")="Aruba" then response.write "Selected"%>>Aruba</option>
						<option <%If Session("Ad_Country")="Australia" then response.write "Selected"%>>Australia</option>
						<option <%If Session("Ad_Country")="Austria" then response.write "Selected"%>>Austria</option>
						<option <%If Session("Ad_Country")="Azerbaijan" then response.write "Selected"%>>Azerbaijan</option>
						<option <%If Session("Ad_Country")="Bahamas" then response.write "Selected"%>>Bahamas</option>
						<option <%If Session("Ad_Country")="Bahrain" then response.write "Selected"%>>Bahrain</option>
						<option <%If Session("Ad_Country")="Bangladesh" then response.write "Selected"%>>Bangladesh</option>
						<option <%If Session("Ad_Country")="Barbados" then response.write "Selected"%>>Barbados</option>
						<option <%If Session("Ad_Country")="Belarus" then response.write "Selected"%>>Belarus</option>
						<option <%If Session("Ad_Country")="Belgium" then response.write "Selected"%>>Belgium</option>
						<option <%If Session("Ad_Country")="Belize" then response.write "Selected"%>>Belize</option>
						<option <%If Session("Ad_Country")="Benin" then response.write "Selected"%>>Benin</option>
						<option <%If Session("Ad_Country")="Bermuda" then response.write "Selected"%>>Bermuda</option>
						<option <%If Session("Ad_Country")="Bhutan" then response.write "Selected"%>>Bhutan</option>
						<option <%If Session("Ad_Country")="Bolivia" then response.write "Selected"%>>Bolivia</option>
						<option <%If Session("Ad_Country")="Bosnia Herzegovina" then response.write "Selected"%>>Bosnia Herzegovina</option>
						<option <%If Session("Ad_Country")="Botswana" then response.write "Selected"%>>Botswana</option>
						<option <%If Session("Ad_Country")="Bouvet Island" then response.write "Selected"%>>Bouvet Island</option>
						<option <%If Session("Ad_Country")="Brazil" then response.write "Selected"%>>Brazil</option>
						<option <%If Session("Ad_Country")="British Ind Oc Territ" then response.write "Selected"%>>British Ind Oc Territ</option>
						<option <%If Session("Ad_Country")="Brunei Darussalem" then response.write "Selected"%>>Brunei Darussalem</option>
						<option <%If Session("Ad_Country")="Bulgaria" then response.write "Selected"%>>Bulgaria</option>
						<option <%If Session("Ad_Country")="Burkina Faso" then response.write "Selected"%>>Burkina Faso</option>
						<option <%If Session("Ad_Country")="Burma" then response.write "Selected"%>>Burma</option>
						<option <%If Session("Ad_Country")="Burundi" then response.write "Selected"%>>Burundi</option>
						<option <%If Session("Ad_Country")="Cambodia" then response.write "Selected"%>>Cambodia</option>
						<option <%If Session("Ad_Country")="Cameroon" then response.write "Selected"%>>Cameroon</option>
						<option <%If Session("Ad_Country")="Canada" then response.write "Selected"%>>Canada</option>
						<option <%If Session("Ad_Country")="Cape Verde" then response.write "Selected"%>>Cape Verde</option>
						<option <%If Session("Ad_Country")="Cayman Islands" then response.write "Selected"%>>Cayman Islands</option>
						<option <%If Session("Ad_Country")="Central African Rep" then response.write "Selected"%>>Central African Rep</option>
						<option <%If Session("Ad_Country")="Chad" then response.write "Selected"%>>Chad</option>
						<option <%If Session("Ad_Country")="Chile" then response.write "Selected"%>>Chile</option>
						<option <%If Session("Ad_Country")="China" then response.write "Selected"%>>China</option>
						<option <%If Session("Ad_Country")="Christmas Islands" then response.write "Selected"%>>Christmas Islands</option>
						<option <%If Session("Ad_Country")="Cocos Islands" then response.write "Selected"%>>Cocos Islands</option>
						<option <%If Session("Ad_Country")="Colombia" then response.write "Selected"%>>Colombia</option>
						<option <%If Session("Ad_Country")="Comoros" then response.write "Selected"%>>Comoros</option>
						<option <%If Session("Ad_Country")="Congo" then response.write "Selected"%>>Congo</option>
						<option <%If Session("Ad_Country")="Democ Rep of Congo" then response.write "Selected"%>>Democ Rep of Congo</option>
						<option <%If Session("Ad_Country")="Cook Islands" then response.write "Selected"%>>Cook Islands</option>
						<option <%If Session("Ad_Country")="Costa Rica" then response.write "Selected"%>>Costa Rica</option>
						<option <%If Session("Ad_Country")="Cote d'Ivoire" then response.write "Selected"%>>Cote d'Ivoire</option>
						<option <%If Session("Ad_Country")="Croatia" then response.write "Selected"%>>Croatia</option>
						<option <%If Session("Ad_Country")="Cuba" then response.write "Selected"%>>Cuba</option>
						<option <%If Session("Ad_Country")="Cyprus" then response.write "Selected"%>>Cyprus</option>
						<option <%If Session("Ad_Country")="Czech Republic" then response.write "Selected"%>>Czech Republic</option>
						<option <%If Session("Ad_Country")="Denmark" then response.write "Selected"%>>Denmark</option>
						<option <%If Session("Ad_Country")="Djibouti" then response.write "Selected"%>>Djibouti</option>
						<option <%If Session("Ad_Country")="Dominica" then response.write "Selected"%>>Dominica</option>
						<option <%If Session("Ad_Country")="Dominican Republic" then response.write "Selected"%>>Dominican Republic</option>
						<option <%If Session("Ad_Country")="East Timor" then response.write "Selected"%>>East Timor</option>
						<option <%If Session("Ad_Country")="Ecuador" then response.write "Selected"%>>Ecuador</option>
						<option <%If Session("Ad_Country")="Egypt" then response.write "Selected"%>>Egypt</option>
						<option <%If Session("Ad_Country")="El Salvador" then response.write "Selected"%>>El Salvador</option>
						<option <%If Session("Ad_Country")="Equatorial Guinea" then response.write "Selected"%>>Equatorial Guinea</option>
						<option <%If Session("Ad_Country")="Eritrea" then response.write "Selected"%>>Eritrea</option>
						<option <%If Session("Ad_Country")="Estonia" then response.write "Selected"%>>Estonia</option>
						<option <%If Session("Ad_Country")="Ethiopia" then response.write "Selected"%>>Ethiopia</option>
						<option <%If Session("Ad_Country")="Falkland Islands" then response.write "Selected"%>>Falkland Islands</option>
						<option <%If Session("Ad_Country")="Faroe Islands" then response.write "Selected"%>>Faroe Islands</option>
						<option <%If Session("Ad_Country")="Fiji" then response.write "Selected"%>>Fiji</option>
						<option <%If Session("Ad_Country")="Finland" then response.write "Selected"%>>Finland</option>
						<option <%If Session("Ad_Country")="France" then response.write "Selected"%>>France</option>
						<option <%If Session("Ad_Country")="French Guiana" then response.write "Selected"%>>French Guiana</option>
						<option <%If Session("Ad_Country")="French Polynesia" then response.write "Selected"%>>French Polynesia</option>
						<option <%If Session("Ad_Country")="French Southern Terr" then response.write "Selected"%>>French Southern Terr</option>
						<option <%If Session("Ad_Country")="Gabon" then response.write "Selected"%>>Gabon</option>
						<option <%If Session("Ad_Country")="Gambia" then response.write "Selected"%>>Gambia</option>
						<option <%If Session("Ad_Country")="Georgia" then response.write "Selected"%>>Georgia</option>
						<option <%If Session("Ad_Country")="Germany" then response.write "Selected"%>>Germany</option>
						<option <%If Session("Ad_Country")="Ghana" then response.write "Selected"%>>Ghana</option>
						<option <%If Session("Ad_Country")="Gibraltar" then response.write "Selected"%>>Gibraltar</option>
						<option <%If Session("Ad_Country")="Greece" then response.write "Selected"%>>Greece</option>
						<option <%If Session("Ad_Country")="Greenland" then response.write "Selected"%>>Greenland</option>
						<option <%If Session("Ad_Country")="Grenada" then response.write "Selected"%>>Grenada</option>
						<option <%If Session("Ad_Country")="Guadeloupe" then response.write "Selected"%>>Guadeloupe</option>
						<option <%If Session("Ad_Country")="Guam" then response.write "Selected"%>>Guam</option>
						<option <%If Session("Ad_Country")="Guatemala" then response.write "Selected"%>>Guatemala</option>
						<option <%If Session("Ad_Country")="Guinea" then response.write "Selected"%>>Guinea</option>
						<option <%If Session("Ad_Country")="Guinea-Bissau" then response.write "Selected"%>>Guinea-Bissau</option>
						<option <%If Session("Ad_Country")="Guyana" then response.write "Selected"%>>Guyana</option>
						<option <%If Session("Ad_Country")="Haiti" then response.write "Selected"%>>Haiti</option>
						<option <%If Session("Ad_Country")="Heard and McDon Isles" then response.write "Selected"%>>Heard and McDon Isles</option>
						<option <%If Session("Ad_Country")="Holy See" then response.write "Selected"%>>Holy See</option>
						<option <%If Session("Ad_Country")="Honduras" then response.write "Selected"%>>Honduras</option>
						<option <%If Session("Ad_Country")="Hong Kong" then response.write "Selected"%>>Hong Kong</option>
						<option <%If Session("Ad_Country")="Hungary" then response.write "Selected"%>>Hungary</option>
						<option <%If Session("Ad_Country")="Iceland" then response.write "Selected"%>>Iceland</option>
						<option <%If Session("Ad_Country")="India" then response.write "Selected"%>>India</option>
						<option <%If Session("Ad_Country")="Indonesia" then response.write "Selected"%>>Indonesia</option>
						<option <%If Session("Ad_Country")="Iran" then response.write "Selected"%>>Iran</option>
						<option <%If Session("Ad_Country")="Iraq" then response.write "Selected"%>>Iraq</option>
						<option <%If Session("Ad_Country")="Ireland" then response.write "Selected"%>>Ireland</option>
						<option <%If Session("Ad_Country")="Israel" then response.write "Selected"%>>Israel</option>
						<option <%If Session("Ad_Country")="Italy" then response.write "Selected"%>>Italy</option>
						<option <%If Session("Ad_Country")="Jamaica" then response.write "Selected"%>>Jamaica</option>
						<option <%If Session("Ad_Country")="Japan" then response.write "Selected"%>>Japan</option>
						<option <%If Session("Ad_Country")="Jordan" then response.write "Selected"%>>Jordan</option>
						<option <%If Session("Ad_Country")="Kazakhstan" then response.write "Selected"%>>Kazakhstan</option>
						<option <%If Session("Ad_Country")="Kenya" then response.write "Selected"%>>Kenya</option>
						<option <%If Session("Ad_Country")="Kiribati" then response.write "Selected"%>>Kiribati</option>
						<option <%If Session("Ad_Country")="Korea (North)" then response.write "Selected"%>>Korea (North)</option>
						<option <%If Session("Ad_Country")="Korea (South)" then response.write "Selected"%>>Korea (South)</option>
						<option <%If Session("Ad_Country")="Kuwait" then response.write "Selected"%>>Kuwait</option>
						<option <%If Session("Ad_Country")="Kyrgyzstan" then response.write "Selected"%>>Kyrgyzstan</option>
						<option <%If Session("Ad_Country")="Laos" then response.write "Selected"%>>Laos</option>
						<option <%If Session("Ad_Country")="Latvia" then response.write "Selected"%>>Latvia</option>
						<option <%If Session("Ad_Country")="Lebanon" then response.write "Selected"%>>Lebanon</option>
						<option <%If Session("Ad_Country")="Lesotho" then response.write "Selected"%>>Lesotho</option>
						<option <%If Session("Ad_Country")="Liberia" then response.write "Selected"%>>Liberia</option>
						<option <%If Session("Ad_Country")="Libya" then response.write "Selected"%>>Libya</option>
						<option <%If Session("Ad_Country")="Liechtenstein" then response.write "Selected"%>>Liechtenstein</option>
						<option <%If Session("Ad_Country")="Lithuania" then response.write "Selected"%>>Lithuania</option>
						<option <%If Session("Ad_Country")="Luxembourg" then response.write "Selected"%>>Luxembourg</option>
						<option <%If Session("Ad_Country")="Macau" then response.write "Selected"%>>Macau</option>
						<option <%If Session("Ad_Country")="Macedonia" then response.write "Selected"%>>Macedonia</option>
						<option <%If Session("Ad_Country")="Madagascar" then response.write "Selected"%>>Madagascar</option>
						<option <%If Session("Ad_Country")="Malawi" then response.write "Selected"%>>Malawi</option>
						<option <%If Session("Ad_Country")="Malaysia" then response.write "Selected"%>>Malaysia</option>
						<option <%If Session("Ad_Country")="Maldives" then response.write "Selected"%>>Maldives</option>
						<option <%If Session("Ad_Country")="Mali" then response.write "Selected"%>>Mali</option>
						<option <%If Session("Ad_Country")="Malta" then response.write "Selected"%>>Malta</option>
						<option <%If Session("Ad_Country")="Marshall Islands" then response.write "Selected"%>>Marshall Islands</option>
						<option <%If Session("Ad_Country")="Martinique" then response.write "Selected"%>>Martinique</option>
						<option <%If Session("Ad_Country")="Mauritania" then response.write "Selected"%>>Mauritania</option>
						<option <%If Session("Ad_Country")="Mauritius" then response.write "Selected"%>>Mauritius</option>
						<option <%If Session("Ad_Country")="Mayotte" then response.write "Selected"%>>Mayotte</option>
						<option <%If Session("Ad_Country")="Mexico" then response.write "Selected"%>>Mexico</option>
						<option <%If Session("Ad_Country")="Micronesia" then response.write "Selected"%>>Micronesia</option>
						<option <%If Session("Ad_Country")="Moldova" then response.write "Selected"%>>Moldova</option>
						<option <%If Session("Ad_Country")="Monaco" then response.write "Selected"%>>Monaco</option>
						<option <%If Session("Ad_Country")="Mongolia" then response.write "Selected"%>>Mongolia</option>
						<option <%If Session("Ad_Country")="Montserrat" then response.write "Selected"%>>Montserrat</option>
						<option <%If Session("Ad_Country")="Morocco" then response.write "Selected"%>>Morocco</option>
						<option <%If Session("Ad_Country")="Mozambique" then response.write "Selected"%>>Mozambique</option>
						<option <%If Session("Ad_Country")="Myanmar" then response.write "Selected"%>>Myanmar</option>
						<option <%If Session("Ad_Country")="Namibia" then response.write "Selected"%>>Namibia</option>
						<option <%If Session("Ad_Country")="Nauru" then response.write "Selected"%>>Nauru</option>
						<option <%If Session("Ad_Country")="Nepal" then response.write "Selected"%>>Nepal</option>
						<option <%If Session("Ad_Country")="Netherlands" then response.write "Selected"%>>Netherlands</option>
						<option <%If Session("Ad_Country")="Netherlands Antilles" then response.write "Selected"%>>Netherlands Antilles</option>
						<option <%If Session("Ad_Country")="New Caledonia" then response.write "Selected"%>>New Caledonia</option>
						<option <%If Session("Ad_Country")="New Zealand" then response.write "Selected"%>>New Zealand</option>
						<option <%If Session("Ad_Country")="Nicaragua" then response.write "Selected"%>>Nicaragua</option>
						<option <%If Session("Ad_Country")="Niger" then response.write "Selected"%>>Niger</option>
						<option <%If Session("Ad_Country")="Nigeria" then response.write "Selected"%>>Nigeria</option>
						<option <%If Session("Ad_Country")="Niue" then response.write "Selected"%>>Niue</option>
						<option <%If Session("Ad_Country")="Norfolk Island" then response.write "Selected"%>>Norfolk Island</option>
						<option <%If Session("Ad_Country")="Northern Mariana Isles" then response.write "Selected"%>>Northern Mariana Isles</option>
						<option <%If Session("Ad_Country")="Norway" then response.write "Selected"%>>Norway</option>
						<option <%If Session("Ad_Country")="Oman" then response.write "Selected"%>>Oman</option>
						<option <%If Session("Ad_Country")="Pakistan" then response.write "Selected"%>>Pakistan</option>
						<option <%If Session("Ad_Country")="Palau" then response.write "Selected"%>>Palau</option>
						<option <%If Session("Ad_Country")="Panama" then response.write "Selected"%>>Panama</option>
						<option <%If Session("Ad_Country")="Papua New Guinea" then response.write "Selected"%>>Papua New Guinea</option>
						<option <%If Session("Ad_Country")="Paraguay" then response.write "Selected"%>>Paraguay</option>
						<option <%If Session("Ad_Country")="Peru" then response.write "Selected"%>>Peru</option>
						<option <%If Session("Ad_Country")="Philippines" then response.write "Selected"%>>Philippines</option>
						<option <%If Session("Ad_Country")="Pitcairn" then response.write "Selected"%>>Pitcairn</option>
						<option <%If Session("Ad_Country")="Poland" then response.write "Selected"%>>Poland</option>
						<option <%If Session("Ad_Country")="Portugal" then response.write "Selected"%>>Portugal</option>
						<option <%If Session("Ad_Country")="Puerto Rico" then response.write "Selected"%>>Puerto Rico</option>
						<option <%If Session("Ad_Country")="Qatar" then response.write "Selected"%>>Qatar</option>
						<option <%If Session("Ad_Country")="Reunion" then response.write "Selected"%>>Reunion</option>
						<option <%If Session("Ad_Country")="Romania" then response.write "Selected"%>>Romania</option>
						<option <%If Session("Ad_Country")="Russian Federation" then response.write "Selected"%>>Russian Federation</option>
						<option <%If Session("Ad_Country")="Rwanda" then response.write "Selected"%>>Rwanda</option>
						<option <%If Session("Ad_Country")="St. Kitts and Nevis" then response.write "Selected"%>>St. Kitts and Nevis</option>
						<option <%If Session("Ad_Country")="Saint Lucia" then response.write "Selected"%>>Saint Lucia</option>
						<option <%If Session("Ad_Country")="Saint Vincent and Gren" then response.write "Selected"%>>Saint Vincent and Gren</option>
						<option <%If Session("Ad_Country")="Samoa" then response.write "Selected"%>>Samoa</option>
						<option <%If Session("Ad_Country")="San Marino" then response.write "Selected"%>>San Marino</option>
						<option <%If Session("Ad_Country")="Sao Tome and Principe" then response.write "Selected"%>>Sao Tome and Principe</option>
						<option <%If Session("Ad_Country")="Saudi Arabia" then response.write "Selected"%>>Saudi Arabia</option>
						<option <%If Session("Ad_Country")="Senegal" then response.write "Selected"%>>Senegal</option>
						<option <%If Session("Ad_Country")="Seychelles" then response.write "Selected"%>>Seychelles</option>
						<option <%If Session("Ad_Country")="Sierra Leone" then response.write "Selected"%>>Sierra Leone</option>
						<option <%If Session("Ad_Country")="Singapore" then response.write "Selected"%>>Singapore</option>
						<option <%If Session("Ad_Country")="Slovakia" then response.write "Selected"%>>Slovakia</option>
						<option <%If Session("Ad_Country")="Slovenia" then response.write "Selected"%>>Slovenia</option>
						<option <%If Session("Ad_Country")="Solomon Islands" then response.write "Selected"%>>Solomon Islands</option>
						<option <%If Session("Ad_Country")="Somalia" then response.write "Selected"%>>Somalia</option>
						<option <%If Session("Ad_Country")="South Africa" then response.write "Selected"%>>South Africa</option>
						<option <%If Session("Ad_Country")="S. Georg and S. Sandw Isles" then response.write "Selected"%>>S. Georg and S. Sandw Isles</option>
						<option <%If Session("Ad_Country")="Spain" then response.write "Selected"%>>Spain</option>
						<option <%If Session("Ad_Country")="Sri Lanka" then response.write "Selected"%>>Sri Lanka</option>
						<option <%If Session("Ad_Country")="Sudan" then response.write "Selected"%>>Sudan</option>
						<option <%If Session("Ad_Country")="Suriname" then response.write "Selected"%>>Suriname</option>
						<option <%If Session("Ad_Country")="Svalbard" then response.write "Selected"%>>Svalbard</option>
						<option <%If Session("Ad_Country")="Swaziland" then response.write "Selected"%>>Swaziland</option>
						<option <%If Session("Ad_Country")="Sweden" then response.write "Selected"%>>Sweden</option>
						<option <%If Session("Ad_Country")="Switzerland" then response.write "Selected"%>>Switzerland</option>
						<option <%If Session("Ad_Country")="Syria" then response.write "Selected"%>>Syria</option>
						<option <%If Session("Ad_Country")="Taiwan" then response.write "Selected"%>>Taiwan</option>
						<option <%If Session("Ad_Country")="Tajikistan" then response.write "Selected"%>>Tajikistan</option>
						<option <%If Session("Ad_Country")="Tanzania" then response.write "Selected"%>>Tanzania</option>
						<option <%If Session("Ad_Country")="Thailand" then response.write "Selected"%>>Thailand</option>
						<option <%If Session("Ad_Country")="Togo" then response.write "Selected"%>>Togo</option>
						<option <%If Session("Ad_Country")="Tokelau" then response.write "Selected"%>>Tokelau</option>
						<option <%If Session("Ad_Country")="Tonga" then response.write "Selected"%>>Tonga</option>
						<option <%If Session("Ad_Country")="Trinidad and Tobago" then response.write "Selected"%>>Trinidad and Tobago</option>
						<option <%If Session("Ad_Country")="Tunisia" then response.write "Selected"%>>Tunisia</option>
						<option <%If Session("Ad_Country")="Turkey" then response.write "Selected"%>>Turkey</option>
						<option <%If Session("Ad_Country")="Turkmenistan" then response.write "Selected"%>>Turkmenistan</option>
						<option <%If Session("Ad_Country")="Turks and Caicos Isles" then response.write "Selected"%>>Turks and Caicos Isles</option>
						<option <%If Session("Ad_Country")="Tuvalu" then response.write "Selected"%>>Tuvalu</option>
						<option <%If Session("Ad_Country")="Uganda" then response.write "Selected"%>>Uganda</option>
						<option <%If Session("Ad_Country")="Ukraine" then response.write "Selected"%>>Ukraine</option>
						<option <%If Session("Ad_Country")="United Arab Emirates" then response.write "Selected"%>>United Arab Emirates</option>
						<option <%If Session("Ad_Country")="United Kingdom" then response.write "Selected"%>>United Kingdom</option>
						<option <%If Session("Ad_Country")="United States" then response.write "Selected"%>>United States</option>
						<option <%If Session("Ad_Country")="Uruguay" then response.write "Selected"%>>Uruguay</option>
						<option <%If Session("Ad_Country")="Uzbekistan" then response.write "Selected"%>>Uzbekistan</option>
						<option <%If Session("Ad_Country")="Vanuatu" then response.write "Selected"%>>Vanuatu</option>
						<option <%If Session("Ad_Country")="Vatican City State" then response.write "Selected"%>>Vatican City State</option>
						<option <%If Session("Ad_Country")="Venezuela" then response.write "Selected"%>>Venezuela</option>
						<option <%If Session("Ad_Country")="Vietnam" then response.write "Selected"%>>Vietnam</option>
						<option <%If Session("Ad_Country")="Virgin Islands (British)" then response.write "Selected"%>>Virgin Islands (British)</option>
						<option <%If Session("Ad_Country")="Virgin Islands (U.S.)" then response.write "Selected"%>>Virgin Islands (U.S.)</option>
						<option <%If Session("Ad_Country")="Wallis and Futuna Islands" then response.write "Selected"%>>Wallis and Futuna Islands</option>
						<option <%If Session("Ad_Country")="Western Sahara" then response.write "Selected"%>>Western Sahara</option>
						<option <%If Session("Ad_Country")="Yemen" then response.write "Selected"%>>Yemen</option>
						<option <%If Session("Ad_Country")="Yugoslavia" then response.write "Selected"%>>Yugoslavia</option>
						<option <%If Session("Ad_Country")="Zaire" then response.write "Selected"%>>Zaire</option>
						<option <%If Session("Ad_Country")="Zambia" then response.write "Selected"%>>Zambia</option>
						<option <%If Session("Ad_Country")="Zimbabwe" then response.write "Selected"%>>Zimbabwe</option>
						</select></td>
						<td bgcolor="#DDEEFF" colspan="2" width="270">
						<input type="text" name="Ad_State" size="20" style="color: #145C9E; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; font-family:Arial" tabindex="2" value="<%Response.Write FP_FieldVal (fp_rs," Ad_State")%>"></td>
						<td bgcolor="#DDEEFF" colspan="2" width="200">
						 <!--webbot bot="Validation" s-display-name="Ad City" b-value-required="TRUE" --><input type="text" name="Ad_City" size="25" style="color: #CC0000; font-family:Arial" tabindex="3" value="<%=FP_FieldVal(fp_rs,"Ad_City")%>"></td>



Spooky -> RE: User Updating Their Own Record (5/3/2006 16:37:57)

Is this actually a query from within a DRW? The code shows DRW code (FP_FieldVal (fp_rs," Ad_State")) however we cant see the full the code



evanesnard -> RE: User Updating Their Own Record (5/3/2006 16:46:56)

This is actually a submission form. The previous page that the user would have came from to arrive at this form is a page with a DBR. (that page is Account_Management.asp) Next to each DB result on the AM page is an "Update" link which sessions the user over to this submission form (Ad_Update) so they can automatically update that specific ad from the DBR on the previous page that they linked from.




Spooky -> RE: User Updating Their Own Record (5/3/2006 17:12:01)

When the user clicks on the update link, does it carry the record ID?

eg : Ad_Update.asp?ID=12345

Ad_Update.asp should then be querying the database (using the DRW) to display the result ".....WHERE ID=::ID::"



evanesnard -> RE: User Updating Their Own Record (5/3/2006 17:22:54)

Yes, when the user clicks on the update link, it does carry the record ID.

It looks like this:

Ad_Update.asp?Ad_ID=12345

Here's what I've most recently tried in one of the form fields for the value:

<%Response.Write FP_FieldVal (fp_rs," Ad_State") WHERE Ad_ID=::AD_ID::%>

The Ad_Update.asp page didn't like that command and I got an Internal Server Error message with no page display.



Spooky -> RE: User Updating Their Own Record (5/3/2006 17:26:48)

Ad_Update.asp needs to be a DRW query page.

The criteria used would be "AD_ID"

At step 4 of the DRW, you can output the result in a form.
This is how you need to initially extract the record from the database



evanesnard -> RE: User Updating Their Own Record (5/3/2006 17:34:31)

Yikes! Is there any way I can use this existing page with the existing form (Ad_Update)? It's quite elaborate and I'd hate to have to rebuild.

I'm using this same form page saved as Ad_Setup which get's pre-populated with data that the user enters during their initial Account setup and it works great.

Is there a way I can write the Ad data to this specific form and then submit this form to overwrite the existing data for that Ad record?



Spooky -> RE: User Updating Their Own Record (5/3/2006 17:40:48)

When a user clicks on the link from the update page - where does the information for that ad come from though? Surely that specific information doesnt really exist until you query the database?

The link from the update page can carry more info in the query string (other than just the ID) if required, but not really recommended.



evanesnard -> RE: User Updating Their Own Record (5/3/2006 17:51:13)

I'm trying to find a specific post by Mvu and replied by bobby in this forum titled "How to let visitors update their records" but I couldn't find it with the query. Just read it yesterday and it addresses exactly what I'm talking about.

Anyway

When I use the page for Ad_Setup, each form field in the Ad_Setup page has an initial value of <%=Session("Ad_City")%>, relative to that form fields data of course.

For using the same form page as Ad_Update, couldn't I instead of writing the data to the form page with Session info, instead write each form field data by something like
<%Response.Write FP_FieldVal (fp_rs," Ad_State") WHERE Ad_ID=::AD_ID::%>.

Something like:

We're looking at the Ad_Update form submission page and it is pre-written in each submission field with something that says

Write the field value for Ad_ID WHERE Ad_ID=the Ad_ID in the URL Ad_Update.asp?Ad_ID=12345

Not carry all the info in the link, but have the Ad_Update page write that specific ad data to each respective form field



rdouglass -> RE: User Updating Their Own Record (5/3/2006 19:23:44)

quote:

Ad_Update.asp needs to be a DRW query page.


As Spooky said, you'd need to use a DRW in there somewhere. To use the format:

FP_FieldVal (fp_rs,"anythingHere")

you need to use the DRW. Without it, they don't work. (Or do you already know that and I'm just insulting your intelligence. [&o] )



evanesnard -> RE: User Updating Their Own Record (5/3/2006 23:07:29)

Thanks for that info. I did not know that and appreciate you sharing that info with me. I'm going to come back at this thing fresh tomorrow and will probably have some more questions at that time. Thanks again for all of your help as well as Spooky's.



evanesnard -> RE: User Updating Their Own Record (5/5/2006 10:14:06)

I have created Ad_Update.asp to be a DRW query page with Criteria to be Ad_ID.

I did not see any option in the DRW setup process to output the result to a form. I am currently outputting the result to a table since that was one of the options in the FP DRW setup.

I only saw output options as Table, List, Dropdown. There was an option to add a search form but that's not what I need.

Can you please steer me in the right direction. Thanks.



Spooky -> RE: User Updating Their Own Record (5/5/2006 10:24:43)

At step 4, use the 'list' option under formatting, then in 'list options', choose text fields



evanesnard -> RE: User Updating Their Own Record (5/5/2006 10:32:00)

OK. I did that and I now have a query form that pre-populates the three particular form fields I'm working with right now.

I'm not sure I understand how this is used to update the record.



Spooky -> RE: User Updating Their Own Record (5/5/2006 10:52:10)

This form must now be modified to 'post' to an update page

An example :
http://www.outfront.net/spooky/update.htm



Spooky -> RE: User Updating Their Own Record (5/5/2006 10:53:18)

This form needs to be modified to 'post' to the update page

eg :
http://www.outfront.net/spooky/update.htm



evanesnard -> RE: User Updating Their Own Record (5/5/2006 10:59:05)

Thanks. I accessed that tutorial last night and have been reviewing it but not sure where to begin with the "update page" as you mentioned.

Do I create a whole new page? and What exactly goes in that Update page? The tutorial mentions that the form should submit to an update page that contains a custom DRW. I'm not familiar with submitting info to a DRW. I'm familiar with creating a DRW to pull info from a table to display but I'm confused when it comes to submitting to a DRW.

Can you please shed some light on how to create the Update page you mentioned.

Thanks.



evanesnard -> RE: User Updating Their Own Record (5/5/2006 15:41:24)

Looks like I'm making some progress. I've got a page with DRW and an update page.

Updates are working but if I leave any of the form fields blank on the update page, I get an error when I submit.

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.

I was wondering if you could tell me why this is occuring?



Spooky -> RE: User Updating Their Own Record (5/5/2006 21:45:10)

I would check this post first to get the correct error :

http://www.frontpagewebmaster.com/m-175524/tm.htm

It may be possible the database design doesnt allow zero length entries.
You need to open the database and edit it in access if that is the case.



evanesnard -> RE: User Updating Their Own Record (5/6/2006 9:35:16)

Thanks Spooky. You were absolutely right. Setting the data fields in Access to allow zero length was the exact solution.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375