Re: update db

any help at all would be much appreciated, kinda stuck with this one, thanks in advance From: "janey smith" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: update db Date: Mon, 24 Jul 2000 16:51:19 GMT any ideas on this one? From: "jane

drop down box

having a problem passing values submitted in a drop down list box. on my form page the user selects their choices from the drop down, the the user can choose to edit these choices on the next page, their original choices shoud appear on the edit page, which follows: CFQUERY NAME="GetDetails"

RE: drop down box

FONT SIZE=2-----Original Message-/FONT BRFONT SIZE=2From: janey smith [A HREF="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: 24 July 2000 12:44/FONT BRFONT SIZE=2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=2Subject: drop down box/FONT /P BR PFONT SIZE=2ha

update db

on my update page i have 5 textboxes and i can't seem to get the database to update, on the previous page i used to loop to view what the user inserted into the database, is there anyway i can use this same loop to update records in the db, the field in the db is ans_ans, and it's related to

Re: update db

any ideas on this one? From: "janey smith" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: update db Date: Mon, 24 Jul 2000 13:33:56 GMT on my update page i have 5 textboxes and i can't seem to get the database to update, on the previous page i us

need help urgent

I know this is probably an easy one but my head is wrecked, basically my uodate form is acting up . my dataentry form is fine passes the vars ok, !-- Display HTML FORM Here with values filled -- form method="POST" action="Poll_update.cfm" input type="hidden" name="pol_id" value="183"

Re: need help urgent

uot; NAME ="addanswer" UPDATE ans_answer set answer2='#form.ans_answer2#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer3='#form.ans_answer3#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME =

Re: cfif problem

thanks a lot for your help, got that probelm sorted now From: "Chris Ivey" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: cfif problem Date: Wed, 12 Jul 2000 8:39:03 -0400 Janey, This is a response to the CF-Talk question you

pass variables

i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be

Re: cfif problem

thanks a lot , that did the trick! From: Nick Slay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: cfif problem Date: Tue, 11 Jul 2000 21:23:25 +1000 Hi, try this CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans,

Re: cfif problem

ACTION="pollUpAll.cfm" METHOD="POST" tr td width=8nbsp;/td tdfont face=Verdana size=3bPolls/b/fontbrnbsp;/td /tr CFLOOP QUERY="PollSearch" CFOUTPUT table border=0 tr td width=8nbsp;/td tdfont face=Verdana size=2 strong

stop reload data

I have an insert form, which updates the data, however if i reload the action page, it inserts the data again, how do i stop this. thanks in advance Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

RE: stop reload data

p for sure. -Original Message- From: Stanislav Maximov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 5:04 PM To: [EMAIL PROTECTED] Subject: RE: stop reload data You may do silent http redirect. -Original Message----- From: janey smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July

post results to same page

I have with 3 search fields, pol_question, pol_category, pol_status, i am posting the results to the same page, i get this error An error occurred while evaluating the expression: #trim(form.pol_question)# IS NOT "" Error near line 66, column 32.

RE: stop reload data

thanks for you help, i got it working using cflocation.., hopefully that'll do the trick From: Zachary Bedell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: stop reload data Date: Tue, 11 Jul 2000 11:10:06 -0400 -BEGIN PGP SIGNED

Re: post results to same page

any ideas on where i'm going wrong, thanks From: "janey smith" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: post results to same page Date: Tue, 11 Jul 2000 13:52:13 GMT I have with 3 search fields, pol_question, pol_category, pol_status, i