Can some PLEASE tell me what this error means

2001-09-07 Thread Deryck Henson 

I am trying to input some data into the database when all of a
suddenPOOF!  This pops up!::

You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject(Scripting.F' at line 1

Is there anything I can doabout this?  The 'get file scripting object Set
objFileScripting = CreateObject(Scripting.F' stuff is part of this query::

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', ''get file scripting object Set objFileScripting =
CreateObject(Scripting.F', 'user', 'email', 'now')

I figured out that the ' before get is bad but how do I make it so that
when it is processed, that ' turns into something that can go into MySQL and
when it is shown on a web page, it gets turned back into a regular old ' ?

email me for clarification.

- Deryck H
- http://www.comp-u-exchange.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Can some PLEASE tell me what this error means

2001-09-07 Thread Cal Evans 

Add a \ before the '

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '\'get file scripting object Set objFileScripting =
CreateObject(Scripting.F', 'user', 'email', 'now')


Cal
http://www.calevans.com


-Original Message-
From: Deryck Henson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 07, 2001 6:30 PM
To: MySQL
Subject: Can some PLEASE tell me what this error means


I am trying to input some data into the database when all of a
suddenPOOF!  This pops up!::

You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject(Scripting.F' at line 1

Is there anything I can doabout this?  The 'get file scripting object Set
objFileScripting = CreateObject(Scripting.F' stuff is part of this query::

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', ''get file scripting object Set objFileScripting =
CreateObject(Scripting.F', 'user', 'email', 'now')

I figured out that the ' before get is bad but how do I make it so that
when it is processed, that ' turns into something that can go into MySQL and
when it is shown on a web page, it gets turned back into a regular old ' ?

email me for clarification.

- Deryck H
- http://www.comp-u-exchange.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can some PLEASE tell me what this error means

2001-09-07 Thread Deryck Henson 

Except the problem is, this is done through an Active Server Page (ASP).
The user does the inserting, I just use variables and insert them.
TRANSLATION::  I have no control over what goes in the database until it's
there.  So how can it be changed in the connection or sending process?

- Deryck H
- http://www.comp-u-exchange.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can some PLEASE tell me what this error means

2001-09-07 Thread Webmaster 

ASP question... not MySQL (if I understand correctly...)

But just do a replace...



variabletoinsert = replace(thevariablecomingin,',\')

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '  variabletoinsert  ', 'user', 'email', 'now')



you could write a quick function that you could call at will...

function fq(string)
fq = replace(string,',\')
end function


mystr = insert into asp (blah,blah,blah) values ('  fq(inblah)  ',' 
fq(inbalh)  ','  fq(inblah)  ')
conn.execute mystr



- Original Message -
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:10 PM
Subject: Re: Can some PLEASE tell me what this error means


 Except the problem is, this is done through an Active Server Page (ASP).
 The user does the inserting, I just use variables and insert them.
 TRANSLATION::  I have no control over what goes in the database until it's
 there.  So how can it be changed in the connection or sending process?

 - Deryck H
 - http://www.comp-u-exchange.com


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php