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.
| Author |
Topic |
|
Pradhumn
Starting Member
1 Post |
 Posted - 2013-04-14 : 08:32:02
|
| (" SELECT *FROM mobileWHERE prize>="+f1+"AND prize<= "+f2+" }error: unclosed String Literal |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-14 : 13:31:24
|
quote:
Originally posted by Pradhumn
(" SELECT *FROM mobileWHERE prize>="+f1+"AND prize<= "+f2+" }error: unclosed String Literal
Where are you composing this query? In a client program? Are you trying to use dynamic SQL? Regardless of that, I see a few problems:1. You have unmatched brackets - "(" on the left and "}" on the right.2. you have an unmatched number of double-quotes - total of 5.3. If you are using T-SQL, and assuming f1 and f2 are local variables, they should be something like @f1 and @f2. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-15 : 02:07:16
|
| unless you provide us full statement its hard to understand where exactly you're trying to form the query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
i got error in sql syntext