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# </cfoutput> </body> </html>

| | | | |

Author:

Clint Tredway

12/26/2002 12:09 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101358

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 ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Mike Miessen

12/26/2002 01:18 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101370

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 :) 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 > 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 ----- Excess quoted text cut - see Original Post for more ----- charset=iso-8859-1"> ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Brian Ledwith

12/26/2002 01:35 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101373

You might want to plug that "%" back in, as Scott Brady mentioned. Using his "WHERE Title LIKE '%dog%'" example, if you take out the leading "%", the word "hotdog" wouldn't be returned, and I think you would want it to. On your site, if I search for "grass" I get nothing, but if I search for "blue", I get a number of results. See what I mean? With the leading and trailing "%", i.e. WHERE Title LIKE '%dog%' Hotdog, hotdogs, and dog and dogs would be returned With just the trailing "%", i.e. WHERE Title LIKE 'dog%' Dog and dogs would be returned, but not hotdog or hotdogs With just the leading "%", i.e. WHERE Title LIKE '%dog' Dog and hotdog would be returned, but not hotdogs or dogs HTH, ~bgl --> -----Original Message----- -- --> Sent: Thursday, December 26, 2002 10:15 AM --> 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----- -- --> 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" <mdmiessen@indy.rr.com> --> To: "CF-Talk" <cf-talk@houseoffusion.com> --> 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# --> > </cfoutput> --> > --> > </body> --> > </html> --> > --> > --> -->

| | | | |

Author:

Mike Miessen

12/26/2002 09:09 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101437

Very good, just the type of help I was looking for. Is that an SQL thing or a cold fusion thing? I was wondering what the % sign was for LOL. You might want to plug that "%" back in, as Scott Brady mentioned. Using his "WHERE Title LIKE '%dog%'" example, if you take out the leading "%", the word "hotdog" wouldn't be returned, and I think you would want it to. On your site, if I search for "grass" I get nothing, but if I search for "blue", I get a number of results. See what I mean? With the leading and trailing "%", i.e. WHERE Title LIKE '%dog%' Hotdog, hotdogs, and dog and dogs would be returned With just the trailing "%", i.e. WHERE Title LIKE 'dog%' Dog and dogs would be returned, but not hotdog or hotdogs With just the leading "%", i.e. WHERE Title LIKE '%dog' Dog and hotdog would be returned, but not hotdogs or dogs HTH, ~bgl --> -----Original Message----- -- --> Sent: Thursday, December 26, 2002 10:15 AM --> 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----- -- --> 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" <mdmiessen@indy.rr.com> --> To: "CF-Talk" <cf-talk@houseoffusion.com> --> 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# --> > </cfoutput> --> > --> > </body> --> > </html> --> > --> > --> -->

| | | | |

Author:

Brian Ledwith

12/26/2002 12:12 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101360

On your submission form, you have "TitleSearchResults.cfm?TITLE". Take out the "?Title" and it works fine. --> -----Original Message----- -- --> Sent: Thursday, December 26, 2002 9:04 AM --> To: CF-Talk --> 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# --> </cfoutput> --> --> </body> --> </html> --> -->

| | | | |

Author:

Ben Doom

12/26/2002 12:15 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101362

Why is the action for your form titlesearchresulsts.cfm?title ? I would bet that that the fact that you are sending a null title in the url and a title in the form is screwing up the scoping. Further, if I were you, I'd scope title if possible. If you know it is always submitted from a form via post, reference form.title instead (both in the query and the cfparam). That will avoid possible confusion in the future. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 12:04 PM : To: CF-Talk : 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# : </cfoutput> : : </body> : </html> : :

| | | | |

Author:

Mike Miessen

12/26/2002 12:44 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101369

I thank you all for the guidance. I will be looking at all of this soon. I have also been fighting a battle with response times from my server. This is not the fault of CF but rather a problem with our carrier. We are tied into Cogentco and AOL has unexpectedly pulled one of their servers from the pipe. This has caused a major hole in the web that is affecting response times such that even the most minor change takes several minutes to make. This has added greatly to my frustration. I hope none of you have this problem. Cogent Service Slows to a Crawl Peering with AOL shut off Written by Justin Beech Cogent customers received the bad news that recent slowdowns may have been caused by AOL shutting off its peer (direct connection) to Cogent. No explanation was offered for why AOL might be doing that. 12/19 According to Cogent NOC support staff, the Cogent and Level 3 attorneys will meet on 12/22 to discuss the week-long outage caused when AOL shut off a large bandwidth pipes for peering between Cogent and AOL. 12/17 - Letters from Cogent acknowledge the slowdown: Dear Cogent Customer, We are very sorry to hear you are experiencing problems with your connection. The issue in this case is with AOL. We have had an ongoing peering relationship with them based on a connection of 2 OC-12s. We recently upgraded these connections to include 2 OC-48s to accommodate our significant traffic exchange. These connections have been up and running smoothly for 2 weeks now. Overall, we've spent over $100 thousand to create this robust peering infrastructure. This week, however, AOL announced a unilateral decision to cut off all our connections. This announcement came as a surprise to all involved and the reasons behind it remain unclear. We are struggling to make sense of AOL's decision and are working around the clock to try to get it resolved. If, by next week, you haven't seen some improvement, feel free to call us back. We want to assure you that we are trying our best to stay on top of this critical issue and give our customers the best service possible. We're aware that this is affecting some of our customers and we are working to improve things as quickly as possible. Thank you for your patience. We understand this affects your business and we apologize for the temporary performance lapse. We encourage you to contact the AOL Customer Support number at 800.827.6364 and/or AOL NOC Support at 703.265.5431 to register your complaints towards AOL. Sincerely, Cogent Support 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# </cfoutput> </body> </html>

| | | |

Author:

Timothy Heald

12/26/2002 12:11 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101359

Try getting rid of the CFPARAM and scoping the #title# variable to form.title. Also if I were you I would output #form.title# above the query to make sure it's passing the correct value. Tim 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# </cfoutput> </body> </html>

| | | |

Author:

Everett, Al

12/26/2002 12:14 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101361

If there is no value in the TITLE variable you will get the behavior you're seeing. 1. Scope your variable. Form.Title instead of Title. 2. Trap for no value. <cfif IsDefined("Form.Title") AND Len(Trim(Form.Title)) GT 0> <cfquery ...> ... </cfif> 3. SQL is case-sensitive. If you want case-insensitivity do something like this in your WHERE clause: UPPER(Title) LIKE '%#UCase(Form.TITLE)#%' ----- Excess quoted text cut - see Original Post for more -----

| | | |

Author:

Scott Brady

12/26/2002 12:16 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101363

>> SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#TITLE#%' >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. I don't think so. If the variable "TITLE" is "dog", then the where clause is "WHERE Title LIKE '%dog%'" which shouldn't return the entire table. My guess is that "TITLE" ends up being an empty string (WHERE Title LIKE '%%'), which brings back the entire table. Try outputting the variable "TITLE" and see what you get. I'd also recommend scoping the variable, in case there is another variable called Title in your page which is screwing you up. Scott -------------------------------- Scott Brady http://www.scottbrady.net/

| | | |

Author:

Jerry Johnson

12/26/2002 12:19 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101364

I think it is your submit page form tag. <form name="EventTitleSearch" method="post" action="TitleSearchResults.cfm?TITLE" > you are going to end up with two "Title" variables on the results page, one passed by the url line and one by the form. Cold Fusion has to pick one of these two to default to, and it is going to default to the url version (always). So you can do a couple of things: 1. remove the ?title in the form action parameter. 2. specify the scope of the title variable in the results page <cfparam name="form.TITLE" default="null"> <cfquery name="rsTitle" datasource="bluegrasspro" username="LOL" password="YeaRight" debug="yes"> SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#form.TITLE#%' </cfquery> And I would move the cfparam out of the cfquery and place it one line above it. HTH Jerry Johnson >>> mdmiessen@indy.rr.com 12/26/02 12:03PM >>> 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# </cfoutput> </body> </html>

| | | |

Author:

Ali Daniali

12/26/2002 12:22 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101365

I may be wrong on this but I don't think you can put <cfparam name="TITLE" default="null"> in the <cfquery> tag pairs. Try this <cfparam name="TITLE" default="null"> <cfquery name="rsTitle" datasource="bluegrasspro" username="LOL" password="YeaRight" debug="yes"> SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#TITLE#%' </cfquery> Hope this works. -AD 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# </cfoutput> </body> </html>

| | | |

Author:

Timothy Heald

12/26/2002 01:30 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101372

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 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 :) 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 > 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 ----- Excess quoted text cut - see Original Post for more ----- charset=iso-8859-1"> ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Mike Miessen

12/26/2002 01:38 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101374

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 :) 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 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 :) 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 > 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 ----- Excess quoted text cut - see Original Post for more ----- charset=iso-8859-1"> ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Tony Weeg

12/26/2002 01:42 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101375

try this #DateFormat(yourDateField,'mm/dd/yyyy')# ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 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 :) 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 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 :) 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 > 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 ----- Excess quoted text cut - see Original Post for more ----- charset=iso-8859-1"> ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Mike Miessen

12/26/2002 01:57 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101377

Well I had double quotes so I changed that. <cfoutput query="rsTitle"> #dateformat(Event_Date, 'dd/mmm/yyyy')# #rsTitle.Title# </cfoutput> I still get the same type of problem however. Seems I get the same date for all entries and a date that does not exist in the database at that. 01/Jan/1900 Sacred Ground 01/Jan/1900 Sacred Ground 01/Jan/1900 Sacred Ground 01/Jan/1900 Sacred Ground try this #DateFormat(yourDateField,'mm/dd/yyyy')# ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 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 :) 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 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 :) 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 > 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 ----- Excess quoted text cut - see Original Post for more ----- charset=iso-8859-1"> ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Ben Doom

12/26/2002 01:55 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101376

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----- : : 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----- : : 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----- : : 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----- : : 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" <mdmiessen@indy.rr.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : 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# : > </cfoutput> : > : > </body> : > </html> : > : > : : : :

| | | | |

Author:

Mike Miessen

12/26/2002 01:59 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101378

How do I set a default date? 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----- : : 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----- : : 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----- : : 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----- : : 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" <mdmiessen@indy.rr.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : 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# : > </cfoutput> : > : > </body> : > </html> : > : > : : : :

| | | | |

Author:

Ben Doom

12/26/2002 02:05 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101379

Depends on the DB. In MS-SQL you can set it in Server Enterprise Manager pretty easily in the define table view. The easiest thing here, if that is the DB you're using and you have access to the Manager, is to remove that column from the table and recreate it with a default value (look at the options in the bottom half of the screen). If it's something else, you'll have to ask someone else. :-) --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:56 PM : To: CF-Talk : Subject: RE: New User : : : How do I set a default date? : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | | |

Author:

Mike Miessen

12/26/2002 02:12 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101384

I may have to wait for my system admin to do this for me. I'm encouraging him to join this list. He is trying to learn this stuff too. We are both new to it. I apologize for all the stupid questions but we have gotten in over our head I suppose. It has been quite a ride. Depends on the DB. In MS-SQL you can set it in Server Enterprise Manager pretty easily in the define table view. The easiest thing here, if that is the DB you're using and you have access to the Manager, is to remove that column from the table and recreate it with a default value (look at the options in the bottom half of the screen). If it's something else, you'll have to ask someone else. :-) --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:56 PM : To: CF-Talk : Subject: RE: New User : : : How do I set a default date? : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | | |

Author:

Clint Tredway

12/26/2002 02:06 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101380

Assuming you are using SQL 2K... Go into enterprise manager and go into the table design view. click on your date field and then in the default value field, type getdate(). Now save your table and your done. HTH Clint ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Mike Miessen

12/26/2002 02:15 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101386

We have mySQL database but I didn't set it up myself. I'll talk to Kevin (My system guy) when he becomes available and maybe he can show me how to do this. We are both learning. Assuming you are using SQL 2K... Go into enterprise manager and go into the table design view. click on your date field and then in the default value field, type getdate(). Now save your table and your done. HTH Clint ----- Excess quoted text cut - see Original Post for more ----- date ----- Excess quoted text cut - see Original Post for more ----- there ----- Excess quoted text cut - see Original Post for more ----- small ----- Excess quoted text cut - see Original Post for more ----- query ----- Excess quoted text cut - see Original Post for more -----

| | | | |

Author:

Mike Miessen

12/26/2002 02:08 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101382

I tried <cfparam name="Event_Date" default="1/1/2002"> both inside and just before the cfquery but it seems to make no difference. 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----- : : 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----- : : 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----- : : 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----- : : 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" <mdmiessen@indy.rr.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : 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# : > </cfoutput> : > : > </body> : > </html> : > : > : : : :

| | | | |

Author:

Ben Doom

12/26/2002 02:14 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101385

CFParam creates a default value for a CF variable (if the variable does not exist, it creates it and assigns that value). It has nothing to do with the data in the DB. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:03 PM : To: CF-Talk : Subject: RE: New User : : : I tried : : <cfparam name="Event_Date" default="1/1/2002"> : : both inside and just before the cfquery but it seems to make no : difference. : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | | |

Author:

Mike Miessen

12/26/2002 02:20 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101388

Ok thanks. I'll check with Kevin on this (My system guy) he set up the database and I guess I need to find out how he did it. CFParam creates a default value for a CF variable (if the variable does not exist, it creates it and assigns that value). It has nothing to do with the data in the DB. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:03 PM : To: CF-Talk : Subject: RE: New User : : : I tried : : <cfparam name="Event_Date" default="1/1/2002"> : : both inside and just before the cfquery but it seems to make no : difference. : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | | |

Author:

Mike Miessen

12/26/2002 02:47 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101394

Well I was thinking. Dangerous activity for me but here it is. Why would the event_date be returning the default date. I assumed it would return the date associated with the record being returned from the search. CFParam creates a default value for a CF variable (if the variable does not exist, it creates it and assigns that value). It has nothing to do with the data in the DB. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:03 PM : To: CF-Talk : Subject: RE: New User : : : I tried : : <cfparam name="Event_Date" default="1/1/2002"> : : both inside and just before the cfquery but it seems to make no : difference. : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | | |

Author:

Ben Doom

12/26/2002 03:00 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101395

What date associated with the record? The DB does not (as far as I know) associate a creation or update datestamp with the data -- that's left up to you if you want it. Any associated date is one you created. Now, if you are creating and setting a datestamp to, say, yesterday, but it's returning the system default, that's a whole 'nother story. But it sounds like you were just assuming that the creation date of the record would be accessible via a datetime field. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:44 PM : To: CF-Talk : Subject: RE: New User : : : Well I was thinking. Dangerous activity for me but here it is. Why : would the event_date be returning the default date. I assumed it would : return the date associated with the record being returned from the : search. : : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:10 PM : To: CF-Talk : Subject: RE: New User : : CFParam creates a default value for a CF variable (if the variable does : not : exist, it creates it and assigns that value). It has nothing to do with : the : data in the DB. : : : : : : --Ben Doom : Programmer & General Lackey : Moonbow Software : : : -----Original Message----- : : : : Sent: Thursday, December 26, 2002 2:03 PM : : To: CF-Talk : : Subject: RE: New User : : : : : : I tried : : : : <cfparam name="Event_Date" default="1/1/2002"> : : : : both inside and just before the cfquery but it seems to make no : : difference. : : : : -----Original Message----- : : : : Sent: Thursday, December 26, 2002 1:52 PM : : To: CF-Talk : : Subject: RE: New User : : : : 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----- : : : : : : 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----- : : : : : : 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----- : : : : : : 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----- : : : : : : 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" <mdmiessen@indy.rr.com> : : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : : 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# : : : > </cfoutput> : : : > : : : > </body> : : : > </html> : : : > : : : > : : : : : : : : : : : : : : : : : :

| | | | |

Author:

Rick Faircloth

12/26/2002 03:50 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101408

Hi, Mike. I'm new to mySQL also, and was having a problem inserting dates into a db. Before using mySQL , I used <CFSET Form.Date = #CreateODBCDate(Form.Date)#> before inserting into the db. I would do that before the query to format the date for the db, regardless of how the user entered the date...2/2/2002 or 02 Feb 2002, or whatever. However, this didn't work with mySQL. I went to this statement to insert my date, whether it was for an insert query or update query: <cfqueryparam cfsqltype="CF_SQL_DATE" Value=#DateFormat(CreateODBCDate(Form.Date), 'M/D/YYYY')#"> I didn't change the default date format for mySQL, and that format may work for you. But if you change the default format for your mySQL field, you may have to modify the 'M/D/YYYY' date format to match. HTH, Rick Rick Faircloth, Prism Productions Well I was thinking. Dangerous activity for me but here it is. Why would the event_date be returning the default date. I assumed it would return the date associated with the record being returned from the search. CFParam creates a default value for a CF variable (if the variable does not exist, it creates it and assigns that value). It has nothing to do with the data in the DB. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : : Sent: Thursday, December 26, 2002 2:03 PM : To: CF-Talk : Subject: RE: New User : : : I tried : : <cfparam name="Event_Date" default="1/1/2002"> : : both inside and just before the cfquery but it seems to make no : difference. : : -----Original Message----- : : Sent: Thursday, December 26, 2002 1:52 PM : To: CF-Talk : Subject: RE: New User : : 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----- : : : : 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----- : : : : 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----- : : : : 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----- : : : : 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" <mdmiessen@indy.rr.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : 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# : : > </cfoutput> : : > : : > </body> : : > </html> : : > : : > : : : : : : : : : :

| | | |

Author:

Jerry Johnson

12/26/2002 03:31 PM

Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:20052#101402

The first thing you need to do is find out how the date field is defined in the db. It could be a TIMESTAMP, a DATE or a DATETIME. Each functions very differently. You can use show to get the structure of the table: SHOW FULL COLUMNS FROM tbl_name this will let you see how the db is currently constructed. (If you need the rest of the code to return the query and loop through the results, let me know) You are using Mysql. Are you also using the MyODBC driver? I don't know the truth of the following statement, since I alsways set the date fields myself, rather than defaulting, but this comment is on one of the miriad mysql docs mirrors: Joe <mysql@chesak.com>: For clarity regarding default values, the following two sentences should be added to this page... Default values must be constants. This means you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. Unfortunately, this dashes my hopes of creating a table that automatically generates both a date created and a date modified for each of its records... :( Also, there was this note: ``Zero'' date or time values used through MyODBC are converted automatically to NULL in MyODBC Version 2.50.12 and above, because ODBC can't handle such values. So, if you can let me know what type the date column is, we can work from there. Jerry >>> mdmiessen@indy.rr.com 12/26/02 02:10PM >>> We have mySQL database but I didn't set it up myself. I'll talk to Kevin (My system guy) when he becomes available and maybe he can show me how to do this. We are both learning. Assuming you are using SQL 2K... Go into enterprise manager and go into the table design view. click on your date field and then in the default value field, type getdate(). Now save your table and your done. HTH Clint ----- Excess quoted text cut - see Original Post for more ----- date ----- Excess quoted text cut - see Original Post for more ----- there ----- Excess quoted text cut - see Original Post for more ----- small ----- Excess quoted text cut - see Original Post for more ----- query ----- Excess quoted text cut - see Original Post for more -----

July 31, 2010

Fusion Authority Quarterly Update - Latest Issue - Volume 3, Issue 2

Fusion Authority Quarterly Update - Latest Issue - Volume 3, Issue 1

Latest Fusion Authority Articles

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?

New User

Search cf-talk

July 31, 2010

Latest Fusion Authority Articles

Want a number like 800-ColdFusion?