Little Help with a Site Search Query
Working on setting up a site search - (SQL Server). Query below won't work as feature_text is a TEXT field mylst will ALWAYS be a comma delimited list (cleaned of all unwanted crap and common words) cfquery name=features SELECT id_feature, feature_headline, feature_date, year(feature_date) as theYEAR, feature_text FROM feature WHERE feature_headline in cfqueryparam value=#mylst# cfsqltype=CF_SQL_VARCHAR list=yes / cfloop list=#mylst# index=i OR feature_text like cfqueryparam value=%#i#% cfsqltype=CF_SQL_VARCHAR / /cfloop ORDER BY feature_date desc /cfquery So, I can use CAST() to fix this and convert feature_text to varCHAR? Something like: cfquery name=features SELECT id_feature, feature_headline, feature_date, year(feature_date) as theYEAR, CAST (feature_text AS VARCHAR ) FROM feature WHERE feature_headline in cfqueryparam value=#mylst# cfsqltype=CF_SQL_VARCHAR list=yes / cfloop list=#mylst# index=i OR CAST(feature_text as VARCHAR) like cfqueryparam value=%#i#% cfsqltype=CF_SQL_VARCHAR / /cfloop ORDER BY feature_date desc /cfquery But this gives me an odd Incorrect syntax near '@P1'. error Advise? __ Information from ESET NOD32 Antivirus, version of virus signature database 5138 (20100522) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Little Help with a Site Search Query
Hmmm - this will return NO results, though I know the terms I'm looking for exists: WHERE CAST(feature_text as VARCHAR) like cfqueryparam value=%#form.searchTERM#% cfsqltype=CF_SQL_VARCHAR / cfquery name=features SELECT id_feature, feature_headline, feature_date, year(feature_date) as theYEAR, CAST (feature_text AS VARCHAR ) FROM feature WHERE feature_headline in cfqueryparam value=#mylst# cfsqltype=CF_SQL_VARCHAR list=yes / cfloop list=#mylst# index=i OR CAST(feature_text as VARCHAR) like cfqueryparam value=%#i#% cfsqltype=CF_SQL_VARCHAR / /cfloop ORDER BY feature_date desc /cfquery __ Information from ESET NOD32 Antivirus, version of virus signature database 5138 (20100522) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: idea paint
I am not certain the reason for the link, but that website is one of the worst i've seen recently when viewed from my smartphone browser. william -Original Message- From: Brian Thornton vegasthorn...@gmail.com Sent: Friday, May 21, 2010 8:27 PM To: cf-talk cf-talk@houseoffusion.com Subject: idea paint http://www.ideapaint.com/work/installation/ -- Brian Thornton (303) 997-1777 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: idea paint
h I don't know about smartphones, but the blue colour is very nice :) though, I myself don't understand the reason of this link :) Maybe the reason is far glorified and incomprehensible than common man's understanding :p Regards, Arsalan -- From: William Seiter will...@seiter.com Sent: Saturday, May 22, 2010 9:32 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: idea paint I am not certain the reason for the link, but that website is one of the worst i've seen recently when viewed from my smartphone browser. william -Original Message- From: Brian Thornton vegasthorn...@gmail.com Sent: Friday, May 21, 2010 8:27 PM To: cf-talk cf-talk@houseoffusion.com Subject: idea paint http://www.ideapaint.com/work/installation/ -- Brian Thornton (303) 997-1777 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: idea paint
It's called spam. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflocation in cfc
bad idea? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: idea paint
On Sat, May 22, 2010 at 5:14 PM, Matt Quackenbush quackfu...@gmail.comwrote: It's called spam. Nah, Brian's a CF developer. I suspect he was just trying to share what he thought was kind of a cool idea. Might have been less misunderstood if he prefaced the link with, hey, this is kind of a cool idea... :) -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation in cfc
I would say so, yes... but given that you've given us no details, its very hard to say for sure. Sent from my mobile device On 23 May 2010 10:34, Matthew P. Smith m...@smithwebdesign.net wrote: bad idea? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Home Site+ and Windows 7
I just bought a new computer with Windows 7. My beloved Home Site+ won't work in Windows 7. It worked fine with XP and 2000. What are you all using for development on windows 7 that has similar functionality to Home Site+? I was also using the client tools of Enterprise Manager for SQL Server 2000 on Windows XP to remotely connect to my databases. Now I've read that won't work either on Windows 7. Any suggestions for that? Sebastian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: idea paint
hahaha... same thoughts different words (Y) Regards, Arsalan -- From: Matt Quackenbush quackfu...@gmail.com Sent: Sunday, May 23, 2010 5:14 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: idea paint It's called spam. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Home Site+ and Windows 7
Did you try to run it in XP compatability mode?? Sent from my iPhone On May 22, 2010, at 6:56 PM, s...@who.net s...@who.net s...@who.net wrote: I just bought a new computer with Windows 7. My beloved Home Site+ won't work in Windows 7. It worked fine with XP and 2000. What are you all using for development on windows 7 that has similar functionality to Home Site+? I was also using the client tools of Enterprise Manager for SQL Server 2000 on Windows XP to remotely connect to my databases. Now I've read that won't work either on Windows 7. Any suggestions for that? Sebastian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Home Site+ and Windows 7
Did you try to run it in XP compatability mode?? Sent from my iPhone On May 22, 2010, at 6:56 PM, s...@who.net s...@who.net s...@who.net wrote: William, I just did and it worked. kudos! Do you think the same thing can work with Enterprise Manager for SQL server 2000? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Home Site+ and Windows 7
That's a different beast... Try it, I guess Sent from my iPhone On May 22, 2010, at 7:15 PM, s...@who.net s...@who.net s...@who.net wrote: Did you try to run it in XP compatability mode?? Sent from my iPhone On May 22, 2010, at 6:56 PM, s...@who.net s...@who.net s...@who.net wrote: William, I just did and it worked. kudos! Do you think the same thing can work with Enterprise Manager for SQL server 2000? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Home Site+ and Windows 7
What are you all using for development on windows 7 that has similar functionality to Home Site+? I was going to suggest XP compatibility mode as well but I see you already have it working. As for Enterprise Manager, I believe it will work in compatibility mode also, but I'd suggest dropping it in favor of SQL Management Studio instead. It will still manage SQL Server 2000 just fine and is a lot more streamlined than Enterprise Manager was. I switched with the Windows upgrade and haven't looked back. On the editor front though, you can pry HomeSite from my cold, dead, hands (unless another EDITOR comes along which is better; I don't need a full-on IDE like CF Builder to get in my way). -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Little Help with a Site Search Query
This ended up doing it: XOXO is always the last list item... cfquery name=features datasource=#req.data# username=#req.user# password=#req.pass# SELECT id_feature, feature_headline, feature_date, year(feature_date) as theYEAR, feature_text FROM feature WHERE cfloop list=#lst.srchTHS# index=i feature_headline like cfqueryparam value=%#i#% cfsqltype=CF_SQL_VARCHAR / OR feature_text like cfqueryparam value=%#i#% cfsqltype=CF_SQL_VARCHAR / cfif #i# eq XOXOcfelseOR/cfif /cfloop ORDER by feature_date DESC /cfquery ...unless anybody has a better idea... lst.srchTHS won't ever be more then three to five words or so, but I wish I could figure a way to use cfqueryparam list=yes instead of a loop... __ Information from ESET NOD32 Antivirus, version of virus signature database 5138 (20100522) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
