Unterminated string constant in UPDATE statement

Dev Shed Forums Sponsor:

August 12th, 2003, 01:53 PM

isleysista

Junior Member

Join Date: Jul 2003

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Unterminated string constant in UPDATE statement

hi everyone -

this problem will probably be pretty easy for someone to figure out but i have no idea what this error is referring to. I thought it was a missing quotation set but I'm not sure where it should go

strsql="UPDATE software_signout SET signin_date='<%=date()%>',received_by='" & request("received_by") & "' where id=" & request("id") & ""

any help would be great

thanks in advance

August 12th, 2003, 02:08 PM

nopoints

Contributing User

Join Date: Jul 2003

Location: Windsor ON, Canada

Posts: 459

Time spent in forums: 13 h 44 m 22 sec
Reputation Power: 8

you are inside a script why do you have <%=date()%>?

Code:

strsql="UPDATE software_signout " & _
    "SET signin_date = '" & Date & "', " & _
    "received_by = '" & request("received_by") & "' " & _
    "where id = " & request("id")

__________________
Programmer's Corner

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Unterminated string constant in UPDATE statement

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump