Re: SELECT DISTINCT in Access ODBC truncates MEMO field?
Replying to my own post: Now that I've thought about it a bit more, I guess this behavior makes sense. Asking the database to read/compare the entire value of a memo field would add considerable overhead to a "select distinct" query. Just wish I'd known about it sooner! - Original Message - From: "Ricq Pattay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 10:53 AM Subject: SELECT DISTINCT in Access ODBC truncates MEMO field? > OK, this is weird: > > > > select id, exp_id, title, org, date_range, hours, description > from experiences > where id = #session.suserid# > > > > returns the full value of the "description" field, which is type MEMO. > > However, > > > > select distinct id, exp_id, title, org, date_range, hours, description > from experiences > where id = #session.suserid# > > > > truncates "description" to 255 characters. Why? (CF 5, Access ODBC data source) > > > Ricq Pattay > Senior Analyst/Programmer > College of Veterinary Medicine > University of Minnesota - Twin Cities > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: SELECT DISTINCT in Access ODBC truncates MEMO field?
Thanks for the clarification. Makes perfect sense. The only reason I put the distinct in there in the first place (not realizing the consequences) was that the data being given to us was so flaky. Ricq - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 11:31 AM Subject: Re: SELECT DISTINCT in Access ODBC truncates MEMO field? > You sooo do not want to select distinct on a memo field... > > If you need memo data, you want to either select everything else and then > select the memo data individually, or select without the distinct. For > smaller data ( number, varchar(20) and the like ) distinct sometimes returns > results faster because the result set is smaller, but with memo data, the > likelyhood is that the distinct ( if applicable ) will make the query take > much longer to return, because -- assuming the distinct even works on a memo > field ( I don't think it's even valid in MS SQL Server ) the database > drivers have to compare every character of what could be tens or hundreds of > thousands of characters in a given record against the same character > position in every other record returned. -- probably most of the time it's > going to get to drop out of that routine within the first 20 or so > characters, but it's just not worth the potential overhead. > > Probably this is why the memo data is trucated at 255 characters -- the > folks at MS implemented the distinct keyword to automatically convert memo > data to varchar(255) for distinct comparisons to prevent them hozing up a > query or worse. > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > > > OK, this is weird: > > > > > > > select id, exp_id, title, org, date_range, hours, description > > from experiences > > where id = #session.suserid# > > > > > > > returns the full value of the "description" field, which is type MEMO. > > > However, > > > > > > > select distinct id, exp_id, title, org, date_range, hours, description > > from experiences > > where id = #session.suserid# > > > > > > > truncates "description" to 255 characters. Why? (CF 5, Access ODBC data > > source) > > > > Ricq Pattay > > Senior Analyst/Programmer > > College of Veterinary Medicine > > University of Minnesota - Twin Cities > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Browser Printing Question
http://www.meadroid.com/scriptx/index.htm - Original Message - > On 11/11/02 7:31 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > When printing from a browser is there anyway to disable the printer to not > > print the url and path at the bottom of the page? > > > > ... > > Get your own free email account from > > http://www.popmail.com > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Printing Landscape
http://www.meadroid.com/scriptx/ With the 'basic' [i.e., free] subset, you can only script header, footer, page margins, paper orientation, Print and PageSetup methods and properties Very nice and easy to use. Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities - Original Message - From: "Bhandari, Sona" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 8:04 AM Subject: Printing Landscape > Hello, > > I have a Cold Fusion application that produces several reports. The report > is best printed in landscape format. However, when I try to print it from > the browser, the default setting in Internet Explorer 5.0 is portrait. Is > there a way I can change the print setting to Landscape? Thanks for your > help. > > Sona > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFINPUT required="yes" fails in MX?
It appears that the "required=yes" option no longer works in cfinput on MX...? I haven't used cfinput in over a year, but a co-worker just noticed this behaviour on our new MX development box. The above form is submitted even when "test" is blank. Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFINPUT required="yes" fails in MX?
Never mind, our server guy fixed it. The file "form.js" was not in the expected place because of a virtual server issue. Adding a /CFIDE/ alias to the apache conf file fixed the problem. - Original Message ----- From: "Ricq Pattay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 10:38 AM Subject: CFINPUT required="yes" fails in MX? > It appears that the "required=yes" option no longer works in cfinput on MX...? I haven't used cfinput in over a year, but a co-worker just noticed this behaviour on our new MX development box. > > > > > > > The above form is submitted even when "test" is blank. > > > > Ricq Pattay > Senior Analyst/Programmer > College of Veterinary Medicine > University of Minnesota - Twin Cities > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Query Problem with Session Variables
Try: SELECT User_ID, FullName, Login FROM Users WHERE User_ID = #session.user_ID# ORDER BY Login And you'll probably need single quotes around #session.User_ID# if it's a non-numeric field. ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Jeremy Toevs <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 10:08 AM Subject: CF Query Problem with Session Variables Hey CF People, I am storing the current users id in a session variable using the following: Now I am trying to write a query that uses that. SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login Is it possible to use it, or am I just writing it wrong? Thanks in advance! Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- 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.
CFLOCK datasource var?
In my application.cfm I set a session var for all my queries' datasource like this: So... Do I need to read-only lock every reference to session.ds in all my other templates where I have a query using that datasource session var? e.g., select sysdate from dual Since session.ds is always identical for every user of this site, what does it matter if it's locked or not? ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine -- 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.
Re: CFLOCK datasource var?
> The longer answer is that if the value is going to be the same for everybody > using the application, you should store it as a "constant" by putting it > into the local Variables scope within application.cfm, or even better, the > Request scope: > > I'm unfamiliar with the request scope and can't seem to find it in any of my docs. Where is a request-scope var stored? Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Dave Watts <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 29, 2000 3:45 PM Subject: RE: CFLOCK datasource var? > > In my application.cfm I set a session var for all my queries' > > datasource like this: > > > > > > > > > > > > So... Do I need to read-only lock every reference to > > session.ds in all my other templates where I have a query > > using that datasource session var? e.g., > > > > > > select sysdate from dual > > > > > > Since session.ds is always identical for every user of this > > site, what does it matter if it's locked or not? > > The short answer is, yes, you should lock it, because there's a potential > for memory corruption with multiple concurrent reads, which can occur even > with session variables. > > The longer answer is that if the value is going to be the same for everybody > using the application, you should store it as a "constant" by putting it > into the local Variables scope within application.cfm, or even better, the > Request scope: > > > > There's no reason to store this on a per-user basis in memory unless each > user actually gets a different datasource. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > -- > 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. > -- 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.
Re: CFLOCK datasource var?
So I don't need to lock application-scope variables? One book I have says I should. How about request-scope vars? Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Todd Ashworth <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 29, 2000 3:49 PM Subject: Re: CFLOCK datasource var? > You shouldn't need to use a Session variable for your DSN .. especially if > you are going to be setting it over and over in your Application.cfm. That > defeats the purpose of having a Session variable anyway. You could get by > with another scope .. say Variables.ds, or something. That way, you > wouldn't have to worry about locking at all. > > > > > > Todd Ashworth > > - Original Message - > From: "Ricq Pattay" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 29, 2000 4:42 PM > Subject: CFLOCK datasource var? > > > | In my application.cfm I set a session var for all my queries' datasource > | like this: > | > | > | > | > | > | So... Do I need to read-only lock every reference to session.ds in all my > | other templates where I have a query using that datasource session var? > | e.g., > | > | > | select sysdate from dual > | > | > | Since session.ds is always identical for every user of this site, what > does > | it matter if it's locked or not? > | > | > | Ricq Pattay <[EMAIL PROTECTED]> > | Univ of Minnesota - Twin Cities > | College of Veterinary Medicine > | > | > | > | > | -- > > | 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. > | > > > -- > 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. > -- 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.
Re: (OT) making fields readonly with JavaScript
I haven't tried this, and in fact I'm stealing this from the JS-Jive list: onFocus="this.blur()" in the input tag ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Jamie Keane <[EMAIL PROTECTED]> To: CFTalk <[EMAIL PROTECTED]> Sent: Thursday, August 31, 2000 8:50 AM Subject: (OT) making fields readonly with JavaScript > Hi all, and I apologise for being off-topic, but this is driving me nuts! > > Is there a way to "disable" text field via JavaScript? I know of the > READONLY attribute, and the client likes how that works, but in my research > I was not able to come up with a way to access that attribute through JS. > Any ideas? > > Thanks, > Jamie > > -- > Jamie Keane > Programmer > SolutionMasters, Inc. > 9111 Monroe Rd., Suite 100 > Charlotte, NC 28270 > www.solutionmasters.com > 704.563.5559 x 228 Voice > 704.849.9291 Fax > > -- > 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. > -- 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.
YAFLQ (Yet Another "Fine" Locking Question)
If I have references to session variables that are nested, do I need to lock each reference separately or can I wrap the whole thing in one lock? e.g., select message_text from vcross.messages where [LOCK HERE?] message_type = 'student' [LOCK HERE?] message_type = 'faculty' select message_text from vcross.messages where message_type = 'specific' and user_id = #session.suser_id# [LOCK HERE?] ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine -- 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.
Re: YAFLQ (Yet Another "Fine" Locking Question)
Sorry, that first lock should be type="readonly". > ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine -- 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.
[CF-Talk] Re: listing tables in Access?
Assuming Access 97 (don't know about 2000): With the main database window visible, select Tools/Analyze/Documenter. There you can choose which db objects you wish to view/print. Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Jamie Keane <[EMAIL PROTECTED]> To: CFTalk <[EMAIL PROTECTED]> Sent: Monday, September 18, 2000 12:37 PM Subject: OT: listing tables in Access? > Hello everyone, > > I was wondering if Access has some mechanism in place to list all tables in > a database. Thanks. > > -- > Jamie Keane > Programmer > SolutionMasters, Inc. > 9111 Monroe Rd., Suite 100 > Charlotte, NC 28270 > www.solutionmasters.com > 704.563.5559 x 228 Voice > 704.849.9291 Fax > > -- > 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. > -- 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.
CFINPUT default maxlength (255?)
Is there a limit to the number of characters that can be entered in a CFINPUT textbox? I seem to be running into a 255-character cutoff and I haven't specified a maxlength. (Yes, I know TEXTAREA would be more appropriate for lengthy entries, but what the client wants the client gets.) Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
So you wouldn't need the Session.LoggedIn="true" statement to renew the session variable? Activity alone renews it? - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 9:02 AM Subject: Re: session variable renewal > 10:35 > Activity starts things over. > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > - Original Message - > From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 8:58 AM > Subject: session variable renewal > > > > Hello. Do session variables get renewed when you set them? In other > words, > > let's say that my application has a 20-minute session variable timeout. > At > > 10:00, a user hits a page that sets Session.LoggedIn="true". At 10:15, > the > > user hits that page again. Does Session.LoggedIn expire at 10:20 or > 10:35? > > > > Thanks, > > Matthieu > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IE question
I'm trying to format CF output so that the query table rows are shaded grey and clear alternately. The below code works in Netscape, but in IE I get rows that are grey and black alternately. Of course, if I put something within the quotes of the 2nd DE, it works fine in IE. But I'd prefer to have the clear row so as not to conflict with my background image pattern. Any ideas (besides requiring my users to only use Netscape...)? [etc.] ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk 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.
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
Any ideas what might be causing this error? It's intermittent and has been raised by multiple templates in my application that have SQL select clauses. === DIAGNOSTICSTEXT: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (12:1) to (12:50) in the template file [path/filename edited out]. === Here's the cfquery referenced in the error message: select itm_id, itm_name from centsup.item order by lower(itm_name) ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk 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.
OT: Oracle error 01000
My CF app users have also been getting the Oracle error "ORA-01000: maximum open cursors exceeded" occasionally. My Oracle DBA tells me my cursor-related parameters are currently: >> close_cached_open_cursors (currently = FALSE) >> cursor_space_for_time (currently = FALSE) >> open_cursors (currently = 50) Forgive my Oracle ignorance, but do we need to set the open_cursors parameter high enough to accommodate the maximum number of simultaneous users at my site? Or...? CF Enterprise 4.5.1 Oracle native CF driver to an Oracle 7.3 db NT 4.0, SP 6 ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Select list Question and javascript
Use Joe Cheng's custom tag ConfirmButton. Very simple to use and just what you need. Go to http://devex.allaire.com/developer/gallery/index.cfm and search on confirmbutton to download it. Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Olson, Kelly <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 17, 2000 4:16 PM Subject: Select list Question and javascript > Second Question: > When I delete I would like a popup box for something like "You are about > to Deleted - to continue to return" before an actual > delete takes place." How is the best way to do this? I would assume > that it would be a javascript, but I haven't figured on how to pass > values to the next cfm page. > -- 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.
Re: Oracle... ODBC error messages different than native drivers?
Just an additional bit of info: If I send a malformed query to Oracle using native drivers, and the error occurs *after* the column headings are returned by the query (this happens with certain types of errors), the CF server evidently believes the query is still executing and therefore *no* error is returned to your browser. It appears as if the server was hanging at this point. This was driving me crazy until my server guru set the maximum query timeout on the CF server from 0 to 60 seconds. If I run the same query in SQL Plus, Oracle returns the column headings with an immediate error message, so anytime I have a questionable query I always test drive it in SQL Plus first. Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Dave Watts <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, July 18, 2000 11:56 AM Subject: RE: Oracle... ODBC error messages different than native drivers? > > Which leads me to ask... Would the native driver return a > > different (or even better) error message than the Oracle > > ODBC driver? > > In my experience, the Oracle native drivers return a different error message > than the ODBC error messages - they're even more obtuse. In fact, the > Allaire knowledge base recommends using ODBC instead of native drivers when > you're trying to figure out why something isn't working. > > > How exactly does ColdFusion process database errors? > > CF never really communicates directly with the database, as I believe > SQL*Plus does. It returns whatever message the middleware layer sends, as > far as I can tell. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > -- > 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. > -- 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.
cftransaction & cfloop error
The following test code always generates a "PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag" error when x is greater than 25. The weird thing is it works fine if I move the tags *outside* of the loop or if I don't use at all. Any ideas why? We're using the Oracle native driver. === update surg.item set item_stock_qty = #x#, item_low_level_qty = #x#, item_reorder_qty = #x# where item_id = 9 [other similar & simple update queries deleted for viewability] #temp# iterations successful. ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine -- 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.
Re: Autonumber?
CreateUUID() Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: HappyToad.com <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, September 27, 2000 9:44 AM Subject: Autonumber? > How can I have Cf create a unique order id for each order placed though the > store I am building? > > > Thanks, > Rich > > -- > 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. > -- 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.
Re: Doing multiple inserts using
Try moving your outside of your loop. That's what fixed it for me, although I was using Oracle. Ricq Pattay <[EMAIL PROTECTED]> Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Michael Rosario <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Thursday, October 12, 2000 2:34 PM Subject: Doing multiple inserts using > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01C03483.72D4A0B0 > Content-Type: text/plain; > charset="iso-8859-1" > > Hello there... > > I was wondering if anyone else out there has encountered this situation: > > I'm getting a : > > CFMLInterpreterImp::executePCode - unknown exception condition > > In a coldFusion template used for database I/O to MS SQL server, I receive a > WDDX packet from a client.. > > I use the following line to parse my packet... > > > > > After parsing the packet... I loop over the record set it returns using the > following code: > > > > > > datasource="cwwebapp_#cookie.cwwebappcompanyid#"> > insert pm_role_security > ( > Owner_ID, > PM_Role_RecID, > PM_Label, > PM_Function, > PM_Add_Level, > PM_Edit_Level, > PM_Delete_Level, > PM_Inquire_Level, > Last_Update, > Updated_By > )values( > #session.userVars[6]#, > #intPMRoleRecID#, > '#label#', > '#function#', > #Add_Level#, > #Edit_Level#, > #Delete_Level#, > #Inquire_Level#, > #recLastUpdate#, > '#session.userVars[1]#' > > ) > > > > > > > All of the i/o operations complete successfully,but it looks like when it > comes out of the the PCode error occurs and execution halts... > > Any help would be most appreciated... > > > Thanks... > > > > > > --_=_NextPart_001_01C03483.72D4A0B0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > > charset=3Diso-8859-1"> > 5.5.2650.12"> > Doing multiple inserts using <CFLOOP> > > > > Hello there... > > > I was wondering if anyone else out there has = > encountered this situation: > > > I'm getting a : > > > SIZE=3D2>CFMLInterpreterImp::executePCode - unknown exception = > condition > > > In a coldFusion template used for database I/O to MS = > SQL server, I receive a WDDX packet from a client.. > > > I use the following line to parse my packet... > > > <CFWDDX = > ACTION=3D'wddx2cfml' input=3D#hidContent# = > output=3D'rsRoleMatrix'> > > > > After parsing the packet... I loop over the record = > set it returns using the following code: > > > > = > = > <cfloop = > query=3D"rsRoleMatrix"> > = > = > = > = > <!-- = > Insert each role_security record --> > = > = > = > = > SIZE=3D2><CFTRANSACTION> > = > = > = > = > <cfquery = > name=3D"insertRoleSecurity" = > datasource=3D"cwwebapp_#cookie.cwwebappcompanyid#"><= > /P> > > = > = > = > = > insert = > pm_role_security > = > = > = > = > ( > = > = > = > = > = > Owner_ID, > = > = > = > = > = > SIZE=3D2>PM_Role_RecID, > = > = > = > = > = > SIZE=3D2>PM_Label, > = > = > = > = > = > SIZE=3D2>PM_Function, > = > = > = > = > = > SIZE=3D2>PM_Add_Level, > = > = > = > = > = > SIZE=3D2>PM_Edit_Level, > = > = > = > = > = > SIZE=3D2>PM_Delete_Level, > = > = > = > = > = > SIZE=3D2>PM_Inquire_Level, > = > = > = > = > = > SIZE=3D2>Last_Update, > = > = > = > = > = > SIZE=3D2>Updated_By >
Processing multiple selections from a select list box
How do I process multiple selections from a list box? My list box is populated with values from a query (see code), and I want the user to be able to select one or more values. I then want to insert the values selected into an Oracle table, along with the user's ID, which is determined elsewhere. Sorry if this is a newbie question, but I can't find ANY info on this topic. Thanks. select dlo_id, dlo_locn from del_locn order by dlo_locn ... #dlo_locn# ~~~~ Ricq Pattay <[EMAIL PROTECTED]> -- Archives: http://www.eGroups.com/list/cf-talk 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.
pre-selecting items in a multiple list box
I'm using a CF template that attempts to pre-select several items in a list box based on values returned from 2 queries. If a match occurs, that entry in the list box should be selected. There will almost always be more than one match. Specifically, the list box should list all possible delivery locations (from the get_del_locn query) and highlight/pre-select those locations that a user has a record returned for in get_usr_del_locn. What the code below produces *almost* works - all possible delivery locations are in the list box, but only *one* of the user's specific locations is selected even though they might have 4 or 5 locations tied to their usr_id. So... Why doesn't this code work? select user_del.dlo_id from del_locn, user_del where del_locn.dlo_id = user_del.dlo_id and user_del.usr_id = #usr_id# select dlo_id, dlo_locn from del_locn order by dlo_locn #get_del_locn.dlo_locn# #get_del_locn.dlo_locn# ~~~~~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk 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.
SOLUTION: pre-selecting items in a multiple list box
Thanks everyone for your suggestions. FYI, this is what I got to work: select dlo_id, dlo_locn from del_locn order by dlo_locn select user_del.dlo_id from del_locn, user_del where del_locn.dlo_id = user_del.dlo_id and user_del.usr_id = #usr_id2# #dlo_locn# #dlo_locn# >I'm using a CF template that attempts to pre-select several items in a list >box based on values returned from 2 queries. If a match occurs, that entry >in the list box should be selected. There will almost always be more than >one match. Specifically, the list box should list all possible delivery >locations (from the get_del_locn query) and highlight/pre-select those >locations that a user has a record returned for in get_usr_del_locn. What >the code below produces *almost* works - all possible delivery locations are >in the list box, but only *one* of the user's specific locations is selected >even though they might have 4 or 5 locations tied to their usr_id. > >So... Why doesn't this code work? > > > > select user_del.dlo_id > from del_locn, user_del > where del_locn.dlo_id = user_del.dlo_id >and user_del.usr_id = #usr_id# > > > > > select dlo_id, dlo_locn > from del_locn > order by dlo_locn > > > > > > > #get_del_locn.dlo_locn# > > #get_del_locn.dlo_locn# > > > > > > >Ricq Pattay <[EMAIL PROTECTED]> >Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: dynamic form field names
How about -- I got something similar to work for me just today, though I wasn't using arrays. Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Deanna L. Schneider <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 25, 2000 10:23 AM Subject: dynamic form field names > Hi all, > I know I should be able to figure this out, but my brain is not cooperating. > > I have a form that has a user-defined number of options (user gets to pick > how many categories a particular resource fits into). Now, typically, I'd > name all the select boxes the same, and voila! I'd loop through the list of > form variables. But, because I'm using javascript to dynamically populate > the subcategory select box, all the select boxes need unique names. S, > I'm looping through them and incrementing their names by 1 (i.e. two > categories would result in form.catid1, form.catid2, form.subcat_id1 and > form.subcat_id2 being passed to the action page). I'm also passing two > hidden fields with the resource id (res_id) and the number of categories > (looplength). > > On the action page, I thought I could loop based on the looplength variable, > and get the corresponding values. But, all I'm able to get is the names of > the form fields. *sigh* I'm obviously not using "evaluate()" correctly. > (And, yes, I know I could do a two dimensional array. I'm just using two > one-dimensional arrays so that I know I'm not just screwing up the array > structure.) > > Help? > > > > > > > > > > > > > > > - > Loop a query to insert data into the res_cat table. > -- -- > --> > > > INSERT INTO res_cat(res_id, cat_id, subcat_id) > VALUES (#form.res_id#, #catarray[i]#, #subcatarray[i]#) > > > > > > > Deanna Schneider > Interactive Media Developer > UWEX Cooperative Extension Electronic Publishing Group > 103 Extension Bldg > 432 N. Lake Street > Madison, WI 53706 > (608) 265-7923 > > > > -- > Archives: http://www.eGroups.com/list/cf-talk > 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. > -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Client and session variables same thing different
Is there any way to "refresh" a session variable's timeout countdown so that when a user accesses a page the timeout is reset back to whatever I had it set to in Application.cfm? For example, my session variables timeout is currently set to 30 minutes for security reasons. But I have some users who use this site all day long. I'd like to prevent having these power users from having to log back in every 30 minutes. As long as they access any page in the site within the 30 minute window, I'd like the 30-minute countdown to reset back to 30. Possible? I suppose I could create a duplicate CF directory with its own application.cfm for these special users, but of course that gets kind of messy... ~~~~ Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary - Original Message - From: Chris Evans <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 11, 2000 7:38 AM Subject: RE: Client and session variables same thing different > Session variables are unique to each user, time out after a period of time, > and are stored in RAM. Client variables are unique to each user, don't time > out, and are stored in an external database or in the Registry. > > Session variables aren't scalable because two ( or three, or five ) > clustered servers can't share them, as they are stored in the initiating > servers RAM. > > > Chris Evans > [EMAIL PROTECTED] > http://www.fuseware.com > > > -Original Message- > From: Robert Everland [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 10, 2000 4:12 PM > To: '[EMAIL PROTECTED]' > Subject: Client and session variables same thing different > > > I was looking at the url for commerce blocks that was posted a > little bit ago and saw thier structure, array, wddx tutorial. Now the > question I have is, they say that session variables aren't very scalable, > but client variables are. What's the difference and where do I find client > variables explained more? > > > Robert Everland III > Web Developer > Dixon Ticonderoga > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > 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. > > > -- > Archives: http://www.eGroups.com/list/cf-talk > 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. > -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Client and session variables same thing different
Huh. That's now how it seems on my end, but I must be spending too much time testing this thing as a developer instead of as a pseudo-user. :-) Thanks. Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Dave Watts <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Ricq Pattay <[EMAIL PROTECTED]> Sent: Thursday, May 11, 2000 10:40 AM Subject: RE: Client and session variables same thing different > > Is there any way to "refresh" a session variable's timeout > > countdown so that when a user accesses a page the timeout > > is reset back to whatever I had it set to in Application.cfm? > > > > For example, my session variables timeout is currently set to > > 30 minutes for security reasons. But I have some users who use > > this site all day long. I'd like to prevent having these power > > users from having to log back in every 30 minutes. As long as > > they access any page in the site within the 30 minute window, > > I'd like the 30-minute countdown to reset back to 30. Possible? > > Actually, that's how session variables work now. The timeout period is the > maximum allowed amount of inactivity between page requests. So, if your user > requests a page every 25 minutes for 8 hours, that user's session will > continue for 8 hours, until they wait more than 30 minutes to request > another page. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Page Loading...
Load your "Please wait..." page first with an instant meta refresh to your query page. I also do a bit of JavaScript to animate a clock image while they wait. e.g., http://your_query_page.cfm"> Loading schedule, please wait... - Original Message - From: <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, November 27, 2000 2:29 PM Subject: Page Loading... > Scenario: A page runs many queries and takes a little time to finish. > > Is there a way in CF to display some type of 'Page Loading...' message until > the page is finished running all of its queries etc? > > I know is ASP you can check the page buffer and when the buffer clears you > can send them to a page. > > any suggestions? > > chris.alvarado > cold.fusion - developer > [phone] 512.794.6563 > [email] [EMAIL PROTECTED] > [web] http://www.tmanage.com > > > Privileged/Confidential Information may be contained in this message. It is > not for use or disclosure outside TManage without a written proprietary > agreement. If you are not the addressee indicated in this message, or agent > responsible for delivery, you may not copy or deliver this message to > anyone. Please notify the sender as soon as possible and immediately > destroy this message and its attachments entirely. > > > ~~ > 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 > ~~ 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: SQL SUM Question
Wouldn't that be: select sum(number) as whatever from Tbl_Numbers and then #get_sum.whatever# ? - Original Message - From: "Kevin Queen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 03, 2001 3:36 PM Subject: SQL SUM Question > List, > If I run the following query: > > Select Number from Tbl_Numbers SUM(Number) > > how can I oputput the SUMed variable in a cfoutput? > > TIA, > Kevin Queen > > ~~ 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: Order of Display/Page Rendering Question
You can sidestep the "top down" issue by using JavaScript to cycle through a series of images, creating the illusion of an animated image, instead of using an animated GIF. GIF animation seems to start only once the page is finished loading. E-mail me if interested in some code (kinda lengthy to post to the list). - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 16, 2001 10:37 AM Subject: Order of Display/Page Rendering Question > I have a page that was originally ASP that I've converted over to CF. This > was a "Find a Rep near you" type search that has a huge database behind it > (eight different countries) - so the search could take up to 10 or 15 > seconds. > > On the ASP version, so the user wouldn't get too bored during the process, > I placed a small "Progress Indicator" animated gif on the page that > displayed until the search results came up. > > On the CF page, I've got my chuck of HTML code with the "Progress Gif" FIRST > on the page, before any of the CF code that searches the database and > displays the results. However, the CF pages refuses to display the page at > all until the search is complete, leaving you enough time to go refresh your > cup of coffee after you click "Submit" on the "Find Your Rep" form on the > initial search page. > > So, Cold Fusion doesn't display a page "top down"? Any way to get the search > to run in the background so you can still stare at the "Progress Gif" while > you wait on the results to come up? > > Thanks! > > -- > Les Mizzell > > Who Needs Intel? > ATHLON INSIDE! > > > > ~~ 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
Drop Down Combo Boxes Disappearing in IE
I have a CF page with approximately 40-50 drop down select/combo boxes (query driven & dynamically named). On some computers in IE 5.5 the drop downs don't appear when the page loads -- there's only a white space where the drop down should be. Other form elements (text boxes, submit buttons) appear normally. Netscape seems fine but with only limited testing from me. Any ideas? Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: javascript thumbnails
Try the low resolution attribute of the IMG tag. Your low rez image can be a "Please wait" image and the regular image will be the actual image. I've not used this personally but NS and IE are said to support it even though it's not standard HTML. If you don't specify the height and width then the size of the low-rez image is used for both. Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities - Original Message - From: "Michael Lugassy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 11:14 AM Subject: OT: javascript thumbnails > Kinda OT, but I need help. > I just finish designing a search page for images. > the images are stored on a diffrent server and it's take time for them > to appear (i.e - user see empty rectangles for a long period of time). > > can anyone suggest a way to display a "loading, please wait.." IMAGE I have > instead of those images and replace them with the real image as soon as it loads > up? > > Thanks, > > Michael. > > > ~~ 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
multiple queries tie up web server
I have a CF page that contains approx 7500 queries against an Oracle database via an Apache web server. Of course this page takes a while to load (3 minutes or so), but my user is ok with that because she does so only a handful of times per day. What is not ok is that, while this page is loading, all other users of any CF app on that web server cannot access any page -- they will receive Apache's "server is too busy to handle request" error message. Any ideas on how to work around this? Reducing the number of queries from 7500 isn't really an option, unfortunately. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: multiple queries tie up web server
Thanks for the responses so far. More info: We're running CF Server 4.51 Enterprise, with the Oracle 7.3 native drivers. And *all* requests to the web server are refused, not just those to the same datasource. So this sounds more like a web server problem (as Robert said). The page in question isn't a report, but a dynamic grid of enrollment counts for multiple courses held at multiple times. Each course/time combination has 4 queries associated with it, 3 of which are "select count(user_id)..." Each course/time intersection has javascript pop-up windows associated with it so my user can add/drop/move students to/from other intersections on the schedule grid. I can't really cache the query because there's 7500 of them! :-) I don't know enough yet about writing stored procedures to investigate this route. Maybe this is a good time to learn? But would using SP's even help if there are so many little queries? - Original Message - From: "Edward Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:10 PM Subject: Re: multiple queries tie up web server > We've had problems with Oracle drivers being single threaded-like. In > other words, if a long running query is just waiting out there, other > requests to that datasource have to wait. > > What version of CF and what oracle drivers are you using? > > Ricq Pattay wrote: > > > > I have a CF page that contains approx 7500 queries against an Oracle > > database via an Apache web server. Of course this page takes a while to load > > (3 minutes or so), but my user is ok with that because she does so only a > > handful of times per day. > > > > What is not ok is that, while this page is loading, all other users of any > > CF app on that web server cannot access any page -- they will receive > > Apache's "server is too busy to handle request" error message. Any ideas on > > how to work around this? Reducing the number of queries from 7500 isn't > > really an option, unfortunately. > > > > Ricq Pattay ~ [EMAIL PROTECTED] > > College of Veterinary Medicine > > University of Minnesota - Twin Cities > > > > > ~~ 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
Scheduled Event (was: multiple queries tie up web server)
To avoid running those pesky 7500 queries, I'm investigating creating a static page that refreshes once a day. My user seems sorta ok with this approach. This is my first attempt with scheduling a CF event. So why when I set up a scheduled event in the CF Adminstrator do I always get a "connection failure" notice? The URL is correct, no username or password is required, request timeout is set well above what the page usually takes, no proxy, publish is checked, publish path & filename are valid, resolve URL checked. Actually I get a connection failure even when trying to run a simple page with ONE query and passing no parameters to it, so this sounds like a configuration issue...(?). The scheduler log looks ok: "Information","TID=3402","02/06/01","13:05:52","Scheduled action vcross_test, template http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation submission initiated." "Information","TID=3402","02/06/01","13:08:05","Scheduled action vcross_test, template http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation submitted successfully." but the resulting .htm file consists of the one line "Connection failure." If I select "Run" from the CF Admin scheduling page, the scheduled page always times out, even the simple test page with a single query that normally takes 1 second to run if loaded directly. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: Scheduled Event (was: multiple queries tie up web server)
Huh. I didn't know you could cache entire pages... RTFM Ricq. But I still need to schedule a run of the page, cached or static-making, early in the morning to avoid hanging up my other users. Anybody have any ideas on why CF Scheduling is bombing on me? Ricq - Original Message - From: "Peter Theobald" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 9:34 PM Subject: Re: Scheduled Event (was: multiple queries tie up web server) > Wouldn't it be easier to use CFCACHE to mark the page as cached? CF will process the page once and write the HTML to a cache file, from then on it will use the cached HTML file and not reprocess the file until the cache expires. > > At 01:34 PM 2/6/01 -0600, Ricq Pattay wrote: > >To avoid running those pesky 7500 queries, I'm investigating creating a > >static page that refreshes once a day. My user seems sorta ok with this > >approach. This is my first attempt with scheduling a CF event. > > > >So why when I set up a scheduled event in the CF Adminstrator do I always > >get a "connection failure" notice? The URL is correct, no username or > >password is required, request timeout is set well above what the page > >usually takes, no proxy, publish is checked, publish path & filename are > >valid, resolve URL checked. Actually I get a connection failure even when > >trying to run a simple page with ONE query and passing no parameters to it, > >so this sounds like a configuration issue...(?). > > > >The scheduler log looks ok: > > > >"Information","TID=3402","02/06/01","13:05:52","Scheduled action > >vcross_test, template > >http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation > >submission initiated." > >"Information","TID=3402","02/06/01","13:08:05","Scheduled action > >vcross_test, template > >http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation > >submitted successfully." > > > >but the resulting .htm file consists of the one line "Connection failure." > > > >If I select "Run" from the CF Admin scheduling page, the scheduled page > >always times out, even the simple test page with a single query that > >normally takes 1 second to run if loaded directly. > > > > > > > > > >Ricq Pattay ~ [EMAIL PROTECTED] > >College of Veterinary Medicine > >University of Minnesota - Twin Cities > > > > > > > ~~ 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: Scheduled Event (was: multiple queries tie up web server)
Well, fudge. Scheduling appears to be working for me this morning. Sorry everyone. > - Original Message - > From: "Ricq Pattay" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 07, 2001 8:17 AM > Subject: Re: Scheduled Event (was: multiple queries tie up web server) > > > > Huh. I didn't know you could cache entire pages... RTFM Ricq. > > > > But I still need to schedule a run of the page, cached or static-making, > > early in the morning to avoid hanging up my other users. Anybody have any > > ideas on why CF Scheduling is bombing on me? > > > > Ricq > > > > - Original Message - > > From: "Peter Theobald" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, February 06, 2001 9:34 PM > > Subject: Re: Scheduled Event (was: multiple queries tie up web server) > > > > > > > Wouldn't it be easier to use CFCACHE to mark the page as cached? CF will > > process the page once and write the HTML to a cache file, from then on it > > will use the cached HTML file and not reprocess the file until the cache > > expires. > > > > > > At 01:34 PM 2/6/01 -0600, Ricq Pattay wrote: > > > >To avoid running those pesky 7500 queries, I'm investigating creating a > > > >static page that refreshes once a day. My user seems sorta ok with this > > > >approach. This is my first attempt with scheduling a CF event. > > > > > > > >So why when I set up a scheduled event in the CF Adminstrator do I > always > > > >get a "connection failure" notice? The URL is correct, no username or > > > >password is required, request timeout is set well above what the page > > > >usually takes, no proxy, publish is checked, publish path & filename > are > > > >valid, resolve URL checked. Actually I get a connection failure even > when > > > >trying to run a simple page with ONE query and passing no parameters to > > it, > > > >so this sounds like a configuration issue...(?). > > > > > > > >The scheduler log looks ok: > > > > > > > >"Information","TID=3402","02/06/01","13:05:52","Scheduled action > > > >vcross_test, template > > > > >http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation > > > >submission initiated." > > > >"Information","TID=3402","02/06/01","13:08:05","Scheduled action > > > >vcross_test, template > > > > >http://bozo.umn.edu/schedule.cfm?year=2001-2002&rotation=2&type=rotation > > > >submitted successfully." > > > > > > > >but the resulting .htm file consists of the one line "Connection > > failure." > > > > > > > >If I select "Run" from the CF Admin scheduling page, the scheduled page > > > >always times out, even the simple test page with a single query that > > > >normally takes 1 second to run if loaded directly. > > > > > > > > > > > > > > > > > > > >Ricq Pattay ~ [EMAIL PROTECTED] > > > >College of Veterinary Medicine > > > >University of Minnesota - Twin Cities > > > > > > > > > > > > > > > ~~ 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
SurePay
Anybody using SurePay? How difficult was it to set up in CF? Has anyone ever used the "SurePay Tag Pack" custom tag -- if so, how was it? Any input would be appreciated. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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
OT: Max Credit Card Expiration Date
If this is 2001, what is the highest expiration year I'll ever see on a customer's valid card? I'm populating an order form's select box with expiration years and don't want to put any more years in there to choose from than are necessary. So if the max year is always "X" years from the present year, I can of course dynamically populate my select using that info. Thanks. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: How to get a list of all tables in a given datasource - and how to combine queries
If you are the Oracle owner of the tables in question, you can use "select table_name, table_type from user_catalog". If you're not the owner, I think you're out of luck. - Original Message - From: "Jim Watkins" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 9:17 AM Subject: Re: How to get a list of all tables in a given datasource - and how to combine queries > Does anyone have the code to get a list of Tables from an Oracle database? > > > - Original Message - > From: "Diana Nichols" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 08, 2001 9:08 AM > Subject: RE: How to get a list of all tables in a given datasource - and how > to combine queries > > > > This will give you a list of the tables within a SQL database: > > > > > > select table_name from information_schema.tables > > > > > > > > #table_name# > > > > > > You should then be able to combine the data from both queries in whatever > > way you want. > > > > HTH > > D > > * > > Diana Nichols > > Webmistress > > http://www.lavenderthreads.com > > 770.434.7374 > > > > "One man's magic is another man's engineering." ---Lazarus Long > > > > > > -Original Message- > > From: JoshMEagle [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 08, 2001 8:34 AM > > To: CF-Talk > > Subject: How to get a list of all tables in a given datasource - and how > > to combine queries > > > > > > Have two questions > > > > First, given the name of a datasource, how do I go about finding what > tables > > are contained in the datasource via CF (not just opening SQL Server) > > > > Second, I have a query of all the datasources on my server using > > that is returned as a query ... how can I combine this > > information with the query to display the tables into one query? Is this > > even possible? > > > > THANKS! > > > > Joshua Miller > > Web Development > > Eagle Technologies Group > > Technology Solutions for the Next Generation > > www.eagletgi.com > > [EMAIL PROTECTED] > > > ~~ 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: Debug output
Just change the font color as the last line in your template, like so: Be sure NOT to include a closing tag. The font color you set here will carry over to all the CF debug stuff at the bottom of the page. Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities - Original Message - From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:26 AM Subject: Debug output > Is there a way to capture CFAS's debug output and format it? My problem is > that if I develop a site that has a dark background, I can't see any debug > information because the text is dark too. I am mainly interested in looking > at SQL statements, I know you can see most other information (passed vars, > etc) using many of the custom tags. > > Thanks > > > ~~ 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
cfqueryparam error w/ oracle
My query is this: = select * from vcross_user where user_id = = The error I receive is this: = Error Diagnostic Information Oracle Error Code = 1480 ORA-01480: trailing null missing from STR bind value SQL = "select * from vcross_user where user_id = :1" Query Parameter Value(s) - Parameter #1 = 10 = Why? CF Server 5.0 on NT, Oracle 8i Ricq Pattay [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities "To err is human, to forgive canine." __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam error w/ oracle
> It doesn't error if you don't use cfqueryparam? Works just fine if I don't use cfqueryparam. > If x=1, what is the ":1" that comes out in the error msg, any idea? The ":1" is a numeric user id. At this point all I'm doing is looping over a valuelist of user ids. > Next I'd ask an Oracle guy exactly what a ORA-01480 is. >From technet.oracle.com: ORA-01480 trailing null missing from STR bind value Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer. Action: Terminate the string with a null character. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam error w/ oracle
That almost fixed it -- I tweaked the quotes in the VALUE param and now it works, *thank you!*. If I do VALUE="#trim(x)#", I get the same error. But if I do VALUE="#trim("x")#", it works. But wtf? The user_id field is Oracle field type number(6). It looks like Oracle is misinterpreting #x# as a string (STR?). There can't be any spaces/nulls in a number(6) field! So... this works: select * from v_user where user_id = - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 4:01 PM Subject: RE: cfqueryparam error w/ oracle > > > Next I'd ask an Oracle guy exactly what a ORA-01480 is. > > > > From technet.oracle.com: > > ORA-01480 trailing null missing from STR bind value > > Cause: A bind variable of type 5 (null-terminated string) > > does not contain the terminating null in its buffer. > > Action: Terminate the string with a null character. > > Are you sure there's nothing in the variable except the actual value? You > might wrap the value with Trim: > > > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists