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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2006-12-18 : 15:37:53
|
| I'm executing the below stored proc and I'm passing some text to it. spGetStudent ' and u.id = 565887898 and u.id in (select app_id from this_form f inner join formType ft on f.formType_id = ft.formType_id where f.ff_id = 203 and ft.formType_name in (''Interviewer'', ''Screener''))'I'm getting the error when I execute the above stmt.Msg 105, Level 15, State 1, Line 43Unclosed quotation mark after the character string 'Inter'.Msg 102, Level 15, State 1, Line 43Incorrect syntax near 'Inter'. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-18 : 15:44:48
|
| Increase the parameters size form whatever it is now, to at least 21 characters longer.Why calc? Just set the parameter as VARCHAR(4000) directly.Peter LarssonHelsingborg, Sweden |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-12-18 : 16:00:17
|
quote:
Originally posted by Peso
Increase the parameters size form whatever it is now, to at least 21 characters longer.Why calc? Just set the parameter as VARCHAR(4000) directly.Peter LarssonHelsingborg, Sweden
Tack så mycket (hope that's correct). Peter your solution worked. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-18 : 16:22:38
|
Yes, that is correct!  Been on mission in Sweden?Peter LarssonHelsingborg, Sweden |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-12-18 : 16:28:57
|
quote:
Originally posted by Peso
Yes, that is correct! Been on mission in Sweden?Peter LarssonHelsingborg, Sweden
No - But I'd like to...got any available |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-19 : 23:20:41
|
| 1 Passing where condition is not effecient2 You should use parameters and pass values to themMadhivananFailing to plan is Planning to fail |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-12-20 : 08:32:08
|
I'm the receipient of this code and not the creator. I've taken over a fairly large .NET application so there are alot of things I'd do different.quote:
Originally posted by madhivanan
1 Passing where condition is not effecient2 You should use parameters and pass values to themMadhivananFailing to plan is Planning to fail
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
Escaping quotes in stored proc and getting error.