Quote Escape Character?

[zimy]

Hi all,

trying to write vbscript using a function and FileWriteLine

however this is the problem i need to use single quotes in the query that I'm doing but i keep getting errors. Was wondering if there are any "escape" characters.

heres the line:

FileWriteLine($pcinfoscript, 'set colInstances = objSWbemServices.ExecQuery("SELECT * FROM MSNdis_80211_ServiceSetIdentifier WHERE Active = True AND InstanceName = & wifiAdapter &)' & @CRLF)

Need it to look like this:

set colInstances = objSwbemServices.ExecQuery _
  ("SELECT * FROM MSNdis_80211_ServiceSetIdentifier WHERE Active = True AND InstanceName ='" & wifiAdapter & "'")

I try the above in scite but like i said it throws an error, im assuming because of the single quote

-zimy

[Thatsgreat2345]

check it jsut throw in some where u need it to make a new line

& @CRLF &

"'set colInstances = objSWbemServices.ExecQuery(" & '"' & "SELECT * FROM MSNdis_80211_ServiceSetIdentifier WHERE Active = True AND InstanceName = & wifiAdapter &)" & "'" & @CRLF

Edited April 24, 2006 by thatsgreat2345

[zimy]

Thanks for the pointer, cant believe i missed that. Anywho I'm on the right track now two many quotes

[Thatsgreat2345]

hahah yeah there are alot it was troublesome im just like double quote single double single double single good times