RE: Sequence in SQL Server?
Kwang Suh wrote: >SQL Server doesn't have sequences. You'll have to use identity fields. I kinda thought so, but I don't use SQL Server much so I thought maybe it was something 'new' in SQL2k, or a seldom-used feature I was unfamiliar with. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 7:15 PM To: CF-Talk Subject: RE: Sequence in SQL Server? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: October 20, 2003 7:44 PM To: CF-Talk Subject: Sequence in SQL Server? I've got a potential client who is getting an error from this query: insert into reseller (RESELLER_ID, SIGNUP_DATE, --- etc. etc. --- ) values (RESELLER_ID_SEQ.nextval, GETDATE(), ---etc. etc.) This is the error: [Macromedia][SQLServer JDBC Driver][SQLServer]The name 'nextval' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Looks like his original developer used a sequence to assign his pk and somehow his syntax is wrong. I don't use sequences except in Oracle. I pulled some Oracle queries I wrote and this code would have worked there. Can anyone see an obvious problem here, or know of why CF is throwing this? If I can just tell the poor guy the problem I'll let him go on his merry way no charge on this one. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DataDirect JDBC drivers (shipped with CFMX)..
The Microsoft SQL Server JDBC driver is OEM'd from DataDirect, the same people who provide the CFMX drivers. If you're having problems with the DataDirect drivers (either Microsoft's OEM'd version or the one provided with CFMX), you may want to look for another commercial driver. You can find a list from Sun's web site: http://servlet.java.sun.com/products/jdbc/drivers You should stick with the J2EE-certified drivers. Here's one that I can personally recommend: http://www.newatlanta.com/products/jturbo/index.jsp BTW, this driver (JTurbo) is provided free with BlueDragon. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:07 PM To: CF-Talk Subject: RE: DataDirect JDBC drivers (shipped with CFMX).. This has been discussed Serveral times here.. Use your Vendor Specific JDBC Driver. MM Provides Some Drivers for Ease of Client use, i dont think this necessarily means the Best Driver. MS-SQL Server Specific. When i tested the Microsoft released JDBC Type IV Driver, this performed very well and was very Stable compared to any other. They Key is always Go With the Vendor Specific Stuff... most likely this will be LESS Headache. http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d- 8f7b-3d47969e66ae&DisplayLang=en There were some concerns here that the above Driver was not compatible with J2SE 1.4 For the stuff in CFMX.. Everything works well. Joe Eugene -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:07 PM To: CF-Talk Subject: DataDirect JDBC drivers (shipped with CFMX).. Apparently whichever way you go there's going to be an issue to deal with on the JDBC drivers, has anyone else worked through these? This is on Windows 2000, with SQL Server 2000. === DataDirect 3.1 Old (CFMX Updater 3) - cfstoredproc: Could not find prepared statement with handle DataDirect 3.1 New (CFMX 6.1) - 100% CPU Utilization DataDirect 3.2 - no more data to read - sql insufficient memory to complete this query === Thanks, Calvin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sequence in SQL Server?
SQL Server doesn't have sequences. You'll have to use identity fields. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: October 20, 2003 7:44 PM To: CF-Talk Subject: Sequence in SQL Server? I've got a potential client who is getting an error from this query: insert into reseller (RESELLER_ID, SIGNUP_DATE, --- etc. etc. --- ) values (RESELLER_ID_SEQ.nextval, GETDATE(), ---etc. etc.) This is the error: [Macromedia][SQLServer JDBC Driver][SQLServer]The name 'nextval' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Looks like his original developer used a sequence to assign his pk and somehow his syntax is wrong. I don't use sequences except in Oracle. I pulled some Oracle queries I wrote and this code would have worked there. Can anyone see an obvious problem here, or know of why CF is throwing this? If I can just tell the poor guy the problem I'll let him go on his merry way no charge on this one. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I check... (resolved)
Bless all of you who respond and jump start my very tired grey matter ;) Cutter [EMAIL PROTECTED] wrote: > FileExists(absolute_path) > This will return a Boolean true or false based on the files existence. > > > > > -- > Michael Dinowitz > Finding technical solutions to the problems you didn't know you had yet > - Original Message - > From: "Cutter (CF-Talk)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, October 20, 2003 9:34 PM > Subject: How do I check... > > > How do I check to see if a file exists on the server? I tried to use the > > cffile tag with the readbinary attribute but it gave me a Java error if > > the file didn't exist... > > > > Cutter > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I check...
FileExists(absolute_path) This will return a Boolean true or false based on the files existence. -- Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet - Original Message - From: "Cutter (CF-Talk)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 9:34 PM Subject: How do I check... > How do I check to see if a file exists on the server? I tried to use the > cffile tag with the readbinary attribute but it gave me a Java error if > the file didn't exist... > > Cutter > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I check...
oi Cutter!! isn't there an fileexists() ? -- Monday, October 20, 2003, 9:34:41 PM, you wrote: CCT> How do I check to see if a file exists on the server? I tried to use the CCT> cffile tag with the readbinary attribute but it gave me a Java error if CCT> the file didn't exist... CCT> Cutter CCT> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sequence in SQL Server?
I've got a potential client who is getting an error from this query: insert into reseller (RESELLER_ID, SIGNUP_DATE, --- etc. etc. --- ) values (RESELLER_ID_SEQ.nextval, GETDATE(), ---etc. etc.) This is the error: [Macromedia][SQLServer JDBC Driver][SQLServer]The name 'nextval' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Looks like his original developer used a sequence to assign his pk and somehow his syntax is wrong. I don't use sequences except in Oracle. I pulled some Oracle queries I wrote and this code would have worked there. Can anyone see an obvious problem here, or know of why CF is throwing this? If I can just tell the poor guy the problem I'll let him go on his merry way no charge on this one. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I check...
FileExists (absolute path) Cutter (CF-Talk) wrote: > How do I check to see if a file exists on the server? I tried to use the > cffile tag with the readbinary attribute but it gave me a Java error if > the file didn't exist... > > Cutter > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do I check...
How do I check to see if a file exists on the server? I tried to use the cffile tag with the readbinary attribute but it gave me a Java error if the file didn't exist... Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RSS feed
One of the faults of writing XML by hand. :) I'll have it totally fixed up before I release it fully. I have to add in a voting capability (let people vote if a thread is useful or not) as well as some other controls. The things people do to get their mind off of pain. :) (I had my wisdom teeth out the other day) > Yes. it is the '&'. It has to be valid, well-formed XML. > > mike chambers > > [EMAIL PROTECTED] > > > - Original Message - > From: "Michael Dinowitz" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, October 20, 2003 4:08 PM > Subject: Re: RSS feed > > > > I got that on validation as well, but feed demon seems to let it > > through. > > I'm betting it's the ampersand (&) in the url. I'll replace it in my > > next > > compile. There are a few things I don't like about RSS like the > > requirement > > to use an email address in an author tag. I'm not going to give out > > email > > addresses from list posters so that can just keep validating as false. > > I'll play more when I get home. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: invoking CFCs
Thanks MichealI thought the wwroot dir was the default (like custom tags)guess not ;-) Cheers - Original Message - From: Michael T. Tangorre To: CF-Talk Sent: Monday, October 20, 2003 4:14 PM Subject: RE: invoking CFCs tfg needs to be a defined virtual mapping in your IIS website or a website itself. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 7:01 PM To: CF-Talk Subject: invoking CFCs Hey All, I'm trying to invoke a cfc that is located in c:\cfusionmx\wwwroot\tfg\cfcs\security.cfc by using: CF keeps saying the component cannot be found (its access is set to public). Now if I stick the CFC in the same directory that is being called form it's found with no problem (or in a sub-dir and referenced using dot notation)...but when in the default CFC directory (c:\cfusionmx\wwwroot\) no love!! Any ideas...cause I'm stumped ;-) FYI: CFMX 6.1 Enterprise on Windows 2K Server (on J2EE) TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RSS feed
Yes. it is the '&'. It has to be valid, well-formed XML. mike chambers [EMAIL PROTECTED] - Original Message - From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 4:08 PM Subject: Re: RSS feed > I got that on validation as well, but feed demon seems to let it > through. > I'm betting it's the ampersand (&) in the url. I'll replace it in my > next > compile. There are a few things I don't like about RSS like the > requirement > to use an email address in an author tag. I'm not going to give out > email > addresses from list posters so that can just keep validating as false. > I'll play more when I get home. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: invoking CFCs
tfg needs to be a defined virtual mapping in your IIS website or a website itself. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 7:01 PM To: CF-Talk Subject: invoking CFCs Hey All, I'm trying to invoke a cfc that is located in c:\cfusionmx\wwwroot\tfg\cfcs\security.cfc by using: CF keeps saying the component cannot be found (its access is set to public). Now if I stick the CFC in the same directory that is being called form it's found with no problem (or in a sub-dir and referenced using dot notation)...but when in the default CFC directory (c:\cfusionmx\wwwroot\) no love!! Any ideas...cause I'm stumped ;-) FYI: CFMX 6.1 Enterprise on Windows 2K Server (on J2EE) TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RSS feed
I got that on validation as well, but feed demon seems to let it through. I'm betting it's the ampersand (&) in the url. I'll replace it in my next compile. There are a few things I don't like about RSS like the requirement to use an email address in an author tag. I'm not going to give out email addresses from list posters so that can just keep validating as false. I'll play more when I get home. > Michael Dinowitz wrote: > > > As I said a few weeks back, I'll be putting the lists into RSS feeds in > > addition to the other ways of reading them. This is an experimental > > feed for > > people to play with: > > http://houseoffusion.com/cf_lists/rss.cfm > > > > It's not perfect, but I'm working on it. A few seconds here and there, but > > working on it. :) > > I get the following error when I try to parse it: > > XML Parsing Error: not well-formed > Location: http://houseoffusion.com/cf_lists/rss.cfm > Line Number 5, Column > 73:http://houseoffusion.com/cf_lists/index.cfm/method=threads&forumid= 4 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
invoking CFCs
Hey All, I'm trying to invoke a cfc that is located in c:\cfusionmx\wwwroot\tfg\cfcs\security.cfc by using: CF keeps saying the component cannot be found (its access is set to public). Now if I stick the CFC in the same directory that is being called form it's found with no problem (or in a sub-dir and referenced using dot notation)...but when in the default CFC directory (c:\cfusionmx\wwwroot\) no love!! Any ideas...cause I'm stumped ;-) FYI: CFMX 6.1 Enterprise on Windows 2K Server (on J2EE) TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RSS feed
Michael, I'm getting the same error. I believe that you'll have to htmleditformat all of the contents of the elements. Jesse Houwing wrote: > Michael Dinowitz wrote: > > > As I said a few weeks back, I'll be putting the lists into RSS feeds in > > addition to the other ways of reading them. This is an experimental > > feed for > > people to play with: > > http://houseoffusion.com/cf_lists/rss.cfm > > > > It's not perfect, but I'm working on it. A few seconds here and > there, but > > working on it. :) > > I get the following error when I try to parse it: > > XML Parsing Error: not well-formed > Location: http://houseoffusion.com/cf_lists/rss.cfm > Line Number 5, Column > 73:http://houseoffusion.com/cf_lists/index.cfm/method=threads&forumid=4 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RSS feed
Michael Dinowitz wrote: > As I said a few weeks back, I'll be putting the lists into RSS feeds in > addition to the other ways of reading them. This is an experimental > feed for > people to play with: > http://houseoffusion.com/cf_lists/rss.cfm > > It's not perfect, but I'm working on it. A few seconds here and there, but > working on it. :) I get the following error when I try to parse it: XML Parsing Error: not well-formed Location: http://houseoffusion.com/cf_lists/rss.cfm Line Number 5, Column 73:http://houseoffusion.com/cf_lists/index.cfm/method=threads&forumid=4 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RSS feed
As I said a few weeks back, I'll be putting the lists into RSS feeds in addition to the other ways of reading them. This is an experimental feed for people to play with: http://houseoffusion.com/cf_lists/rss.cfm It's not perfect, but I'm working on it. A few seconds here and there, but working on it. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Managing CFC's
Doug Knudsen wrote:
I have been using a more extreme approach with portability in mind. Within my app dir I have a cfc dir for the cfcs. I have a var set application.rootdir = "foo/goo/application" then I call the cfc using
What is the above example relative to? (foo/goo/application ). Is that relative to the c:\CfusionMX\wwwroot directory?
Thanks
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Thursday, October 16, 2003 6:32 AM
Subject: RE: Managing CFC's
I have been using a more extreme approach with portability in mind. Within my app dir I have a cfc dir for the cfcs. I have a var set application.rootdir = "foo/goo/application" then I call the cfc using
Doug
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:40 AM
To: CF-Talk
Subject: RE: Managing CFC's
Thanks guys that worked,
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 12:29
To: CF-Talk
Subject: RE: Managing CFC's
If my virtual mapping is pointed to the "mySite" folder which is the root of
my default site, this works...
CreateObject("component","mySite.cfc.CurrentUsers") />
Mike
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:22 AM
To: CF-Talk
Subject: RE: Managing CFC's
If you don't want any of your cfc's the be web services, you could put
them outside the web root and use a CF mapping.
I think In Michaels example, just exclude the 'root.' and try again.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 12:10
To: CF-Talk
Subject: RE: Managing CFC's
Thanks Mike,
this fits my style perfectly, although I'm confused how you are
referencing
your CFC's,
e.g. root.cfc.cfcName, I tried this but I still got the same
error,
//Could not find the ColdFusion Component
I understand how to package java classes, but where is your
scope root.cfc
referenced,
is it a mapping in an xml file or somewhere else?
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 11:07
To: CF-Talk
Subject: RE: Managing CFC's
I am not sure if this fits your style, but this is how I usually
organize my
sites.
Root
image
stylesheet
_javascript_
udf
cfc
etc
Now, putting all your CFCs in a central location off the root of
your site
will allow you straightforward access to them ( root.cfc.cfcName
).
HTH,
Mike
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 5:49 AM
To: CF-Talk
Subject: Managing CFC's
Hi,
I have been trying to figure out how to have my components in
one central
location within an application so they are
available application wide.
Mmmm.. how do I do this,
Thanx,
J
_
_
_
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cfmx class files
WEB-INF/cfclasses you have to enable class file caching in the CF Admin though, otherwise it just compiles them and stores them in memory, so they have to be recompiled if they get bumped form the template cache or the server reboots. barneyb -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:15 PM To: CF-Talk Subject: Cfmx class files Where does CFMX store the class files created from CFM pages? Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cfmx class files
Where does CFMX store the class files created from CFM pages? Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Ah... got it. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:53 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Thanks for the tip, Mark. I've got three DB's on one server - all for different clients. I usually switch back and forth all day long, and typing the username/pass combos over and over was getting dull - they use good passwords :) This is much easier! -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:24 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet! Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP. Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfqueryparam error
> Thanks Raymond & Dave... that fixed it... can you help me > get a better understanding of this piece of code: > > maxlength="2" null="#YesNoFormat(NOT Len(form.exp_years))#"> > > As I understand this, its saying the value type to be > submitted MUST be numeric but I don't totally get what the > rest does. I know it addresses an empty string but from > there, I'm lost: > null ="#YesNoFormat(NOT Len(form.exp_years))#" The point of the NULL attribute in this example is to allow you to send a null value if the user provides an empty string. If the user enters anything into the field, the Len function will return a nonzero value, which by itself would evaluate to a Boolean value of true. "NOT" true is false, and the YesNoFormat function converts this Boolean value to the explicit "yes"|"no" value used by CFQUERYPARAM (although I'm not certain this last step is necessary). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Solaris & Flash Remoting Components
> So the includes that are part of the Flash Component install > are already installed on the Server? I should be able to > upload the files to the server and call the flash movie > from a .cfm/.html movie in a browser? Do i have to have > these installed on a local dev box to develop or can i > just upload the files to the Server and test them there? > > NetServices.as: Enables the connection to the application > server's Flash Remoting service (gateway). > NetDebug.as: Enables the NetConnection Debugger utility for > an application. > DataGlue.as: Formats the exchanged data. > RecordSet.as: Returns a recordset. You'll need these files when building your Flash Remoting application within the Flash IDE. You won't need to put them on the server directly, to the best of my knowledge. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL Heirarchies
Charlie Griefer wrote: >The NULL attribute (which, as we've seen, is 'YES' or 'NO') simply >indicates whether to insert a NULL value. DOH! Never occurred to me to use the NULL parameter like this. Incredibly useful. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Thanks for the tip, Mark. I've got three DB's on one server - all for different clients. I usually switch back and forth all day long, and typing the username/pass combos over and over was getting dull - they use good passwords :) This is much easier! -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:24 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet! Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP. Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL Heirarchies
Haggerty, Mike wrote: > > The real problem is the lack of recursion in MySQL, and this issue is > independent of stored procedures. It would be nice if it was possible to > write a query, loop around it, and store intermediate results in a > temporary table within the database. > > For the record, does anyone know if control structures such as this are > being considered for future releases? They are being considered: "we aim toward full compliance with SQL-92/SQL-99" http://www.mysql.com/doc/en/TODO_unplanned.html That includes WITH ... RECURSIVE support. Only long term is after mid-term, near-term, 5.1, 5, and 4.1, so don't hold your breath. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF5: Oracle recordset via StoredProc and QofQ questions
Lofback, Chris wrote: > > We could save ourselves a lot of headaches if there was a way to cache the SP recordset directly, but I don't see a way to do that. I have once seen some code like EXEC PROCEDURE ... But that was pre-MX, so I don't know if/how this works over JDBC. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: cfqueryparam error
Tim, On 10/20/2003 at 16:20, you wrote: TL> null ="#YesNoFormat(NOT Len(form.exp_years))#" Len() is being used as a boolean (zero=false, non-zero=true). In this case, you have to use NOT Len() in order to get the appropriate value for the NULL attribute. YesNoFormat() just converts the boolean to 'yes' or 'no'. So the CFQUERYPARAM is going to pass a NULL to the database if Len(form.exp_years) eq 0. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfqueryparam error
the NULL attribute (which, as we've seen, is 'YES' or 'NO') simply indicates whether to insert a NULL value. if the value is 'YES', any value specified for the VALUE attribute of the tag is ignored, and a NULL is inserted into the database. if the value is 'NO', then any value specified for the VALUE attribute is inserted. remembering...NULL and empty string are really not the same things. An empty string is a value...it is a string with a length of 0. A NULL value however, has no value at all. doesn't exist. a big void. like that space between Anna Nicole's ears. charlie - Original Message - From: Tim Laureska To: CF-Talk Sent: Monday, October 20, 2003 1:20 PM Subject: RE: cfqueryparam error Thanks Raymond & Dave... that fixed it... can you help me get a better understanding of this piece of code: maxlength="2" null="#YesNoFormat(NOT Len(form.exp_years))#"> As I understand this, its saying the value type to be submitted MUST be numeric but I don't totally get what the rest does. I know it eaddresses an empty string but from there, I'm lost: null ="#YesNoFormat(NOT Len(form.exp_years))#" -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:07 PM To: CF-Talk Subject: Re:cfqueryparam error >Can someone help me understand why I'm getting this error on the code >below: > >ODBC Error Code = 22005 (Error in assignment) >[Microsoft][ODBC Microsoft Access Driver]Invalid character value for >cast specification (null) > > > > >INSERT INTO positions (exp_years) > >VALUES ( >value="#form.exp_years#" maxlength="2" >null="#numberFormat(Len(form.exp_years))#">) > > Why are you using numberFormat() for your null attribute? It should be: null="#yesNoFormat(NOT Len(trim(form.exp_years)))#" (Remember to use NOT, otherwise your value for null will be the reverse of what you really want it to be.) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet! Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP. Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfqueryparam error
Thanks Raymond & Dave... that fixed it... can you help me get a better understanding of this piece of code: maxlength="2" null="#YesNoFormat(NOT Len(form.exp_years))#"> As I understand this, its saying the value type to be submitted MUST be numeric but I don't totally get what the rest does. I know it eaddresses an empty string but from there, I'm lost: null ="#YesNoFormat(NOT Len(form.exp_years))#" -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:07 PM To: CF-Talk Subject: Re:cfqueryparam error >Can someone help me understand why I'm getting this error on the code >below: > >ODBC Error Code = 22005 (Error in assignment) >[Microsoft][ODBC Microsoft Access Driver]Invalid character value for >cast specification (null) > > > > >INSERT INTO positions (exp_years) > >VALUES ( >value="#form.exp_years#" maxlength="2" >null="#numberFormat(Len(form.exp_years))#">) > > Why are you using numberFormat() for your null attribute? It should be: null="#yesNoFormat(NOT Len(trim(form.exp_years)))#" (Remember to use NOT, otherwise your value for null will be the reverse of what you really want it to be.) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Solaris & Flash Remoting Components
So the includes that are part of the Flash Component install are already installed on the Server? I should be able to upload the files to the server and call the flash movie from a .cfm/.html movie in a browser? Do i have to have these installed on a local dev box to develop or can i just upload the files to the Server and test them there? NetServices.as: Enables the connection to the application server's Flash Remoting service (gateway). NetDebug.as: Enables the NetConnection Debugger utility for an application. DataGlue.as: Formats the exchanged data. RecordSet.as: Returns a recordset. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: another evaluate question
Yup - it did - it works in CF 4.5 as well. ;^) Jim Davis -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:11 PM To: CF-Talk Subject: RE: another evaluate question I believe bracket notation for queries worked in cf5. Try #getall["measure_#measureid#"][currentRow]# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A Lonely CFX - CFX_FileReadLn
Which version of CF are you on? In CFMX you could use the Java File Streamer very easily (I'm not completely sure what the syntax is, but I know it can be done easily.) Jim Davis -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 5:51 AM To: CF-Talk Subject: A Lonely CFX - CFX_FileReadLn Hi all. We had a need to read large text files in blocks of lines and so went looking for a suitable custom tag to do the base work for us. There are a few that read CSV files and convert them to queries but our files are pure text so they were unsuitable. Min's ReadLine does a great job but only one line at a time, not too good when you want to read a thousand line in one batch :-) We then found CFX_FileReadLn which is perfect, you can specify a start line and the number of lines to read and it returns the result in a query, just right for our needs :-) Unfortunately the tag is not freeware and we can't seem to be able to pay for it! The URL to its owner's website, http://www.liveye.com/cfx/, doesn't exist any more and we have failed to contact the creator by email. Does anyone know of the creator's or have other, working, contact details? -- Yours, Kym _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:cfqueryparam error
>Can someone help me understand why I'm getting this error on the code >below: > >ODBC Error Code = 22005 (Error in assignment) >[Microsoft][ODBC Microsoft Access Driver]Invalid character value for >cast specification (null) > > > > >INSERT INTO positions (exp_years) > >VALUES ( >value="#form.exp_years#" maxlength="2" >null="#numberFormat(Len(form.exp_years))#">) > > Why are you using numberFormat() for your null attribute? It should be: null="#yesNoFormat(NOT Len(trim(form.exp_years)))#" (Remember to use NOT, otherwise your value for null will be the reverse of what you really want it to be.) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: tree debug missing info
Well, the bottom line is that information is missing from the tree view in two or more places. Some custom tags are not shown, other includes are dropped and the parent/child relationship can get messed up resulting in branches of the tree being dropped. Looks like I'm going to have to find a second to rewrite this baby. Anyone already done it? > I've been using the tree version of the debug output and I love it. It gives > lots of info on the threading of pages. Problem is, it seems to be missing > multiple branches of a page. Has anyone seen this and is there a fix? If not > I'll be digging into it. > Thanks > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Homesite+ Error
Ok, we've solved the icon problem... :) Any idea what I need to do? Sounds like uninstalling and scraping the residue by hand from the registry is the only solution. Is the Homesite+ uninstaller that bad? - Original Message - From: "Tangorre, Michael" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 12:11 PM Subject: RE: Homesite+ Error > bingo.. thanks. > > > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 2:08 PM > To: CF-Talk > Subject: RE: Homesite+ Error > > > Open up a folder on your desktop ... go to >folder options, open the > FileTypes tab ... from there you can change the icons to anything you like. > > To get the HomeSite icons, find the .cfm listing, click on "advance" ... > click on "icon" browse to the HS application exe and click it ... a bevy of > ICON options will pop up. > > H. > > ~~ > Howard Owens > Internet Operations Coordinator > Ventura County Star / E.W. Scripps Co. > www.venturacountystar.com > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~ > > > -Original Message- > > From: Tangorre, Michael [SMTP:[EMAIL PROTECTED] > > Sent: Monday, October 20, 2003 10:09 AM > > To: CF-Talk > > Subject: RE: Homesite+ Error > > > > I used to get that too... I uninstalled, dug through the registry and > > deleted all keys pertainig to homesite, reinstalled to a different > > location... problem solved. > > However, all my .cfm files have icon types that look like word pad!!! How > > do > > i get them to appear with the homesite icon??? > > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 20, 2003 12:07 PM > > To: CF-Talk > > Subject: OT: Homesite+ Error > > > > Whenever I open Homesite+ I get an error along the lines of "The system > > cannot > > find the file". Occasionally it will display a large gray dialog box > > showing > > the contents of a template and some other error. The other thing I notice > > is > > that Homesite won't start in the "folder last opened in the Files tab" as > > I've > > got setup in the startup configuration. I've uninstalled and reinstalled > > with > > no improvement. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfqueryparam error
The value for null should be Yes or No (true or false), not a number. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
That is sooo sweet! Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP. Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5: Oracle recordset via StoredProc and QofQ questions
250K rows is our worst-case. We hope the majority are much smaller, say ~10K-20K. And the plan is not to dump the entire recordset to the client, but to build a "Next n" interface that will allow them to filter/sort the results and then scroll through the records 50 or so at a time. We plan to cache the recordset returned by the SP using QofQ. The main problem is that the SP is slow (and out of my control to change or optimize!) and we need a way to hit it once and then display/filter/sort the records in various ways. We could save ourselves a lot of headaches if there was a way to cache the SP recordset directly, but I don't see a way to do that. Any better ideas are certainly welcome! Thanks, Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:36 PM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ questions small recordsets perhaps, but the set you described will cause issues. Think about how much time it takes to run the SP and return all data to CF then down to the client. Also, the browser ain't gonna handle 100MB of data very well now, eh? Now, your DB call will take up a thread for a long time, if the user cancels a request this thread stays active. Non patient users will cause havoc here. Doug -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:24 PM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ questions So it's really just a question of RAM? No other serious performance concerns for retrieving record sets via SP? Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:08 PM To: CF-Talk Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfqueryparam error
Can someone help me understand why I'm getting this error on the code below: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) INSERT INTO positions (exp_years) VALUES ( value="#form.exp_years#" maxlength="2" null="#numberFormat(Len(form.exp_years))#">) Thanks Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Search Engine Tag
Hi Andy, Please check http://www.instantposition.com All search engine related tools are free but to use some of them you have to become a free member of the site. The one to submit your site to about 15 search engines requires a free membership acocunt its listed here. http://www.instantposition.com/free_tools.cfm Ketan Patel G3 Technology Group, LLC Graphics III Advertising, Inc. (410)789-7007 or (800)783-1799 "It's Not Creative if it doesn't Sell." http://www.g3group.com -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:33 PM To: CF-Talk Subject: Search Engine Tag Does anyone have a tag that registers sites with search engines? Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM: andy_ousterhout [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Good way to search XML
> There are a few useful tools for XPath out there, try this one: > > http://sourceforge.net/project/showfiles.php?group_id=54719 > &release_id=12838 > > It makes creating and testing XPath _expression_ much simpler You might also like this one: http://www.vbxml.com/xpathvisualizer/default.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
or use 1 to connect with the IP and the other to connect with the server name >>> [EMAIL PROTECTED] 10/20/03 03:07PM >>> Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Solaris & Flash Remoting Components
> trying to set up flash remoting using CF MX on a Sun Solaris box. > > are there Flash Remoting Components for Solaris? > Only mac and windows are listed here: The components you're looking at are for the Flash IDE, which is only available on Mac & Windows. On the server side, there's nothing additional you need to install beyond CFMX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Search Engine Tag
Does anyone have a tag that registers sites with search engines? Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM: andy_ousterhout [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
Thanks for the help. What is this script doing that a coldfusion trim()
function on the form field would not do? The problem seems to be that
regardless of the users action, the form field for the optional upload
always includes a temporary file. Trimming the form field will simply trim
the /tmp/dd33ddl43 value. Is this trim function done before the browser
interprets the users request or something?
thanks again, appreciate the help.
mike
Michael S. Haddon
Harvard Graduate School of Education, PPE
Web Developer
P: 617-496-8341
AOL: michaelshodgdon
Y!: michaelhodgdon
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 2:20 PM
To: CF-Talk
Subject: RE: problem with file uploads on a MAC
>-Original Message-
>From: Michael Hodgdon [mailto:[EMAIL PROTECTED]
>Sent: Monday, October 20, 2003 16:24
>To: CF-Talk
>Subject: problem with file uploads on a MAC
>
>I was hoping I could get some help on the list. Sort of at a loss for
this
>one. I am aware there are know issues with the MAC and IE doing for
>uploads. I have two upload boxes on a page. The first is required and
the
>second is optional. If a user selects both upload options, my code runs
>through fine. However, because of the temp file issue with MACS, if the
>user does not select a file for the second option, code errors out
because
>it tries an upload.
I came across this a while ago when implementing some code to
automatically
TRIM *all* form fields coming in. The code I have is:
if (IsDefined("form.fieldnames")) {
formFields = StructKeyArray(form);
for (i=1; i LTE ArrayLen(formFields); i=i+1) {
field = formFields[i];
IEMac = (FindNoCase("msie", CGI.HTTP_USER_AGENT)
AND FindNoCase("mac", CGI.HTTP_USER_AGENT));
if (NOT (ListFind("filePath,imagePath", field)
AND
NOT IEMac)) {
StructUpdate(form, field,
Trim(form[field]));
}
}
}
The tag's comments say:
"Trims all form fields automatically (to avoid having to remember later),
but *doesn't* trim file upload fields for anything *but* IE/Mac (this
browser needs to have uploads trimmed; everything else breaks if
trimmed)."
You'd have to adjust that ListFind() to accomodate whatever naming
conventions you have for file upload fields.
I'm referring to this code almost as if it's someone else's because I'm
currently totally baffled by it not working in our new framework. So I
can't completely vouch for it. BUT, it's been working OK in our other
sites, so more than likely there's an issue with something in our new
framework rather than this technique per se.
HTH,
Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: SQL Enterprise Manager
Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Enterprise Manager
Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials? It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5: Oracle recordset via StoredProc and QofQ questions
I've had serious performance issues with QofQ with larger recordsets...if it's beyond a few thousand...I'd stick to the DB layer. Stace _ From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: October 20, 2003 2:24 PM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ questions So it's really just a question of RAM? No other serious performance concerns for retrieving record sets via SP? Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:08 PM To: CF-Talk Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: another evaluate question
Nope: The element at position 3 in dimension 2 of object "getall" cannot be found. The object has elements in positions 1 through 2. Please, modify the index _expression_. However, that got me back on the right track. It actually should be: #getall["measure_#measureid#"][thisloop]# (Stupid inner loop issue.) -d - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 1:10 PM Subject: RE: another evaluate question > I believe bracket notation for queries worked in cf5. Try > > #getall["measure_#measureid#"][currentRow]# > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL Heirarchies
Well, the best solution at that point does not involve a database, but I appreciate your thoughts. M -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:41 PM To: CF-Talk Subject: RE: MySQL Heirarchies MySQL 5.0 (in alpha) has stored proc support. check http://www.mysql.com/doc/en/Roadmap.html and it's sub-pages for some info. You can do that loop using CF, if that suits you: INSERT INTO temp_table ... SELECT -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:34 AM To: CF-Talk Subject: RE: MySQL Heirarchies Barney - I suspect you are right, and that the real solution is to do the processing on the Web server side. The real problem is the lack of recursion in MySQL, and this issue is independent of stored procedures. It would be nice if it was possible to write a query, loop around it, and store intermediate results in a temporary table within the database. For the record, does anyone know if control structures such as this are being considered for future releases? M -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:26 PM To: CF-Talk Subject: RE: MySQL Heirarchies I don't think you'll be able to do it, because you can't use stored procedures with MySQL. You can use a temp table, if you want, though. Just run a CREATE TEMPORARY TABLE statement. However, I suspect that pulling the raw recordset back to CF and processing it there will be faster, because you're going to have to run a bunch of separate queries anyway, and doing QofQ on a recordset is almost exactly equivalent to using a temp table. barneyb -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:47 PM To: CF-Talk Subject: MySQL Heirarchies I am stumped on a MySQL query, it involves returning information sorted into a heirarchy. There's this table with the following fields: item_id, parent_id, and comment. Item_id is the unique identifier of each record, and each record can be a child of another. Parent_id reflects this relationship. I need to return a recordset sorted by parent_id, i.e.: item_one -- item_two item_three -- item_four item_five -- item_six item_seven item_eight -- item_nine item_ten etc... Help! I know how to do this in SQL Server and Oracle using temp tables, but am not finding the answer in MySQL. M _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
ooh Dave - how does that work? Sounds interesting. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 1:27 PM To: CF-Talk Subject: RE: CFHTTP Question! > so what are you suggesting? How do I use HTTP authentication > mechanism? As Jochem stated, you can't do this with CFHTTP alone. You will need to use an NTLM proxy if you can. This would sit between CF and the target server, somewhere. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Homesite (remove icons)
In homesite+ is there anyway, to remove those icons so that I get a bland general icon and my directory doesn't take 10 years to load? I did it in wsftp to make the directory load quicker, but I can remember how in homesite+ (if its possible.) thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL Heirarchies
MySQL 5.0 (in alpha) has stored proc support. check http://www.mysql.com/doc/en/Roadmap.html and it's sub-pages for some info. You can do that loop using CF, if that suits you: INSERT INTO temp_table ... SELECT -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:34 AM To: CF-Talk Subject: RE: MySQL Heirarchies Barney - I suspect you are right, and that the real solution is to do the processing on the Web server side. The real problem is the lack of recursion in MySQL, and this issue is independent of stored procedures. It would be nice if it was possible to write a query, loop around it, and store intermediate results in a temporary table within the database. For the record, does anyone know if control structures such as this are being considered for future releases? M -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:26 PM To: CF-Talk Subject: RE: MySQL Heirarchies I don't think you'll be able to do it, because you can't use stored procedures with MySQL. You can use a temp table, if you want, though. Just run a CREATE TEMPORARY TABLE statement. However, I suspect that pulling the raw recordset back to CF and processing it there will be faster, because you're going to have to run a bunch of separate queries anyway, and doing QofQ on a recordset is almost exactly equivalent to using a temp table. barneyb -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:47 PM To: CF-Talk Subject: MySQL Heirarchies I am stumped on a MySQL query, it involves returning information sorted into a heirarchy. There's this table with the following fields: item_id, parent_id, and comment. Item_id is the unique identifier of each record, and each record can be a child of another. Parent_id reflects this relationship. I need to return a recordset sorted by parent_id, i.e.: item_one -- item_two item_three -- item_four item_five -- item_six item_seven item_eight -- item_nine item_ten etc... Help! I know how to do this in SQL Server and Oracle using temp tables, but am not finding the answer in MySQL. M _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5: Oracle recordset via StoredProc and QofQ questions
small recordsets perhaps, but the set you described will cause issues. Think about how much time it takes to run the SP and return all data to CF then down to the client. Also, the browser ain't gonna handle 100MB of data very well now, eh? Now, your DB call will take up a thread for a long time, if the user cancels a request this thread stays active. Non patient users will cause havoc here. Doug -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:24 PM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ questions So it's really just a question of RAM? No other serious performance concerns for retrieving record sets via SP? Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:08 PM To: CF-Talk Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good way to search XML
> Yeah, you're right. I haven't done a whole lot with XPath, and it's been a > while since I've done any. I was totally drawing a blank with coming up > with that _expression_ you gave. Don't ask me why. There are a few useful tools for XPath out there, try this one: http://sourceforge.net/project/showfiles.php?group_id=54719&release_id=12838 5 It makes creating and testing XPath _expression_ much simpler Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL Heirarchies
Barney - I suspect you are right, and that the real solution is to do the processing on the Web server side. The real problem is the lack of recursion in MySQL, and this issue is independent of stored procedures. It would be nice if it was possible to write a query, loop around it, and store intermediate results in a temporary table within the database. For the record, does anyone know if control structures such as this are being considered for future releases? M -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:26 PM To: CF-Talk Subject: RE: MySQL Heirarchies I don't think you'll be able to do it, because you can't use stored procedures with MySQL. You can use a temp table, if you want, though. Just run a CREATE TEMPORARY TABLE statement. However, I suspect that pulling the raw recordset back to CF and processing it there will be faster, because you're going to have to run a bunch of separate queries anyway, and doing QofQ on a recordset is almost exactly equivalent to using a temp table. barneyb -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:47 PM To: CF-Talk Subject: MySQL Heirarchies I am stumped on a MySQL query, it involves returning information sorted into a heirarchy. There's this table with the following fields: item_id, parent_id, and comment. Item_id is the unique identifier of each record, and each record can be a child of another. Parent_id reflects this relationship. I need to return a recordset sorted by parent_id, i.e.: item_one -- item_two item_three -- item_four item_five -- item_six item_seven item_eight -- item_nine item_ten etc... Help! I know how to do this in SQL Server and Oracle using temp tables, but am not finding the answer in MySQL. M _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using FuseQ in Legacy FuseBox3 App
In order to solve some performance problems (presumably caused by recursive cfmodule calls), I'm trying to use FuseQ in a FB3 application. (I cannot consider upgrading the app to FB4, at this point, there isn't enough time.) I've already got a few CASEs working with addToQ()s, but It's breaking down when I try to get the whole site converted to FuseQ. BTW, I'm using FB3 layouts, as opposed to FuseQ layouts (if that makes any sense). Where's the best place to find low-level information on FuseQ? All I can find are "introductions" to FuseQ, but no documentation. (I've asked this question before, but was told to use FB4, which is no longer an option.) [Some code snippets follow, in hopes that someone might tell me that there's a general problem with my understanding of FuseQ.] Thanks, Jamie I've got a main layout file that looks something like this (most of the HTML is stripped out): #fusebox.layout# And this sort of thing in the switches: > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5: Oracle recordset via StoredProc and QofQ questions
RAM is the big one, but even if you solve that, remember that a DB is optimized to do data processing as fast as possible, while CF is designed as a web app language, that has some data processing facilities. Not to say that running QofQs is slow, but using a DB will undoubtedly be faster on large sets, because it can benefit from indexes and such, which CF doesn't get to use. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:24 AM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ questions So it's really just a question of RAM? No other serious performance concerns for retrieving record sets via SP? Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:08 PM To: CF-Talk Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Solaris & Flash Remoting Components
trying to set up flash remoting using CF MX on a Sun Solaris box. are there Flash Remoting Components for Solaris? Only mac and windows are listed here: http://www.macromedia.com/software/flashremoting/downloads/components/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL Heirarchies
I don't think you'll be able to do it, because you can't use stored procedures with MySQL. You can use a temp table, if you want, though. Just run a CREATE TEMPORARY TABLE statement. However, I suspect that pulling the raw recordset back to CF and processing it there will be faster, because you're going to have to run a bunch of separate queries anyway, and doing QofQ on a recordset is almost exactly equivalent to using a temp table. barneyb -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:47 PM To: CF-Talk Subject: MySQL Heirarchies I am stumped on a MySQL query, it involves returning information sorted into a heirarchy. There's this table with the following fields: item_id, parent_id, and comment. Item_id is the unique identifier of each record, and each record can be a child of another. Parent_id reflects this relationship. I need to return a recordset sorted by parent_id, i.e.: item_one -- item_two item_three -- item_four item_five -- item_six item_seven item_eight -- item_nine item_ten etc... Help! I know how to do this in SQL Server and Oracle using temp tables, but am not finding the answer in MySQL. M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5: Oracle recordset via StoredProc and QofQ questions
So it's really just a question of RAM? No other serious performance concerns for retrieving record sets via SP? Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:08 PM To: CF-Talk Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
> so what are you suggesting? How do I use HTTP authentication > mechanism? As Jochem stated, you can't do this with CFHTTP alone. You will need to use an NTLM proxy if you can. This would sit between CF and the target server, somewhere. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Good way to search XML
Yeah, you're right. I haven't done a whole lot with XPath, and it's been a while since I've done any. I was totally drawing a blank with coming up with that _expression_ you gave. Don't ask me why. -Original Message- From: Roger Benningfield [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 2:37 AM To: CF-Talk Subject: Re:Good way to search XML > > > Barney Boisvert > myPass > > > >...If you want to search that same snip by name, you >have to use XPath to get the entire user list in a CF array, and then loop >the array and search. Barney, Any reason you wouldn't just use: //user[name='Barney Boisvert'] -- Roger Benningfield JournURL community-powered weblogs & diaries work: http://journurl.com/ blog: http://admin.support.journurl.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
>-Original Message-
>From: Michael Hodgdon [mailto:[EMAIL PROTECTED]
>Sent: Monday, October 20, 2003 16:24
>To: CF-Talk
>Subject: problem with file uploads on a MAC
>
>I was hoping I could get some help on the list. Sort of at a loss for this
>one. I am aware there are know issues with the MAC and IE doing for
>uploads. I have two upload boxes on a page. The first is required and the
>second is optional. If a user selects both upload options, my code runs
>through fine. However, because of the temp file issue with MACS, if the
>user does not select a file for the second option, code errors out because
>it tries an upload.
I came across this a while ago when implementing some code to automatically
TRIM *all* form fields coming in. The code I have is:
if (IsDefined("form.fieldnames")) {
formFields = StructKeyArray(form);
for (i=1; i LTE ArrayLen(formFields); i=i+1) {
field = formFields[i];
IEMac = (FindNoCase("msie", CGI.HTTP_USER_AGENT)
AND FindNoCase("mac", CGI.HTTP_USER_AGENT));
if (NOT (ListFind("filePath,imagePath", field) AND
NOT IEMac)) {
StructUpdate(form, field, Trim(form[field]));
}
}
}
The tag's comments say:
"Trims all form fields automatically (to avoid having to remember later),
but *doesn't* trim file upload fields for anything *but* IE/Mac (this
browser needs to have uploads trimmed; everything else breaks if trimmed)."
You'd have to adjust that ListFind() to accomodate whatever naming
conventions you have for file upload fields.
I'm referring to this code almost as if it's someone else's because I'm
currently totally baffled by it not working in our new framework. So I
can't completely vouch for it. BUT, it's been working OK in our other
sites, so more than likely there's an issue with something in our new
framework rather than this technique per se.
HTH,
Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Homesite+ Error
bingo.. thanks. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:08 PM To: CF-Talk Subject: RE: Homesite+ Error Open up a folder on your desktop ... go to >folder options, open the FileTypes tab ... from there you can change the icons to anything you like. To get the HomeSite icons, find the .cfm listing, click on "advance" ... click on "icon" browse to the HS application exe and click it ... a bevy of ICON options will pop up. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ > -Original Message- > From: Tangorre, Michael [SMTP:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 10:09 AM > To: CF-Talk > Subject: RE: Homesite+ Error > > I used to get that too... I uninstalled, dug through the registry and > deleted all keys pertainig to homesite, reinstalled to a different > location... problem solved. > However, all my .cfm files have icon types that look like word pad!!! How > do > i get them to appear with the homesite icon??? > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 12:07 PM > To: CF-Talk > Subject: OT: Homesite+ Error > > Whenever I open Homesite+ I get an error along the lines of "The system > cannot > find the file". Occasionally it will display a large gray dialog box > showing > the contents of a template and some other error. The other thing I notice > is > that Homesite won't start in the "folder last opened in the Files tab" as > I've > got setup in the startup configuration. I've uninstalled and reinstalled > with > no improvement. > > _ > > > _ > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: another evaluate question
I believe bracket notation for queries worked in cf5. Try #getall["measure_#measureid#"][currentRow]# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite+ Error
Open up a folder on your desktop ... go to >folder options, open the FileTypes tab ... from there you can change the icons to anything you like. To get the HomeSite icons, find the .cfm listing, click on "advance" ... click on "icon" browse to the HS application exe and click it ... a bevy of ICON options will pop up. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ > -Original Message- > From: Tangorre, Michael [SMTP:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 10:09 AM > To: CF-Talk > Subject: RE: Homesite+ Error > > I used to get that too... I uninstalled, dug through the registry and > deleted all keys pertainig to homesite, reinstalled to a different > location... problem solved. > However, all my .cfm files have icon types that look like word pad!!! How > do > i get them to appear with the homesite icon??? > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 12:07 PM > To: CF-Talk > Subject: OT: Homesite+ Error > > Whenever I open Homesite+ I get an error along the lines of "The system > cannot > find the file". Occasionally it will display a large gray dialog box > showing > the contents of a template and some other error. The other thing I notice > is > that Homesite won't start in the "folder last opened in the Files tab" as > I've > got setup in the startup configuration. I've uninstalled and reinstalled > with > no improvement. > > _ > > > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite+ Error
And wouldn't you know it there go my icons for .cfm files back to the stupid little wordpad icons.. this damn program is annoying! -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 1:09 PM To: CF-Talk Subject: RE: Homesite+ Error I used to get that too... I uninstalled, dug through the registry and deleted all keys pertainig to homesite, reinstalled to a different location... problem solved. However, all my .cfm files have icon types that look like word pad!!! How do i get them to appear with the homesite icon??? -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:07 PM To: CF-Talk Subject: OT: Homesite+ Error Whenever I open Homesite+ I get an error along the lines of "The system cannot find the file". Occasionally it will display a large gray dialog box showing the contents of a template and some other error. The other thing I notice is that Homesite won't start in the "folder last opened in the Files tab" as I've got setup in the startup configuration. I've uninstalled and reinstalled with no improvement. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problem with file uploads on a MAC
On Monday, October 20, 2003, at 11:23 AM, Michael Hodgdon wrote: > I was hoping I could get some help on the list. Sort of at a loss for > this > one. I am aware there are know issues with the MAC and IE doing for > uploads. I have two upload boxes on a page. The first is required > and the > second is optional. If a user selects both upload options, my code > runs > through fine. However, because of the temp file issue with MACS, if > the > user does not select a file for the second option, code errors out > because > it tries an upload. > > Has anybody had this issue before? Do you know a way around it? I always do this for each file being uploaded: Basically, instead of erroring out it will set an "uploadFailed" boolean, which I then can use to programmatically deal with scenarios. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
Ok. That is what I am doing. My code on the action page looks like this Then, in the cffile tags I am using the to variables set to the trimmed form field values. The problem is that on the action page, if the user did not select the optional upload, it still returns a temporary file path. So in the debugging information at the bottom of my page, I get the following form variables: Form Variables: mandupload = /tmp/3445502 optupload = /tmp/309992992 On any other browser / OS, if the user does not select the optional form field, nothing gets sent accross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:52 PM To: CF-Talk Subject: RE: problem with file uploads on a MAC You need to make sure you trim any 'file' field. IE on a Mac (can't remember which version) always seems to add a Linefeed Character when the 'file' field is blank -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 16:24 To: CF-Talk Subject: problem with file uploads on a MAC I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? Let me know _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Microsoft JDBC vs CF builtin JDBC for SQL server Results
I figured since no one else had the answer to this that I would give you guys the result of what I just found out.
1. First I started off with a blank client variables database (just easier since it was already made and I was on a box that wasn't used)
2. Next I made a file called test.cfm and included this in it, this is the write test for the CF datasource.
Insert into cdata(cfid,app,data)
values('#i#','#i#','#text#')
3. Next I took away the write then made a query that just read what I put in.
Select *
From cdata
Where cfid = '#i#'
4. Now delete all data in your database and start over again, but change the name of the queries, I changed my to have a number 2 instead of a number 1 so there would be no caching issues.
The results
Write CF Datasource 3345 ms
Read CF Datasource 6990 ms
Write MS Datasource 3044 ms
Read MS Datasource 6369 ms
So the MS driver is faster, by 300 ms after 1000 read and writes, could help you bigger guys. Hope this helps anyone out there.
Bob Everland
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Nested
> Thanks for the tip - I'm sure I'd have tried that at some point in the > future and pulled out my hair wondering what I was doing wrong. :) > > - Jim > You actually can do it. I sent a message showing how earlier this morning, but last I checked it had *just* made it to the list. Watch for the timestamp. It probably came through as earlier than the original. Don't know why. Screwed up mailserver. -Patti > [EMAIL PROTECTED] wrote: > >> cmiiw... watch out for cfscript tho as far as I am aware cfscript >> doesn't support the multiple case features (ver5) and you need one for >> each item in your list ie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
another evaluate question
Short of hard-coding the 82 measure column names, is there a way to not use evaluate in this code? (CF 5.0) The query "getall" gets all the results from a survey, and getmeasures gets all the questions. #capnetid(getall.netid)# #getall.working_ttl# #getall.pa# #evaluate(thismeasure)# - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
It's look for domain based authentication (not clear text obviously) - meaning you are NOT going to be able to use CFHTTP to get this page. -Mark -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 10:58 AM To: CF-Talk Subject: Re:CFHTTP Question! When I output the http response headers, this is what gets displayed Output the Response Headers: Date : Mon, 20 Oct 2003 15:20:34 GMT Server : Microsoft-IIS/5.0 Content-Length : 4431 Content-Type : text/html Explanation : Access Denied Connection : close Status_Code : 401 WWW-Authenticate : NTLM Http_Version : HTTP/1.1 Does anybody have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite+ Error
I used to get that too... I uninstalled, dug through the registry and deleted all keys pertainig to homesite, reinstalled to a different location... problem solved. However, all my .cfm files have icon types that look like word pad!!! How do i get them to appear with the homesite icon??? -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:07 PM To: CF-Talk Subject: OT: Homesite+ Error Whenever I open Homesite+ I get an error along the lines of "The system cannot find the file". Occasionally it will display a large gray dialog box showing the contents of a template and some other error. The other thing I notice is that Homesite won't start in the "folder last opened in the Files tab" as I've got setup in the startup configuration. I've uninstalled and reinstalled with no improvement. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Nested
Thanks for the tip - I'm sure I'd have tried that at some point in the future and pulled out my hair wondering what I was doing wrong. :) - Jim [EMAIL PROTECTED] wrote: > cmiiw... watch out for cfscript tho as far as I am aware cfscript > doesn't support the multiple case features (ver5) and you need one for > each item in your list ie > > -Original Message- > From: Pascal Peters [mailto:[EMAIL PROTECTED] > Sent: 20 October 2003 14:51 > To: CF-Talk > Subject: RE: Nested > > > > -Original Message- > From: Bushy [mailto:[EMAIL PROTECTED] > Sent: maandag 20 oktober 2003 15:15 > To: CF-Talk > Subject: RE: Nested > > Opps...forgot oner other question. > > What happens if I require the value of > one value? > > > > > .. > > > I need the below > > Can I do a > > > > > .. > > > --Original Message Text--- > From: Bushy > Date: Mon, 20 Oct 2003 09:08:43 -0400 > > I see. > > Thanks > > --Original Message Text--- > From: [EMAIL PROTECTED] > Date: Mon, 20 Oct 2003 14:08:47 +0100 > > > > > .. > > > > .. > > > > .. > > > and so on > > > ... > > > > -Original Message- > From: Bushy [mailto:[EMAIL PROTECTED] > Sent: 20 October 2003 13:52 > To: CF-Talk > Subject: RE: Nested > > I've never used > example using my below code? > > --Original Message Text--- > From: Hugo Ahlenius > Date: Mon, 20 Oct 2003 14:44:03 +0200 > > Bushy, > > Are you aware of cfelseif and cfswitch/cfcase? Did you check the > performance of you current code (is it a huge issue?). I am not sure if > cfelseif or cfswitch runs that much faster, but it sure would make > cleaner > code. > > - > Hugo Ahlenius E-Mail: [EMAIL PROTECTED] > Project Officer Phone: +46 8 230460 > UNEP GRID-Arendal Fax: +46 8 230441 > Stockholm Office Mobile: +46 733 467111 > WWW: http://www.grida.no > - > > | -Original Message- > | From: Bushy [mailto:[EMAIL PROTECTED] > | Sent: Monday, October 20, 2003 14:41 > | To: CF-Talk > | Subject: re: Nested > | > | > | Hi, > | > | I have a piece of code where I'm checking a session variable > | > | > | Do this... > | > | > | Do this... > | > | > | Do this... > | > | > | Do this... > | > | This goes for 20 nested . Is there a way to do this > | so it run faster? Is it better to just end each > | or nest them? > | > | > | > | > | > _ > > _ > > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
Can't you test the upload form field?? IF (LenTrim((form.fileUpload1)) EQ 0) OR (Trim(form.fileUpload) EQ "") upload ELSE dont upload.. -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:24 AM To: CF-Talk Subject: problem with file uploads on a MAC I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? Let me know _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
try a HTH -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 16:24 To: CF-Talk Subject: problem with file uploads on a MAC I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? Let me know _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problem with file uploads on a MAC
You need to make sure you trim any 'file' field. IE on a Mac (can't remember which version) always seems to add a Linefeed Character when the 'file' field is blank -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 16:24 To: CF-Talk Subject: problem with file uploads on a MAC I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? Let me know _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
tree debug missing info
I've been using the tree version of the debug output and I love it. It gives lots of info on the threading of pages. Problem is, it seems to be missing multiple branches of a page. Has anyone seen this and is there a fix? If not I'll be digging into it. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFHTTP Question!
ColdFusion Programmer wrote: > so what are you suggesting? How do I use HTTP authentication mechanism? "I doubt that is implemented in cfhttp." Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested
> cmiiw... watch out for cfscript tho as far as I am aware cfscript
> doesn't support the multiple case features (ver5) and you need one for
> each item in your list ie
yes it does.
switch (_expression_) {
case 'a':
case 'b':
stuff that happens when either a or b is the value;
break;
case 'c':
c stuff;
break;
default:
stuff;
break;
}
-Patti
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re:CFHTTP Question!
so what are you suggesting? How do I use HTTP authentication mechanism? >ColdFusion Programmer wrote: >> >> Date : Mon, 20 Oct 2003 15:20:34 GMT >> Server : Microsoft-IIS/5.0 >> Content-Length : 4431 >> Content-Type : text/html >> Explanation : Access Denied >> Connection : close >> Status_Code : 401 >> WWW-Authenticate : NTLM >> Http_Version : HTTP/1.1 >> >> Does anybody have any ideas? > >According to the web server, you need to use HTTP authentication >(mechanism described in RFC 2617) using the propietary NTLM >system from Microsoft. I doubt that is implemented in cfhttp. > >Jochem > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CALLER Scope in CFFUNCTION???
Is there a way to reference the local variables and arguments on a calling CFFunction? I have a CFC which contains a few Functions that call each other, and sometimes themselves. Can I access variables of the caller function in any way (other than passing them directly to the function). Sort of like this... ... TIA, Igor cccfug.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF5: Oracle recordset via StoredProc and QofQ questions
Lofback, Chris wrote: > > 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM. > 2) Can QofQ handle a recordset that large? If you have the RAM. Remember that with every QoQ you create a new recordset that needs to be stored in RAM. Plus the output page needs to be stored in RAM. I would rethink and try to do more in the DB. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Homesite+ Error
Whenever I open Homesite+ I get an error along the lines of "The system cannot find the file". Occasionally it will display a large gray dialog box showing the contents of a template and some other error. The other thing I notice is that Homesite won't start in the "folder last opened in the Files tab" as I've got setup in the startup configuration. I've uninstalled and reinstalled with no improvement. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFHTTP Question!
ColdFusion Programmer wrote: > > Date : Mon, 20 Oct 2003 15:20:34 GMT > Server : Microsoft-IIS/5.0 > Content-Length : 4431 > Content-Type : text/html > Explanation : Access Denied > Connection : close > Status_Code : 401 > WWW-Authenticate : NTLM > Http_Version : HTTP/1.1 > > Does anybody have any ideas? According to the web server, you need to use HTTP authentication (mechanism described in RFC 2617) using the propietary NTLM system from Microsoft. I doubt that is implemented in cfhttp. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5: Oracle recordset via StoredProc and QofQ questions
All-- Two questions for CF5, Win2K and IIS5. 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky? 2) Can QofQ handle a recordset that large? Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFHTTP Question!
When I output the http response headers, this is what gets displayed Output the Response Headers: Date : Mon, 20 Oct 2003 15:20:34 GMT Server : Microsoft-IIS/5.0 Content-Length : 4431 Content-Type : text/html Explanation : Access Denied Connection : close Status_Code : 401 WWW-Authenticate : NTLM Http_Version : HTTP/1.1 Does anybody have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
problem with file uploads on a MAC
I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? Let me know [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form and hidden variable question
The JS is working AOKyou just havent asked it to put the value in the hidden fieldtry this and you will see what I mean.. watch the wrapping ;-) Untitled
function subme() {
method1();
document.frm.outputselection.value = PagecontentA + PagecontentB +
PagecontentC;
alert(document.frm.outputselection.value);
document.frm.submit();
}
function method1(){
PagecontentA ="Hello";
PagecontentB ="And";
PagecontentC ="Welcome";
}
VALUE="Calculate"> -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 15:13 To: CF-Talk Subject: Re: Form and hidden variable question The source you see is what is actually fed to the browser (typically, anyway). The JS changes what's in the browser's memory, but not what it thinks the source is. This is not really any different from the fact that, when you type something into a textbox, it doesn't change the source display. It sounds like the JS is working correctly. Check the value of the contents on the action page to see if what you want is really getting through. --BenD Allan Clarke wrote: > Hi Guys, > > I desparately need somebody to help me. I have a form > which has hidden variable, a textarea and a submit > button. When the submit button is clicked a OnClick > event calls a function subme() method. Here is my code > > > > VALUE="Calculate"> > > rows="5"> > > > > Here is the javacript code: > >
> function subme() {
> method1();
> document.frm.outputselection.value = PagecontentA +
> PagecontentB + PagecontentC;
> alert(document.frm.outputselection.value);
> document.frm.submit();
> }
>
> function method1(){
> PagecontentA ="Hello";
> PagecontentB ="And";
> PagecontentC ="Welcome";
> }
>
> > > When browsed in the browser on form submission the > alert displays the value "Hello And Welcome" but for > some reason when I view the source in the browser the > value of the hidden variable "outputselection" is > empty. I want to populate the textbox with the value > in the hidden variable. I am struggling to do this. > Can somebody please show me how to do this, I would > really appreciate your help > > Best Regards, > Allan > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CALLER Scope in CFFUNCTION???
No, you can't access local var scoped vars from method A in method B, and honestly you should not. It's bad design. If method B needs to know something, the value should be passed to it, or, you should have another method that will return it that you can call from method B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Form and hidden variable question
Original Message: > From: Allan Clarke <[EMAIL PROTECTED]> > When browsed in the browser on form submission the > alert displays the value "Hello And Welcome" but for > some reason when I view the source in the browser the > value of the hidden variable "outputselection" is > empty. I want to populate the textbox with the value > in the hidden variable. I am struggling to do this. I believe that viewing the source of a page will only show you the page's source when it was first loaded. If you dynamically change the content of the page, it won't change the page's source. So, if your hidden form field is empty when the page loads, viewing it will show you an empty form field, even if it actually now has a value in it. You said that the text area gets the value correctly, but then disappears when the form is submitted. What happens after the form is submitted? If the page just gets reloaded, then the textarea will stay empty. Do you have a URL where we can look at what's happening? Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form and hidden variable question
Have you tried just doing a #frm.outputselection# on your target cfm page just to see if it is in fact empty? -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: October 20, 2003 10:10 AM To: CF-Talk Subject: Re:Form and hidden variable question Makes no difference, the value in the hidden variable is still empty. I tried this is in subme function: document.frm.txtarea1.value = document.frm.outputselection.value; On form submission, I see the textarea briefly populated with the value in the hidden variable but it dissapears when the form is fully submitted. Should I be adding something between the textarea tag? Something _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CALLER Scope in CFFUNCTION???
Is there a way to reference the local variables and arguments on a calling CFFunction? I have a CFC which contains a few Functions that call each other, and sometimes themselves. Can I access variables of the caller function in any way (other than passing them directly to the function). Sort of like this... ... TIA, Igor cccfug.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested
cmiiw... watch out for cfscript tho as far as I am aware cfscript doesn't support the multiple case features (ver5) and you need one for each item in your list ie -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 14:51 To: CF-Talk Subject: RE: Nested -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: maandag 20 oktober 2003 15:15 To: CF-Talk Subject: RE: Nested Opps...forgot oner other question. What happens if I require the value of one value? .. I need the below Can I do a .. --Original Message Text--- From: Bushy Date: Mon, 20 Oct 2003 09:08:43 -0400 I see. Thanks --Original Message Text--- From: [EMAIL PROTECTED] Date: Mon, 20 Oct 2003 14:08:47 +0100 .. .. .. and so on ... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 13:52 To: CF-Talk Subject: RE: Nested I've never used example using my below code? --Original Message Text--- From: Hugo Ahlenius Date: Mon, 20 Oct 2003 14:44:03 +0200 Bushy, Are you aware of cfelseif and cfswitch/cfcase? Did you check the performance of you current code (is it a huge issue?). I am not sure if cfelseif or cfswitch runs that much faster, but it sure would make cleaner code. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Bushy [mailto:[EMAIL PROTECTED] | Sent: Monday, October 20, 2003 14:41 | To: CF-Talk | Subject: re: Nested | | | Hi, | | I have a piece of code where I'm checking a session variable | | | Do this... | | | Do this... | | | Do this... | | | Do this... | | This goes for 20 nested . Is there a way to do this | so it run faster? Is it better to just end each | or nest them? | | | | | _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: SQL Script Generation Tools
To further help here, the ER series is from Embarcadero Software ( http://www.embarcadero.com ). -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:43 PM To: CF-Talk Subject: Re:OT: SQL Script Generation Tools Yes, called CASE tool or Data Modeling Tool, products include ERwin, ERstudio etc. the former is more powerful while the later is easier to use. Don Li http://www.hegelsoftware.com >I know this isn't directly related to CF but it's something that I've seen >out there before and hopefully someone knows what I'm talking about. At my >last web job there was a stored procedure or extended stored procedure that >you could call and pass a database name, table name and action and it would >generate stored procedures to handle the action... for example if you had a >users table you could pass in the action insert and it would create a stored >procedure for inserting entries into the table. > >Has anyone else heard of this and know where I can get it? > >Thanks! >Hatton Humphrey > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
