February 28, 2004 at 3:41 am
i have a query apended to a command object
command.comandtext=somequery
like this
query is fine and working
but when i try to set it to ADO recordset
it does not show any Records,
anybody knows why ?, but when i paste the same query in query analyzer it works,
anybody knows why.
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
February 28, 2004 at 1:13 pm
Can you provide more information on your ADO code?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 29, 2004 at 1:27 pm
Do you get a empty recordset? (Set nocount off)
March 1, 2004 at 1:55 am
thanks to u ppl for ur interst
i got the solution,
solution is-->
i did cast( fieldname as varchar(20)) or something for each and it worked..
each and every field was
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply