Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


escape character - single quotes

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,65084
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> escape character - single quotes
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
escape character - single quotes - 10/14/2008 7:41:33 PM   
  meerkat

 

Posts: 16
Score: 0
Joined: 9/21/2008
Status: offline 		Hi,

I need to include something like the following in a vbscript:-

query = "SELECT F1 AS DebtorName, F2 AS DebtorReference FROM SalesItems WHERE F4 NOT IN (SELECT F5 from salesitems where F5 <> ' ')"

However, I am having a little difficulty with the single quote marks as vbscript thinks that anything onwards is a comment. I have tried putting the quote marks within double quotes but I get the same problem. Is there any quick and easy solution to this?

meerkat

< Message edited by meerkat -- 10/14/2008 9:35:10 PM >
 
 
Post #: 1
 
RE: escape character - single quotes - 10/14/2008 9:36:20 PM   
  meerkat

 

Posts: 16
Score: 0
Joined: 9/21/2008
Status: offline 		 
Self-solved. The single quotes were not the problem.

Thanks anyway!

(in reply to meerkat)
 
 
Post #: 2
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> escape character - single quotes Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI