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 strongm 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: ProgrammerAndy
- Order by date
-
Seperate Selection Criteria for each row?
Your example is confusing. The SQL statemets are not correct to begin with. Are you trying to get the recommendation from the table goodrec where your score or value equals 1 or 3?? if so your sql should read: Select GoodRec.Recommendation[1] ' for recommendation1 FROM GoodRec where value =...- ProgrammerAndy
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
How do I determine the datatype in a recordset?
here is my dilemia I open a recordset and I need to determine if my value is numeric, date, or char. It works as long as I do not have a number in a text field. The statement sees this as a numeric value yet it is not. Any suggestions on how I tell the code to treat this as a text? Oh yes...- ProgrammerAndy
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with Datetime
I have an ASP page with an input field that will input a date. In my SQL 7.0 database i allows NULLS in my field that is set to datatype datetime. But when i do an INSERT or an UPDATE to the database, and this input field is left blank, it automatically in inserting the date 1/1/1900. Does...- ProgrammerAndy
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
