•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 397,526 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,671 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1262 | Replies: 2
 |
•
•
Join Date: Dec 2007
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
ASP & VB and Unterminated String Constant Can someone take a look at this and possibly tell me what I'm missing here?
Get's this:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/rsd_image_library/X/input_text_to_db.asp, line 12
SQL = "INSERT INTO CDNumber (nCDNumber, tCDDescription, bStockorMiscImages)
---------------------------------------------------------------------------^
VBScript Syntax (Toggle Plain Text)
Get's this:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/rsd_image_library/X/input_text_to_db.asp, line 12
SQL = "INSERT INTO CDNumber (nCDNumber, tCDDescription, bStockorMiscImages)
---------------------------------------------------------------------------^
Last edited by vicshoup : Dec 19th, 2007 at 4:26 pm.
•
•
Join Date: Dec 2007
Posts: 75
Reputation:
Rep Power: 1
Solved Threads: 10
Junior Poster in Training
You have the SQL statement in two
separate lines. VBScript is interpreting the end of line as the end of statement.
You can:
a. remove the new line character so that all in on a single line
OR
b. append and underscore at the end of the first line so that when VBSCRIPT sees it, it knows the statent continues on the next line.
separate lines. VBScript is interpreting the end of line as the end of statement.
You can:
a. remove the new line character so that all in on a single line
SQL = "INSERT INTO CDNumber (nCDNumber, tCDDescription, bStockorMiscImages) VALUES ('"&u_CDNum&"','"&u_CDDesc&"','"&u_CDStock&"')"b. append and underscore at the end of the first line so that when VBSCRIPT sees it, it knows the statent continues on the next line.
SQL = "INSERT INTO CDNumber (nCDNumber, tCDDescription, bStockorMiscImages) _
VALUES ('"&u_CDNum&"','"&u_CDDesc&"','"&u_CDStock&"')" |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
Linear Mode
- Previous Thread: Select from a 2-dimensional array
- Next Thread: Is there a way to separate strings in Classic ASP
