Can anyone tell me where I am missing a comma (Oracle)

[jwadz]

'When I run the SQL statement below in an ASP page using VB script I have
the following error returned 'Missing Comma'. I am running Oracle as my DB.
Any suggestions?

Thanks in advance

SQLInsrtBk = "INSERT INTO tbtext"&_
"(tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt, "&_
"tbtext_edition_num, tbtext_isbn_txt, tbtext_price_amt, tbtext_create_tms,
tbtext_create_nm)"&_
"VALUES(tbtext_id.nextval, '"& Publisher &"', '"& Author &"', '"& Title &"',
"&_
"& Edition &, '"& ISBN &"', & Price &, TO_DATE('"& InsrtDate &"', 'MM-DD-YYYY'),
'"& session("logonuser")& "')"

[Kimoanh T. Vo]

Hi,

Please test this one out to see if it works ...

SQLInsrtBk = "INSERT INTO tbtext (" &_
"tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt,
" &_
"tbtext_edition_num, tbtext_isbn_txt, tbtext_price_amt, tbtext_create_tms,
tbtext_create_nm ) " &_
"VALUES ( tbtext_id.nextval, '" & Publisher & "', '" & Author & "', '"
& Title & "', " & Edition & ", '" &_
ISBN & "', " & Price & ", TO_DATE( '" & InsrtDate & "', 'MM-DD-YYYY'
), '" & session( "logonuser" ) & "' )"

Hope it helps.
kv-



"jwadz" <jwadz626@uwsp.edu> wrote:
>
>'When I run the SQL statement below in an ASP page using VB script I have
>the following error returned 'Missing Comma'. I am running Oracle as my
DB.
>Any suggestions?
>
>Thanks in advance
>
>SQLInsrtBk = "INSERT INTO tbtext"&_
>"(tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt,
"&_
>"tbtext_edition_num, tbtext_isbn_txt, tbtext_price_amt, tbtext_create_tms,
>tbtext_create_nm)"&_
>"VALUES(tbtext_id.nextval, '"& Publisher &"', '"& Author &"', '"& Title
&"',
>"&_
>"& Edition &, '"& ISBN &"', & Price &, TO_DATE('"& InsrtDate &"', 'MM-DD-YYYY'),
>'"& session("logonuser")& "')"
>

[jwadz]

Excellent. Now I get a date error but I can fix that one. Thank you very much.


PS Stupid Quotes




"Kimoanh T. Vo" <kvo@dreamworks.com> wrote:
>
>Hi,
>
>Please test this one out to see if it works ...
>
>SQLInsrtBk = "INSERT INTO tbtext (" &_
> "tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt,
>" &_
> "tbtext_edition_num, tbtext_isbn_txt, tbtext_price_amt, tbtext_create_tms,
>tbtext_create_nm ) " &_
> "VALUES ( tbtext_id.nextval, '" & Publisher & "', '" & Author & "',
'"
>& Title & "', " & Edition & ", '" &_
> ISBN & "', " & Price & ", TO_DATE( '" & InsrtDate & "', 'MM-DD-YYYY'
>), '" & session( "logonuser" ) & "' )"
>
>Hope it helps.
>kv-
>
>
>
>"jwadz" <jwadz626@uwsp.edu> wrote:
>>
>>'When I run the SQL statement below in an ASP page using VB script I have
>>the following error returned 'Missing Comma'. I am running Oracle as my
>DB.
>>Any suggestions?
>>
>>Thanks in advance
>>
>>SQLInsrtBk = "INSERT INTO tbtext"&_
>>"(tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt,
>"&_
>>"tbtext_edition_num, tbtext_isbn_txt, tbtext_price_amt, tbtext_create_tms,
>>tbtext_create_nm)"&_
>>"VALUES(tbtext_id.nextval, '"& Publisher &"', '"& Author &"', '"& Title
>&"',
>>"&_
>>"& Edition &, '"& ISBN &"', & Price &, TO_DATE('"& InsrtDate &"', 'MM-DD-YYYY'),
>>'"& session("logonuser")& "')"
>>
>