Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 help with a sql string		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 19 April 2001 :  12:26:54  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
im trying to pull all post that are greater then a date here is what it is doing. can someone please tell me what im doing wrong?

SELECT M_USERNAME, FROM MEMBERS WHERE (M_DOB > '4/19/1911 11:29:31 AM')

This is actually a date field, i dont use the snitz date converting function

Brad

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 19 April 2001 :  13:02:01  Show Profile  Visit HuwR's Homepage
you have a comma after username that shouldn't be there
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 19 April 2001 :  14:36:51  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
huwr,

sorry but the sql string was a VERY long one so i just took most of it out and forgot that ,

I swear i made it a datetime field, but after a couple hours slamming my head on the desk i found that i didnt make it a datetime

i fixed it and its works now, but thanks anyway

Brad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07