1/1/1900 is the default date in MS SQL 2K (and, I assume, many other DBs).
It sounds like you didn't set a default date when you created the column, so
it's returning the system default.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -----Original Message-----
: From: Mike Miessen [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 26, 2002 1:34 PM
: To: CF-Talk
: Subject: RE: New User
:
:
: OK that sounds reasonable I'll try that. Now I'm trying to add a date
: display field but it is returning the same date each time 01/01/1900 and
: I know that's not right :)
:
: -----Original Message-----
: From: Timothy Heald [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 26, 2002 1:25 PM
: To: CF-Talk
: Subject: RE: New User
:
: You will need to put back in the leading % in case the word they are
: searching for is in the middle of a title.
:
: Example
:
: Search string = "Time"
:
: Will return = "Time to go"
:
: Will not return = "It's Time to go."
:
: Also someone else mentioned using upper(), on the column and the search
: string your looking for to get by the case sensitivity of the db, I
: would recommend you doing it as well.
:
: Tim
:
: -----Original Message-----
: From: Mike Miessen [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 26, 2002 1:15 PM
: To: CF-Talk
: Subject: RE: New User
:
:
: I took out the leading % and I dropped the ?TITLE from the action on the
: process button and my query now works. Thanks to you guys :)
:
: -----Original Message-----
: From: Clint Tredway [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 26, 2002 12:07 PM
: To: CF-Talk
: Subject: Re: New User
:
: Take out the leading % and your query will work. With both % in there
: this
: returns everything because to SQL, your string is like everything in the
: database.
:
: HTH,
: Clint
:
: ----- Original Message -----
: From: "Mike Miessen" <[EMAIL PROTECTED]>
: To: "CF-Talk" <[EMAIL PROTECTED]>
: Sent: Thursday, December 26, 2002 11:03 AM
: Subject: New User
:
:
: > I have been trying to do a search of a database. It is a very small
: > testing database and I wrote a search entry form with dream weaver
: with
: > one field. This field should search on the title field of the
: database
: > and return results that contain the entry. I am a raw newbie here and
: > contemplating beating my head against a wall on this. Well my query
: > does not seem to work. I get all the records returned every time not
: > just the ones that contain the search term.
: >
: > Here I was thinking this would be easy. Boy was I wrong! Here is my
: > code Can anyone tell me what I'm doing wrong? The path to the
: search
: > form is
: >
: > http://bluegrasspro.net/bluegrasspro/datasources/eventquery.cfm
: >
: >
: >
: > <cfquery name="rsTitle" datasource="bluegrasspro" username="LOL"
: > password="YeaRight" debug="yes">
: > <cfparam name="TITLE" default="null">
: > SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#TITLE#%'
: > </cfquery>
: >
: > <html>
: > <head>
: > <title>Query Results</title>
: > <meta http-equiv="Content-Type" content="text/html;
: charset=iso-8859-1">
: > </head>
: >
: > <body>
: > <cfoutput query="rsTitle">
: > #rsTitle.Title#<br>
: > </cfoutput>
: >
: > </body>
: > </html>
: >
: >
:
:
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
