Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JimmySkliff
- Order by date
-
text data type
Hey Dude.... I use plenty of Text columns and I have never run into the problem that you have come across. Please show me some code from you web pages so I can look through it and see if that is where your problem lies. The reason I believe it may be your code is that SQL will take a string as...- JimmySkliff
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Recordcount issue
Pretty much.....Try specifying your cusor type. Since your default cursor type is Foward Only you will always get a return of -1. Make it either an OpenKeyset or Dynamic and you will see different results......- JimmySkliff
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
Problem with order by and Union
The ORDER BY clause can include items not appearing in the select list; however, if SELECT DISTINCT is specified or if the SELECT statement contains a UNION operator, the sort columns must appear in the select list. Furthermore, when the SELECT statement includes a UNION operator, the column...- JimmySkliff
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Storing pointers to a .pdf or .doc file in SQL
Hello... I'm presently stuck with a situation where I need to store a pointer in my database to an actual .pdf or .doc file on my server. I am using ASP as my front end and I need for users to access these files and also upload files to my DB from the web page...I'm not quite sure as how to do...- JimmySkliff
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
