Convert string to Query Object?
I CFquery, it's cached, and pass the query name to another file as a string. I can CFoutput the cached query using the string but can't use it for a recordcount because it's a type mismatch. How do I convert that query name-string back to a query name-queryobject so I can get that recordcount. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Clients Can't Login - IE8 Caching?
Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Listserves vs. Message Boards
Rick Faircloth says: "A combo system (like we have here) does both and should be the way to go." (ok, what system/software is it?) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Listserves vs. Message Boards
> Find out *specifically* what your client wants (feature-wise), and > then investigate the technology that best matches that. The client doesn't know...they want the pros/cons. They want it on the site,,,not a third-party like a Yahoo Group (which I think is a good idea as it's both a listserv and a message board)... they want to member to be able to login to their account and control it. Someone said with the listserv they get the info as it's posted, but I know when someone posts to my threads on Facebook I get instant notice of that. And with a message board doesn't anyone who joins new gets to see the history of all the discussions? I have a modest user's understanding of both but it seems the first hurdle is in-site solutions. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Listserves vs. Message Boards
Client has requested listserves be implemented on the CF site I created. 1) Are there off the shelf solutions available? 2) Should I steer them toward a message board instead? (more powerful? flexible?) (They would far prefer it be available in the site so a third-site site would be out. But then again why not frames? Bad idea?) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: multipart/mixed? (cfmail, attachments, embedded image)
I've been working with my host (YoHost...Very receptive and helpful...5 stars), and have concluded there's something amiss with CFmail because when he sends me an email via post the content type comes (good) is mixed but with CFMAIL it's related...even when you explicitly specify mixed in cfmailpart. So thank you for those who took a look. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: input type="image" onclick jscript
My guess is because it's an input with type image so it's just going to submit instead of honor the onclick. Try onSubmit in the form tag. > Hi frnds, > > How to call a javascript function on > > height="22" onclick="callActionMethod('searchForm','search');return > true;" name="Searchbutton"> > > this function is not calling why? > > Rama ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: input type="image" onclick jscript
My guess is because it's an input with type image so it's just going to submit instead of honor the onclick. Try onSubmit in the form tag. > Hi frnds, > > How to call a javascript function on > > height="22" onclick="callActionMethod('searchForm','search');return > true;" name="Searchbutton"> > > this function is not calling why? > > Rama ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UltraDev 4 (Mac) for sale
I have a new Macromedia Dreamweaver UltraDev 4 (Mac) for sale. Please email if interested. [EMAIL PROTECTED] -- Dominant 7 Design - Affordable and Effective Communications for Small Business www.Dominant7.com "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Allaire on a Mac?
Anyone have any insight as to whether Allaire's apps will soon run on Macintosh as a result of the merger with Macromedia? -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia to Merge with Allaire
Macromedia to Merge with Allaire!!! http://www.Macromedia.com/ -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is it possible to use Rand() in a CFQUERY?
I'd like to ask a previous question in a different manner as it was suggested to me the way I originally phrased it wasn't clear. I'd like to use a rand() in a CFQUERY but get an error each and every time (is it even possible?). The Access database is being accessed through OLE if it matters. I want to do something like: select groupname, groupentry1, groupentry2, rand() as randcol from inventory order by randcol , groupname, groupentry1 DESC, groupentry2 DESC or perhaps? select rand(groupname) as randgroup, groupentry1, groupentry2 from inventory order by randgroup, groupentry1 DESC, groupentry2 DESC Right now I always get something like this (not random...each group output alphabetically) row1:Group A row2: a-1 row3: a-2 row4: a-3 row5: Group B row6: b-1 row7: b-2 row8: b-3 row9: Group C row10: c-1 row11: c-2 row12: c-3 I want the CFQUERY to randomize the groups, A, B, C; B C A, etc... so I can get: row1: Group B row2: b-1 row3: b-2 row4: b-3 row5: Group C row6: c-1 row7: c-2 row8: c-3 row9:Group A row10: a-1 row11: a-2 row12: a-3 I want it like this because this information is displayed over multiple pages and I pass the row number between the pages with a Next and Previous button. I hope this is clearer. Thank you, Randy M. Zeitman -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RAND() SQL follow Up
>I am dumbfounded how to use RAND() in a query statement. > >I have three columns for this example and I want the results randomly >sorted by the invcode column. That is, to randomly display how the >results are grouped. > >select invcode, price, years >from inventory >order by invcode, years DESC, price DESC > >I've tried the retrieve results in random order example in the mySQL >book, page 188, but it says syntax error. > >select invcode, price, RAND() as ran, years >from inventory > >I've also tried HAVING but no luck. This has to be simple but I just >can't find the variant in the syntax. This is a MS Access DB >connected by OLE. I also can't find any examples of the syntax in >Access books (nor on the Allaire site). > >Thank you, > >Randy Zeitman Paul writes: >My guess is that it's a MySQL special function. You might have to create >your own version using CF. > >For example, > >http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using RAND in SQL
I am dumbfounded how to use RAND() in a query statement. I have three columns for this example and I want the results randomly sorted by the invcode column. That is, to randomly display how the results are grouped. select invcode, price, years from inventory order by invcode, years DESC, price DESC I've tried the retrieve results in random order example in the mySQL book, page 188, but it says syntax error. select invcode, price, RAND() as ran, years from inventory I've also tried HAVING but no luck. This has to be simple but I just can't find the variant in the syntax. This is a MS Access DB connected by OLE. I also can't find any examples of the syntax in Access books (nor on the Allaire site). Thank you, Randy Zeitman -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Thanks for CF Help
I'd like to thank the group for the CF help needed to help create my first CF driver site! The site is http://www.guitarlist.com and, thanks for cold fusion, is the most powerful guitar, bass, and amp search engine on the net! Thank you, Randy M. Zeitman GuitarList.com 610.259.4123 -- "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman "Whatever is begun in anger ends in shame. -- Ben Franklin" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OLEDB CreateDate Problem - got it...
Apologies to Mr. Suh who did indeed answer the question by stating 'You must use the native DB syntax for dates...' So I am using Excel which I think is using the Jet driver and looked at my MySql book and simply wrote the date as the Date data type specified and ignored the CF tag. ( -MM-DD) The code below works. (I am noting it here for other novices like myself.) I believe I set the formatting of the excel date to General Date though I've not tried to see if it makes a difference. UPDATE testdate set aucdate = '#ye#-#mo#-#da#' where dID = 2 Thanks, Randy -- Signature.. "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CF-Talk V1 #86
Kwang, Thank you for the quick reply! I would like to follow your advice but I don't know howI had the same error without the CreateODBCDate conversion tag and can find no docs on OLE date formats. Should I not be using CreateDate? .. >You are using ODBC date formats for OLE DB, which does not support ODBC date formats. >You must use the native DB syntax for dates... -- Signature.. "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
OLEDB CreateDate Problem
After spending some time on this I've decided to ask help of the list: I was using the following to update my ODBC database without a hitch: UPDATE testdate set aucdate = #myDate# where dID = 1 But when I switched to OLE DB I get the following error - with or without the CreateODBCDate statement. .. Error Diagnostic Information OLEDB Error Code = -524553244 Malformed GUID. in query expression '{d '2000-12-24'}'. SQL = "UPDATE testdate set aucdate = {d '2000-12-24'} where dID = 1" Data Source = "GLIST1" .. -- Signature.. "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CF Docs in PDF Format
As I found the online CF docs a hassle to use (that is, not indexed or searchable), I've turned them into Acrobat PDF files which are quickly searchable. It's simply wonderful to be able to search for any number of examples using a certain keyword. I hope you enjoy them as well. http://www.chesco.com/~randzman/CFDOCS/ Randy Zeitman -- Signature.. "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.