"WHERE ID=" is being a bugger

Coug · #1 (**permalink**) 11-08-04, 14:59

Hi there, I am quite confused because after going over my code below for a simple update statement I keep getting the

Code:

ODBC Microsoft Access Driver] Syntax error in string in query expression 'ID=''.

error message.

I can not figure out what I am doing wrong. Below is the sql Query and the response.write code.

Code:

fp_sQry="UPDATE External SET external='" & REQUEST("external") & "', internal='" & REQUEST("internal") & "',eIntern='" & REQUEST("eIntern") & "',iIntern='" & REQUEST("iIntern") & "', title='" & REQUEST("title") & "', company='" & REQUEST("company") & "', contact='" & REQUEST("contact") & "', phone='" & REQUEST("phone") & "', fax='" & REQUEST("fax") & "', email='" & REQUEST("email") & "', listed=#" & REQUEST("listed") & "#, salary='" & REQUEST("salary") & "', closing=#" & REQUEST("closing") & "#, status='" & REQUEST("status") & "', department='" & REQUEST("department") & "', availOpen='" & REQUEST("availOpen") & "', url='" & REQUEST("url") & "', jobDesc='" &REQUEST("jobDesc") & "', status='" & REQUEST("status") & "', qual='" & REQUEST("qual") & "', major='" & REQUEST("major") & "', posTitle='" & REQUEST("posTitle") & "', deadline='" & REQUEST("deadline") & "', termAvail='" & REQUEST("termAvail") & "', apply='" & REQUEST("apply") & "', comp='" & REQUEST("comp") & "', placeHis='" & REQUEST("placeHis") &"' WHERE ID=" & REQUEST("External.ID") &"'"

This is of course all on one line and I can no longer find what may be wrong. The response.write generates the following

Code:

UPDATE External SET external='on', internal='o/> Department:<input type=text name=department value=',eIntern='',iIntern='', title='Yo Mama', company='Albertson College of Idaho', contact='contact', phone='phone', fax='459-5214', email='email@email.com', listed=#12/24/2004#, salary='$35,000', closing=#12/25/2004#, status='Note area ', department='', availOpen='3', url='url.com', jobDesc='Job Description ', status='Note area ', qual='Qualifications', major='Major', posTitle='PosTitle', deadline='10/24/04', termAvail='', apply='How to apply here ', comp='12.00', placeHis='04' WHERE ID='

I can see that it is not getting the ID number passed to it. Is it sending the ID number as a string?

I apologize for the amount of code there, I hope it is not bad form for this forum. I apprecitate any and all help. Thank you very much.