Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sending @ to database

Author  Topic 

krajah
Starting Member

2 Posts

Posted - 2008-08-01 : 05:03:22
Hi All,
I'm having problem to send @ into database.Here is the code:

sql.execute("insert into email (useremail) values ("${userName}@my.example.com)")

Error message:

Exception thrown: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@my.example.com)' at line 1

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-01 : 05:07:22
quote:
Originally posted by krajah

Hi All,
I'm having problem to send @ into database.Here is the code:

sql.execute("insert into email (useremail) values ("${userName}@my.example.com)")

Error message:

Exception thrown: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@my.example.com)' at line 1



perhaps you should post in a MySQL forum

Em
Go to Top of Page

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-08-01 : 05:09:08
For mysql questions post at www.mysql.com


Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

krajah
Starting Member

2 Posts

Posted - 2008-08-01 : 05:38:20
Tq,For the information.
Go to Top of Page
   

- Advertisement -