help, cfmx 6.1 just hangs!
We are having some issues with one of our new CFMX servers that I am configuring. FOr some reason I just can't seem to get CF working happily. Whenever I try to load a .cfm page on the server, the page just churns and churns and finally times out... I am running CFMX 6.1 on RHEL3 with Apache. When I install the server using the standalone webserver on port 8500 it works great. If configured for apache, it does not work and just acts like it is loading and loading and loading...but never loads. Any help would be greatly appreciated! Thanks, Josh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to post a null date variable to a table
>Why not use the cfqueryparam tag -- which you should be using anyway :-) Good Question -- used it and got success -- both blank and populated date fields now post without error -- Wh Ho !! But had trouble getting the exact syntax you suggested to work for me -- so ended up with the following construct -- probably can shorten it when I am awake in the am -- but your advice got me on the right track -- a gold star for your -- thanks UPDATE MYTABLE SET AGT_TO_DTC = VALUE = "#AGT_TO_DTC#" null="#mTEST#" /> WHERE ID_NUMBER = '#mFINDIT#' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 ODBC problems?
Solution : Dont use ODBC Driver with MS-SQL Server. Options 1. Checkout the Microsoft JDBC Driver for MS-SQL (Better Performance) Or 2. You can use the CFMX JDBC Driver HTH Joe Eugene -Original Message- From: Chad Nikirk [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 8:44 PM To: CF-Talk Subject: CF MX 6.1 ODBC problems? Hi, We are running MX 6.1. MX seems to run fine, but about every 8 - 12 hours it crashes. Our site will come back with a coldfusion datasource error after a while. The datasource can connect to the database no problem even while the error is occuring. The only way to fix it is to restart the mx services. I should also mention we are runnning in distributed mode, although I don't believe it would matter. We are also using MS SQL for the database. Any ideas on how to solve this problem? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Importing Access to MSSQL
i use this, pretty slick, takes about 30 seconds http://www.data-conversions.net/access2mysqlpro.html > Several ways to do this. > > Use the upsizing wizard -- but I'm told that there are problems using > that approach for data -- okay to get the table structures in place I > think. Alternatively, create the new tables manually in MSSQL. > > Once the tables are in place, use CF to query the Access Table and then > use CF to Insert recrods into MSSQL table. > > Another way is to use a Windows app in client-server mode with ODBC > drivers to do the Query and Post process -- I use Visual FoxPro and ODBC > drivers for this purpose a lot irrespective of what the "from" and "to" > databases are (Excel, Text, Access, MySQL, MSSQL, Oracle, etc). > > Both of these processes allow for a lot of data checking and cleanup to > be done in the migration process because of FoxPro's extensive string > and date manipulation functions. Processing Datetime fields can be a > bugger to deal with especially going from other than Access to MSSQL. > > To give you some performance numbers, I deleted and then created a new > MSSQL table located at a hosting service from a local 10,000 record > FoxPro DBF file -- the process took about 20 minutes over a 56k modem. > > Just another two cents -- hope it helps... > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to post a null date variable to a table
Why not use the cfqueryparam tag (which you should be using anyway :-) What you can do is take advantage of the "null" attribute in the tag. Use an _expression_ in the null attribute like this: null="#Len(someVariable) EQ 0#" /> Now if the _expression_ returns true, the value is ignored and NULL is used. If it returns false, the value is used... Does that help? Mike > -Original Message- > From: Arden Weiss [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 10:44 PM > To: CF-Talk > Subject: How to post a null date variable to a table > > How to post a null date to SQL Server 2000 via a variable > instead of just using the word "Null" or do I have to use an > embedded CASE statement. > > > UPDATE mytable > SET > APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine > APRV_DATE = Null <-- This posts a Null Date to "mytable" > WHERE L_NUMBER = '#mFINDIT#' > > > Hope the question is clear... > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to post a null date variable to a table
-Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED] Sent: Tue 4/6/2004 9:44 PM To: CF-Talk Cc: Subject: How to post a null date variable to a table How to post a null date to SQL Server 2000 via a variable instead of just using the word "Null" or do I have to use an embedded CASE statement. UPDATE mytable SET APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine APRV_DATE = Null <-- This posts a Null Date to "mytable" WHERE L_NUMBER = '#mFINDIT#' Hope the question is clear... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to post a null date variable to a table
Yes the existing code works, but what if the variable #appl_date# becomes blank on the user's input form/field -- then a 1/1/1900 date gets posted to the APPL_DATE field in MYTABLE table. APPL_DATE = #APPL_DATE# , The alternative is to use a CASE statement in the UPDATE query, but I can't seem to get that syntax right either... Brain Cramp time I guess... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to post a null date variable to a table
just like that, to my knowledge? if you do that, does it put 01/01/1900? or does it put null? tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:44 PM To: CF-Talk Subject: How to post a null date variable to a table How to post a null date to SQL Server 2000 via a variable instead of just using the word "Null" or do I have to use an embedded CASE statement. UPDATE mytable SET APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine APRV_DATE = Null <-- This posts a Null Date to "mytable" WHERE L_NUMBER = '#mFINDIT#' Hope the question is clear... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to post a null date variable to a table
How to post a null date to SQL Server 2000 via a variable instead of just using the word "Null" or do I have to use an embedded CASE statement. UPDATE mytable SET APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine APRV_DATE = Null <-- This posts a Null Date to "mytable" WHERE L_NUMBER = '#mFINDIT#' Hope the question is clear... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript Remoting (js web service accessing stuff)
> >On Apr 6, 2004, at 10:09 AM, Thomas Chiverton wrote:
> > In the chatdemo, what tells it to link the messages ThinArray
> > _javascript_
> > object, to the query returned byrobject.getMessages (that I can see
> > calls a
> > web service) ?
> On Tue, 2004-04-06 at 10:40, Dick Applebaum wrote:
> // sets up a thin array object named message
> var messages = new ThinArray();
>
> // creates a DefaultHandler that specifies the messages object as
>//the target of the (to be issued) ws request
> dh = new DefaultHandler("messages");
>
> // invokes the ws passing lastid and chatroom, naming the dh handler
>// as the recipient
> robject.getMessages(
> lastid,
> xmlformat(document.chatform.room.value),
>dh.handle
>);
>
Those are the steps, but to add a bit so you know the skinny:
var messages = new ThinArray();
Obviously makes a thin array, you could also do ... = new Map() if you
were passing a native cf structure or ... = new List() if you were
passing a native cf array.
dh = new DefaultHandler("messages");
This is the begining to the answer. The default handlers job is to parse
the SOAP response from the web service and translate the cf data type to
the _javascript_ data type. (Note the variable name is passed in in
quotes.)
robject.getMessages(lastid, dh.handle);
This is, as you said, a web service call. The last parameter is the
handler (it is not defined in the cfc). It's a bit like passing a
pointer in C - the last variable should be the handler if you want to do
anything with the web service result.
After the call is made
alert(message);
will show you the new value.
BTW here is a quick cf-js data type mapping
CF JS
---
String String
Numeric parseInt(String), parseFloat(String) etc
Struct Map()
Array List()
Query ThinArray() and using the cfBAM.cfc on the
server
Cheers,
--
Rob <[EMAIL PROTECTED]>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CF MX 6.1 ODBC problems?
Hi, We are running MX 6.1. MX seems to run fine, but about every 8 - 12 hours it crashes. Our site will come back with a coldfusion datasource error after a while. The datasource can connect to the database no problem even while the error is occuring. The only way to fix it is to restart the mx services. I should also mention we are runnning in distributed mode, although I don't believe it would matter. We are also using MS SQL for the database. Any ideas on how to solve this problem? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF cluster setup... is there a howto somewhere?
Barney Boisvert wrote: >Probably the biggest boon to doing it without J2EE is that you can >save $3K per machine because you only need CFMX Standard, not CFMX >Enterprise/J2EE. Well that is very interesting. I think these guys are wanting to stick to a traditional setup though. Found this by searching for "ClusterCATS" at mm.com. http://livedocs.macromedia.com/coldfusion/6/Using_ClusterCATS/ This was in the CF 6 docs and not CF 6.1. Is ClusterCATS gone from CF 6.1? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Importing Access to MSSQL
Several ways to do this. Use the upsizing wizard -- but I'm told that there are problems using that approach for data -- okay to get the table structures in place I think. Alternatively, create the new tables manually in MSSQL. Once the tables are in place, use CF to query the Access Table and then use CF to Insert recrods into MSSQL table. Another way is to use a Windows app in client-server mode with ODBC drivers to do the Query and Post process -- I use Visual FoxPro and ODBC drivers for this purpose a lot irrespective of what the "from" and "to" databases are (Excel, Text, Access, MySQL, MSSQL, Oracle, etc). Both of these processes allow for a lot of data checking and cleanup to be done in the migration process because of FoxPro's extensive string and date manipulation functions. Processing Datetime fields can be a bugger to deal with especially going from other than Access to MSSQL. To give you some performance numbers, I deleted and then created a new MSSQL table located at a hosting service from a local 10,000 record FoxPro DBF file -- the process took about 20 minutes over a 56k modem. Just another two cents -- hope it helps... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Devnet Pro now only $599!
The online store has that price as an upgrade from Studio MX. -- Howard Fore, [EMAIL PROTECTED] On Apr 6, 2004, at 5:20 PM, Kwang Suh wrote: > Blark, it's actually only for renewals. Ah well. > > - Original Message - > From: Irvin Gomez <[EMAIL PROTECTED]> > Date: Tuesday, April 6, 2004 3:18 pm > Subject: Re: Devnet Pro now only $599! > >> Mine only said that the DevNet Essentials subscription was >> discontinued. >> That would be good news, though... >> >> >>> Whoa, just got an email from MM saying that Devnet Pro is now >> only >>> US$599. That's the deal of a lifetime. >> >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF cluster setup... is there a howto somewhere?
You can use J2EE clustering, now that CF is a J2EE app. However, that may or may not be needed. We built out a cluster last year and we don't have any clustering software beyond a custom webservices-based framework for keeping memory caches synchronized and a shared database for client data (no use of the session scope). Obviously the load balancers are aware of the cluster and the CF machines need to know who's alive for cache syncing, but we set it up so the CF machines query the load balancers for that data rather than maintaining it themselves. Probably the biggest boon to doing it without J2EE is that you can save $3K per machine because you only need CFMX Standard, not CFMX Enterprise/J2EE. Cheers, barneyb > -Original Message- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 3:07 PM > To: CF-Talk > Subject: CF cluster setup... is there a howto somewhere? > > The subject line tells it all. I've been asked to help put > together a cluster for some colleagues and none of us have > done it before. Can CF become cluster-aware all by itself or > does it need clustering software? Am heading over to MM.com > to see what I could find but if anyone knows of any resource > links I'd sure appreciate a heads-up. > > -- > --- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > --- > > -- > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF cluster setup... is there a howto somewhere?
The subject line tells it all. I've been asked to help put together a cluster for some colleagues and none of us have done it before. Can CF become cluster-aware all by itself or does it need clustering software? Am heading over to MM.com to see what I could find but if anyone knows of any resource links I'd sure appreciate a heads-up. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Devnet Pro now only $599!
Blark, it's actually only for renewals. Ah well. - Original Message - From: Irvin Gomez <[EMAIL PROTECTED]> Date: Tuesday, April 6, 2004 3:18 pm Subject: Re: Devnet Pro now only $599! > Mine only said that the DevNet Essentials subscription was > discontinued. > That would be good news, though... > > > > Whoa, just got an email from MM saying that Devnet Pro is now > only > > US$599. That's the deal of a lifetime. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Devnet Pro now only $599!
Mine only said that the DevNet Essentials subscription was discontinued. That would be good news, though... > Whoa, just got an email from MM saying that Devnet Pro is now only > US$599. That's the deal of a lifetime. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Video Formats
> Any opinions on if 20 Meg files can be uploaded through a web > interfacereliably, Yes. and what the best way is to play an mov file > would be > appreciated. Use a Quicktime server, such as Darwin: http://developer.apple.com/darwin/projects/streaming/ FYI, QT files are generally very large (worse than average compression algorithms). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Devnet Pro now only $599!
Whoa, just got an email from MM saying that Devnet Pro is now only US$599. That's the deal of a lifetime. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Video Formats
I have a client with a site that was coded to only allow avi video file uploads and then just calling them directly with a browser. I've modified the code to allow .mov files, but the mov files they're trying are 15-20 Meg. I can't get one to finish uploading through my DSL. Also after FTPing the 20 Meg mov file up manually trying to play the file using isn't really working either. 20 minutes and it's only halfway here. Any opinions on if 20 Meg files can be uploaded through a web interface reliably, and what the best way is to play an mov file would be appreciated. Oh and DSL Reports shows I'm getting 186 kbps down and 71 kbps up. Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
Why index on integer fields and date fields only ? CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
ive made up my mind...im going to leave a little space at the end of each post that reads like this: Blah blah blah (my answer) Jochem please finish: [insert jochems real thoughts and any RFC's that pertain hitherto:] :) sorry jochem. I had to. tony -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 4:30 PM To: CF-Talk Subject: RE: SQL Query Tony Weeg said: > if correctly indexed, none. That is not entirely true, but for databases where the index is cached in RAM and the data pages are on disk it is a reasonable aproximation. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Importing Access to MSSQL
Tried that. They are still complaining. The database is actually compacted everynight, that bough me time the last time :) - Original Message - From: Barney Boisvert To: CF-Talk Sent: Tuesday, April 06, 2004 4:30 PM Subject: RE: Importing Access to MSSQL Have you compressed the access database? I don't know if there is a way to programmatically do this, but it can dramatically reduce the size of an access file. Hardly the solution you're looking for, but it might be good enough to buy you some time. Cheers, barneyb > -Original Message- > From: Mickael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:16 PM > To: CF-Talk > Subject: Importing Access to MSSQL > > Hello All, > > I am not really experienced in MSSQL but I have been notified > by my hosting provider that I can't keep using access on > their server due to the size of my access databases. My > problem is that I have an access database sent via FTP to my > server overnight that is created from an application that I > do not have access to. > > My Question is how difficult is it to take the Access > database that the over night process sends me, import it into > MSSQL(deleting all the records first) with CF, then delete > the Access database that was FTP'd to me with CFFILE? > > It sounds easy enough I just have no clue how to go about it > > Can anyone point me in the right direction? > > Thanks > > > Mike > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Quit Working
Have any security patches been applied? I would check to see if the ISAPI for ..cfm is mapped -Goto your Master website properties. -Click Home Directory -Click Configuration - the application mappings will be displayed. Hope that helps. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:04 PM To: CF-Talk Subject: CF Quit Working CF 4.5 on XP Pro (IIS), test machine Came back from vacation and CF pages no longer get served. HTM pages serve correctly. Can't open administrator, naturally. I get the "The Page Cannot Be Displayed" error message. Removal and reinstallation of CF changes nothing. Any suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL Query
>>Querying from a table of 500,000 rows or querying from a table of 1 million rows? Not really a big difference. If at least the table is indexed of course. The nature of b-trees structure in indexes makes the overhead roughly like the logarithm of the number of rows, and the logarithm of 1 million is not that higher than the logarithm of 500 000. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Access to MSSQL
Have you compressed the access database? I don't know if there is a way to programmatically do this, but it can dramatically reduce the size of an access file. Hardly the solution you're looking for, but it might be good enough to buy you some time. Cheers, barneyb > -Original Message- > From: Mickael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:16 PM > To: CF-Talk > Subject: Importing Access to MSSQL > > Hello All, > > I am not really experienced in MSSQL but I have been notified > by my hosting provider that I can't keep using access on > their server due to the size of my access databases. My > problem is that I have an access database sent via FTP to my > server overnight that is created from an application that I > do not have access to. > > My Question is how difficult is it to take the Access > database that the over night process sends me, import it into > MSSQL(deleting all the records first) with CF, then delete > the Access database that was FTP'd to me with CFFILE? > > It sounds easy enough I just have no clue how to go about it > > Can anyone point me in the right direction? > > Thanks > > > Mike > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
Tony Weeg said: > if correctly indexed, none. That is not entirely true, but for databases where the index is cached in RAM and the data pages are on disk it is a reasonable aproximation. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
In general, if you use a field in JOINs, or in the WHERE, HAVING, GROUP BY or ORDER BY clauses, you might benefit from indexing. The flip side is that UPDATEs, INSERTs and DELETEs that affect indexed fields run slower, because they don't have to just change the data, they also have to mess with the index. I usually start with indexes on the primary key and foreign keys (which you can't avoid) and then ignore the rest of the fields until I start finding bottlenecks. Occasionally I find them during development, but it's usually during QA and load testing where they start to appear. It also helps to have the queries written first, before you add indexes, because you can see how the fields are actually used, rather than the guesses you have to make before they're written. Cheers, barneyb > -Original Message- > From: brobborb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:10 PM > To: CF-Talk > Subject: Re: SQL Query > > Yes, indexing helps a wholebunch! But how does one practice > indexing correctly? Which fields should be indexed? Right > now, all the identity fields are indexed. Was wondering if > there is aything else that should be index > - Original Message - > From: Tony Weeg > To: CF-Talk > Sent: Tuesday, April 06, 2004 3:03 PM > Subject: RE: SQL Query > > > if correctly indexed, none. > > I have a table that is 1.57 millions rows, we index on an > integer field, and > I can return to a cf page, a recordset with 100+ rows in > milliseconds > > its all about the indexing. > > tw > > -Original Message- > From: brobborb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 3:38 PM > To: CF-Talk > Subject: SOT: SQL Query > > hey guys, what do u think the performance difference is in > MS SQL Server > 2000 > > Querying from a table of 500,000 rows or querying from a > table of 1 million > rows? > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
AuthorizeNet
Maybe I'm out of it. I remember at one time seeing a freeware AuthorizeNet CFC out there, does anyone know where I might find it? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
a rule of thumb @ my company index on integer fields and date fields only tony -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 4:10 PM To: CF-Talk Subject: Re: SQL Query Yes, indexing helps a wholebunch! But how does one practice indexing correctly? Which fields should be indexed? Right now, all the identity fields are indexed. Was wondering if there is aything else that should be index - Original Message - From: Tony Weeg To: CF-Talk Sent: Tuesday, April 06, 2004 3:03 PM Subject: RE: SQL Query if correctly indexed, none. I have a table that is 1.57 millions rows, we index on an integer field, and I can return to a cf page, a recordset with 100+ rows in milliseconds its all about the indexing. tw -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:38 PM To: CF-Talk Subject: SOT: SQL Query hey guys, what do u think the performance difference is in MS SQL Server 2000 Querying from a table of 500,000 rows or querying from a table of 1 million rows? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Importing Access to MSSQL
Hello All, I am not really experienced in MSSQL but I have been notified by my hosting provider that I can't keep using access on their server due to the size of my access databases. My problem is that I have an access database sent via FTP to my server overnight that is created from an application that I do not have access to. My Question is how difficult is it to take the Access database that the over night process sends me, import it into MSSQL(deleting all the records first) with CF, then delete the Access database that was FTP'd to me with CFFILE? It sounds easy enough I just have no clue how to go about it Can anyone point me in the right direction? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Query
How do you optimize an index? I tried dumping the old one and creating a new one. Something like that. I will have to read more on the isolation levels. They are a bit confusing to me! - Original Message - From: Paul Kenney To: CF-Talk Sent: Tuesday, April 06, 2004 3:02 PM Subject: RE: SQL Query Depends on a lot of things... 1. how many fields make up your search criteria? 2. What is the datatype of those fields? 3. Are those fields indexed, and if so are they being used? 4. What indexes are being used by your query? 5. What kinds of indexes are being used? 6. Are those indexes optimized? 7. What is the distribution of values within that index? 8. Are you running the query with an implicit or explicit transaction? 9. How many users are concurrently trying to access those rows (row lock contention)? 10. What isolation level is your transaction using? 11. I'm sure there is more... When in doubt, just fill the table with more data and see for yourself. Paul Kenney [EMAIL PROTECTED] 916-212-4359 > -Original Message- > From: brobborb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 12:38 PM > To: CF-Talk > Subject: SOT: SQL Query > > > hey guys, what do u think the performance difference is in MS > SQL Server 2000 > > Querying from a table of 500,000 rows or querying from a > table of 1 million rows? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Query
Yes, indexing helps a wholebunch! But how does one practice indexing correctly? Which fields should be indexed? Right now, all the identity fields are indexed. Was wondering if there is aything else that should be index - Original Message - From: Tony Weeg To: CF-Talk Sent: Tuesday, April 06, 2004 3:03 PM Subject: RE: SQL Query if correctly indexed, none. I have a table that is 1.57 millions rows, we index on an integer field, and I can return to a cf page, a recordset with 100+ rows in milliseconds its all about the indexing. tw -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:38 PM To: CF-Talk Subject: SOT: SQL Query hey guys, what do u think the performance difference is in MS SQL Server 2000 Querying from a table of 500,000 rows or querying from a table of 1 million rows? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Quit Working
CF 4.5 on XP Pro (IIS), test machine Came back from vacation and CF pages no longer get served. HTM pages serve correctly. Can't open administrator, naturally. I get the "The Page Cannot Be Displayed" error message. Removal and reinstallation of CF changes nothing. Any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
if correctly indexed, none. I have a table that is 1.57 millions rows, we index on an integer field, and I can return to a cf page, a recordset with 100+ rows in milliseconds its all about the indexing. tw -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:38 PM To: CF-Talk Subject: SOT: SQL Query hey guys, what do u think the performance difference is in MS SQL Server 2000 Querying from a table of 500,000 rows or querying from a table of 1 million rows? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
Depends on a lot of things... 1. how many fields make up your search criteria? 2. What is the datatype of those fields? 3. Are those fields indexed, and if so are they being used? 4. What indexes are being used by your query? 5. What kinds of indexes are being used? 6. Are those indexes optimized? 7. What is the distribution of values within that index? 8. Are you running the query with an implicit or explicit transaction? 9. How many users are concurrently trying to access those rows (row lock contention)? 10. What isolation level is your transaction using? 11. I'm sure there is more... When in doubt, just fill the table with more data and see for yourself. Paul Kenney [EMAIL PROTECTED] 916-212-4359 > -Original Message- > From: brobborb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 12:38 PM > To: CF-Talk > Subject: SOT: SQL Query > > > hey guys, what do u think the performance difference is in MS > SQL Server 2000 > > Querying from a table of 500,000 rows or querying from a > table of 1 million rows? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
Let me rephrase "If you're WHERE clause uses an index" to be "If your WHERE clause uses a single indexed field". Cheers, barneyb > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 12:53 PM > To: CF-Talk > Subject: RE: SQL Query > > If you're WHERE clause uses an index, it should be log(2) > times slower for > the actual row selection, but parsing the query, doing JOINs, > packaging the > data, etc will all be the same, so the actual time difference > will be less > than that. > > Cheers, > barneyb > > > -Original Message- > > From: brobborb [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 06, 2004 12:38 PM > > To: CF-Talk > > Subject: SOT: SQL Query > > > > hey guys, what do u think the performance difference is in MS > > SQL Server 2000 > > > > Querying from a table of 500,000 rows or querying from a > > table of 1 million rows? > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Geotrust Quick payments
Has anyone done a tag for Geotrust quick payments? http://www.geotrust.com/quickpayments/portal/index.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
If you're WHERE clause uses an index, it should be log(2) times slower for the actual row selection, but parsing the query, doing JOINs, packaging the data, etc will all be the same, so the actual time difference will be less than that. Cheers, barneyb > -Original Message- > From: brobborb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 12:38 PM > To: CF-Talk > Subject: SOT: SQL Query > > hey guys, what do u think the performance difference is in MS > SQL Server 2000 > > Querying from a table of 500,000 rows or querying from a > table of 1 million rows? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL Query
Hard to tell -- depends on the db structure. density, indexes defined and the query itself. There are discussions of performance in any good SQL-Server book. need more info Dick On Apr 6, 2004, at 12:38 PM, brobborb wrote: > hey guys, what do u think the performance difference is in MS SQL > Server 2000 > > Querying from a table of 500,000 rows or querying from a table of 1 > million rows? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Page to Server Fax
Does anyone have quick overview or insight, tag etc that would allow me to send a page to a fax printer on the network...if I did some kind of cfexecute on the server and point it to that fax...using some windows command? Thanks for any guidance! Regards, Eric J. Hoffman Managing Partner Datastream Connexion, LLC 1.888.690.2893 results. delivered. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: SQL Query
hey guys, what do u think the performance difference is in MS SQL Server 2000 Querying from a table of 500,000 rows or querying from a table of 1 million rows? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
makes sense.
thanks!
just wondering...i toil in the CRUD (CreateReadUpdateDelete)admin building
realm more than id like to admit and im always looking for ways to make what
I do more dynamic. I can only cut/paste so many things before an individual
app and its form elements need some specifics...and the more dynamic I can
make it the better...
but anyway...
thanks!
tony
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 3:17 PM
To: CF-Talk
Subject: RE: CFIF within input
Ok, sureThe code I posted was one part of my "system" that I use for
building admin pages or order forms. I originally build this to speed up
building admin pages but found that I could use it for any form.
Forgive if I over simplify this.
Let me start on defining the problem this solves. I build lots of admin
type pages and one thing that most admin pages do is to read data from a
database and allow you to edit the data. Then you also have the admin pages
that you use to add a new record to the database. Some times these add or
edit pages need to have required fields. So I all of my admin pages submit
the form data to themselves and do some processing to make sure that the
required fields are filled and if all required fields are filled it inserts
the data into the database. If the required fields are not filled in then
the page does not insert the data, and loads the form with a required
message next to the missing fields.
So what my UDF does is it looks for the value of the input, first in a form
var, then in a query var. If neither the form OR query contain a value for
the input box then it is just blank. Also, since the form submits to its
self then it will pull the value from the form and not the query after you
submit the page.
Does that help explain what this does?
Example:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
href="" var
Query:
Form:
action="">
t>" method="post">
First Name:
value="#smartvarText(variables.var)#" size="35"
maxlength="255">
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:24 PM
To: CF-Talk
Subject: RE: CFIF within input
mark, im a bit interested however, im not following what ur saying...
can ya explain a bit more..?
thanks
tonyS
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:53 PM
To: CF-Talk
Subject: RE: CFIF within input
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)
This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank. This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..
value="#smartvarText(variables.var)#" size="35"
maxlength="255" >
All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.
UDF:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name
RO
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input
but at the same time...i would...
value="#trim(side_1_comments)#" maxlength="100">
just to double check, and its more read-able :)
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:
trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">
But I get an err
Re: maxlength for textarea
>>If people keep trying to type the last character they type keeps vanishing. >Just beware the wrath of that data entry person who types without >looking and didn't realize the length limit had been hit long before >they stopped typing :) hehe...that's why my little function also shows the number of characters remaining just below the textarea ;-) 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 - Original Message - From: Kenneth Wilson To: CF-Talk Sent: Tuesday, April 06, 2004 12:22 PM Subject: RE: maxlength for textarea >If people keep trying to type the last character they type keeps vanishing. Just beware the wrath of that data entry person who types without looking and didn't realize the length limit had been hit long before they stopped typing :) Ken [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: maxlength for textarea
>If people keep trying to type the last character they type keeps vanishing. Just beware the wrath of that data entry person who types without looking and didn't realize the length limit had been hit long before they stopped typing :) Ken [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
Ok, sureThe code I posted was one part of my "system" that I use for
building admin pages or order forms. I originally build this to speed up
building admin pages but found that I could use it for any form.
Forgive if I over simplify this.
Let me start on defining the problem this solves. I build lots of admin
type pages and one thing that most admin pages do is to read data from a
database and allow you to edit the data. Then you also have the admin pages
that you use to add a new record to the database. Some times these add or
edit pages need to have required fields. So I all of my admin pages submit
the form data to themselves and do some processing to make sure that the
required fields are filled and if all required fields are filled it inserts
the data into the database. If the required fields are not filled in then
the page does not insert the data, and loads the form with a required
message next to the missing fields.
So what my UDF does is it looks for the value of the input, first in a form
var, then in a query var. If neither the form OR query contain a value for
the input box then it is just blank. Also, since the form submits to its
self then it will pull the value from the form and not the query after you
submit the page.
Does that help explain what this does?
Example:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
href="" var
Query:
Form:
action="">
t>" method="post">
First Name:
value="#smartvarText(variables.var)#" size="35"
maxlength="255">
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:24 PM
To: CF-Talk
Subject: RE: CFIF within input
mark, im a bit interested however, im not following what ur saying...
can ya explain a bit more..?
thanks
tonyS
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:53 PM
To: CF-Talk
Subject: RE: CFIF within input
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)
This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank. This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..
value="#smartvarText(variables.var)#" size="35"
maxlength="255" >
All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.
UDF:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name
RO
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input
but at the same time...i would...
value="#trim(side_1_comments)#" maxlength="100">
just to double check, and its more read-able :)
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:
trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">
But I get an error. It seems simple, but I must be missing something I can't
see.
Any suggestion please? Thanks.
Robert O.
HWW
_
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: maxlength for textarea
At 12:46 PM 4/6/2004, you wrote: >hey there. > >is there a parameter of a textarea that enables what maxlength does for >input type elements? When I need to do something like that, I just use a little JS function... stick it in onKeyUp on the field in question. I don't have the code handy, but essentially it says, if the length of the field is greater than (whatever value you set), set the field to the leftmost (value) characters. If people keep trying to type the last character they type keeps vanishing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: maxlength for textarea
why thank you michael.
what do you do? put an onKeyUp or something like that?
tw
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 2:58 PM
To: CF-Talk
Subject: RE: maxlength for textarea
No dice Tony...
This is a function I use to put a counter above each text area on some of
our internal apps..
function txtCounter(field,cntfield,maxlimit) {
if (field.getValue().length > maxlimit)
{
field.setValue(field.getValue().substring(0, maxlimit));
cntfield.setValue('0');
}
else
cntfield.setValue(maxlimit - field.getValue().length); }
Mike
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 2:46 PM
> To: CF-Talk
> Subject: maxlength for textarea
>
> hey there.
>
> is there a parameter of a textarea that enables what maxlength does
> for input type elements?
>
> thanks
>
> ...tony
>
> tony weeg
> senior web applications architect
> navtrak, inc.
> www.navtrak.net
> [EMAIL PROTECTED]
> 410.548.2337
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: maxlength for textarea
No dice Tony...
This is a function I use to put a counter above each text area on some of
our internal apps..
function txtCounter(field,cntfield,maxlimit) {
if (field.getValue().length > maxlimit)
{
field.setValue(field.getValue().substring(0, maxlimit));
cntfield.setValue('0');
}
else
cntfield.setValue(maxlimit - field.getValue().length);
}
Mike
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 2:46 PM
> To: CF-Talk
> Subject: maxlength for textarea
>
> hey there.
>
> is there a parameter of a textarea that enables what
> maxlength does for input type elements?
>
> thanks
>
> ...tony
>
> tony weeg
> senior web applications architect
> navtrak, inc.
> www.navtrak.net
> [EMAIL PROTECTED]
> 410.548.2337
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: maxlength for textarea
http://www.w3.org/TR/1998/REC-html40-19980424/interact/forms.html#h-17.7 You can use _javascript_ though http://_javascript_.internet.com/forms/limit-textarea.html Doug -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 2:46 PM To: CF-Talk Subject: maxlength for textarea hey there. is there a parameter of a textarea that enables what maxlength does for input type elements? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
maxlength for textarea
hey there. is there a parameter of a textarea that enables what maxlength does for input type elements? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
mark, im a bit interested however, im not following what ur saying...
can ya explain a bit more..?
thanks
tonyS
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:53 PM
To: CF-Talk
Subject: RE: CFIF within input
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)
This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank. This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..
value="#smartvarText(variables.var)#" size="35"
maxlength="255" >
All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.
UDF:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name
RO
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input
but at the same time...i would...
value="#trim(side_1_comments)#" maxlength="100">
just to double check, and its more read-able :)
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:
trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">
But I get an error. It seems simple, but I must be missing something I can't
see.
Any suggestion please? Thanks.
Robert O.
HWW
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cached Queries
> > Unfortunately, even with consistent use of CFQUERYPARAM, many > > of us will have longer query times than 3 milliseconds. > > Really ?!? > This is on a very loaded desktop dev box, to a remote Oracle, > that isn't on the best hardware either... How many users are you serving from your desktop? There are many reasons why queries may run slowly or quickly, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)
This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank. This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..
value="#smartvarText(variables.var)#" size="35"
maxlength="255" >
All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.
UDF:
function smartvarText(var1) {
if (IsDefined("form.#var1#"))
{ return #form[var1]#;
}
else if(IsDefined(queryname &'.'& var1))
{ return Evaluate(queryname &'.'& var1);
}
return "";
}
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name
RO
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input
but at the same time...i would...
value="#trim(side_1_comments)#" maxlength="100">
just to double check, and its more read-able :)
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:
trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">
But I get an error. It seems simple, but I must be missing something I can't
see.
Any suggestion please? Thanks.
Robert O.
HWW
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CF 6.0 update to 6.1 problem
Thomas, I can try to delete the datasources but wouldn't if the datasources were the problem then the select that I do for login be affected also? I can successfully login to the application without errors. It appears that the server hangs only when an insert/update/delete statement is processed. Any other ideas? Chris |-+-> | | Thomas Chiverton | | | <[EMAIL PROTECTED]| | | finger.com> | | | | | | 04/06/2004 01:25 PM | | | Please respond to | | | cf-talk | | | | |-+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript Remoting (js web service accessing stuff)
Rob can answer this much better than I, but he is N/A.
So here goes
Keep in mind the chat is multi-threaded: where the messages are
retrieved and refreshed in a background thread; while the user may be
typing in a foreground thread.
// sets up a thin array object named message
var messages = new ThinArray();
// creates a DefaultHandler that specifies the messages object as
the target of the (to be issued) ws request
dh = new DefaultHandler("messages");
// invokes the ws passing lastid and chatroom, naming the dh handler
as the recipient
robject.getMessages(
lastid,
xmlformat(document.chatform.room.value),
dh.handle
);
It is more straight forward with single-thread synchronous processing
the DefaultHandler function is defined in gateway.js
the ThinArray is defined in collections.js
HTH
Dick
On Apr 6, 2004, at 10:09 AM, Thomas Chiverton wrote:
> On Tuesday 06 Apr 2004 16:10 pm, Dick Applebaum wrote:
> > It is very much quicker!
>
> :experiments
>
> In the chatdemo, what tells it to link the messages ThinArray
> _javascript_
> object, to the query returned byrobject.getMessages (that I can see
> calls a
> web service) ?
>
> --
> Tom Chiverton
> Advanced ColdFusion Programmer
>
> Tel: +44(0)1749 834997
> email: [EMAIL PROTECTED]
> BlueFinger Limited
> Underwood Business Park
> Wookey Hole Road, WELLS. BA5 1AF
> Tel: +44 (0)1749 834900
> Fax: +44 (0)1749 834901
> web: www.bluefinger.com
> Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
> Quay, BRISTOL. BS1 6EG.
> *** This E-mail contains confidential information for the addressee
> only. If you are not the intended recipient, please notify us
> immediately. You should not use, disclose, distribute or copy this
> communication if received in error. No binding contract will result
> from
> this e-mail until such time as a written document is signed on behalf
> of
> the company. BlueFinger Limited cannot accept responsibility for the
> completeness or accuracy of this message as it has been transmitted
> over
> public networks.***
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Show status during long request
Hi, This is what I use:
function showMessage () {
if (document.layers) {
document.LoadingMessage.display = 'none';
document.Content.visibility = 'visible';
}
else if (document.all) {
document.all.LoadingMessage.style.display = 'none';
document.all.Content.style.visibility = 'visible';
}
else if (document.getElementById) {
document.getElementById('LoadingMessage').style.display = 'none';
document.getElementById('Content').style.visibility = 'visible';
}
}
Loading message Content Best regards, Michael Wilson From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:12 AM To: CF-Talk Subject: Show status during long request Hi, I have a page that takes a long time to process, I would like to update the user, or at least hide the form that appears on the page, while the pages are processing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF 6.0 update to 6.1 problem
On Tuesday 06 Apr 2004 18:08 pm, [EMAIL PROTECTED] wrote: > I have a production server that we updated from CF 6.0 Enterprise to > CF6.1. I've successfully updated the server but now my datasources are Have you deleted them, restarted CF, and then re-added them ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF 6.0 update to 6.1 problem
I have a production server that we updated from CF 6.0 Enterprise to CF6.1. I've successfully updated the server but now my datasources are having problems with hanging up. I am using JDBC connections and have fixed the JVM/Class Path setting for the path. I can verify the datasources and then verify ok. I have a page that is only updating the database and it never returns. I've applied the hot fixes that are on Macromedia's web site and still no luck. Has anyone else had similar problems? Any help would be greatly appreciated. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript Remoting (js web service accessing stuff)
On Tuesday 06 Apr 2004 16:10 pm, Dick Applebaum wrote: > It is very much quicker! :experiments In the chatdemo, what tells it to link the messages ThinArray _javascript_ object, to the query returned byrobject.getMessages (that I can see calls a web service) ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: desktop application
At the risk of being on both sides of an issue, it this case XUL vs Flash, here's an interesting quote: "The open source revolution has done nothing to change the fact that the best-designed, most-intuitive user interfaces are found in closed-source commercial software." This comes form a commentary posted at: http://daringfireball.net/2004/04/spray_on_usability While the post date is suspicious, the article raises several interesting points re freeware vs pay'n'play It's worth the read! HTH Dick On Apr 6, 2004, at 8:40 AM, Dave Watts wrote: > > > XUL is platform independent -- anywhere Mozilla runs, XUL > > > runs > > > > potent stuff isnt it? Kinda makes you rethink application > > design and chucks out the window the need to learn flash to > > make a ria. > > Except for the fact that very few people use Mozilla. I use it, and > like it, > but if I wanted to provide an application that everyone could use > without > having to download and install a browser, I'd choose Flash. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cached Queries
On Tuesday 06 Apr 2004 17:09 pm, Dave Watts wrote: > Unfortunately, even with consistent use of CFQUERYPARAM, many of us will > have longer query times than 3 milliseconds. Really ?!? This is on a very loaded desktop dev box, to a remote Oracle, that isn't on the best hardware either... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Coding Contest
WOW, this contest is on fire! :-) >We are up to three. > > Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Coding Contest
How about we switch it to Sunday at midnight, and I will do the final judging on Monday. No more extensions ;) By the way, I just got a new submission. We are up to three. Kevin _ From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:04 AM To: CF-Talk Subject: RE: ColdFusion Coding Contest Can we switch it to monday? I dont think I'll have much time till the weekend. DRE -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 8:18 PM To: CF-Talk Subject: RE: ColdFusion Coding Contest Contest is still open until Friday April 9th, at 12:00pm EST. You can solve it any way you would like. Just understand you are looking for the shortest path, not just any path. Kevin. _ From: Rizal Firmansyah [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 10:10 PM To: CF-Talk Subject: Re: ColdFusion Coding Contest Kevin, just curious... is this contest still open? And are we allowed to play this in "god's mode"? You know... solve it by looking at the whole maze, instead of thinking like the mouse inside (which can only go U,D,L,R). And then backtrack the solution to give the right direction (U,D,L,R)? Rizal At 10:33 PM 4/5/2004, you wrote: >If anyone submitted their code to the CF coding contest we had a while >back ago in January would like to submit their code to me, I am in the >process of putting all of our code together so we can at least see how >each of us did it. Feel free to send them to [EMAIL PROTECTED] > > >Kevin. > >-- >[Todays seoffusion.com/lists.cfm/link=t:4> >Threads] >[This w.houseoffusion.com/lists.cfm/link=i:4:158882> >Message] [Subscription] >[ 4>Fast 949.4> >Unsubscribe] >[User m/signin/> >Settings] > >-- > >1be3985.jpg > _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cached Queries
> I'll typical get consistant ~3ms query times using > cfqueryparam, compaired to much longer without. > > Of course, caching into a persistant scope will get > you a 0ms query time, but then you have to manage the > cache (I really must write a generic memoiser CFC) > yourself. And if you're worried about gaining 3ms/query > I think you have too many queries on the page :-) Unfortunately, even with consistent use of CFQUERYPARAM, many of us will have longer query times than 3 milliseconds. An aggressive caching strategy is often the best way to significantly increase runtime performance. In those cases, you do have to manage the cache, but that's a small price to pay for significantly better performance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: desktop application
There y'go Dave, being logical & practical! We do need to remember who lost the browser wars :) There is a tradeoff, however. Flash can do somethings (the smackdown at Fig Leaf comes to mind) that would be difficult with XUL. But for the kinds of things I normally do, Flash is a little heavy, constraining and difficult to develop. (the latter somewhat mitigated by Flex) So I, and my clients have the options: 1) Use your (non-Mozilla) browser of choice for the app and sacrifice performance and UI 2) Use Mozilla for this app and have a better overall user experience (maybe at less development cost). I can just as easily include a Mozilla Dload bug in my app as I can a Flash plugin Bug -- so distro/install of Mozilla is not a problem. I also have some local capabilities in XUL that are not available in Flash. It is possible, just possible, that the additional capabilities/performance of the XUL implementation of the app would make the browser choice incidental (to run that app). I also like the fact that I can develop and host XUL apps with CFMX, and at no additional software costs. XUL is free! I like having the option! HTH Dick On Apr 6, 2004, at 8:40 AM, Dave Watts wrote: > > > XUL is platform independent -- anywhere Mozilla runs, XUL > > > runs > > > > potent stuff isnt it? Kinda makes you rethink application > > design and chucks out the window the need to learn flash to > > make a ria. > > Except for the fact that very few people use Mozilla. I use it, and > like it, > but if I wanted to provide an application that everyone could use > without > having to download and install a browser, I'd choose Flash. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
_ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:34 AM To: CF-Talk Subject: RE: CFIF within input Tony, When I try this I get this error: Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name RO -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:32 AM To: CF-Talk Subject: RE: CFIF within input but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
You don't have a closing tag on your first CFIF John -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
> When I try this I get this error: > > Parameter 1 of function IsDefined which is now "text" must > be a syntactically valid variable name When you use IsDefined, you specify a literal string as its argument to test whether a variable by that name exists: ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: desktop application
I'm not sure how far it's gotten, but there is the XRE: XUL Runtime Environment, so you can have standalone apps without bundling (or requiring) Mozilla. http://www.mozilla.org/projects/xul/xre.html -- Howard Fore, [EMAIL PROTECTED] On Apr 6, 2004, at 11:40 AM, Dave Watts wrote: > Except for the fact that very few people use Mozilla. I use it, and > like it, > but if I wanted to provide an application that everyone could use > without > having to download and install a browser, I'd choose Flash. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
shite. :) value="#trim(side_1_comments)#" maxlength="100"> forgot "'s -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:34 AM To: CF-Talk Subject: RE: CFIF within input Tony, When I try this I get this error: Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name RO -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:32 AM To: CF-Talk Subject: RE: CFIF within input but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
Tony, When I try this I get this error: Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name RO -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:32 AM To: CF-Talk Subject: RE: CFIF within input but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: desktop application
> > XUL is platform independent -- anywhere Mozilla runs, XUL > > runs > > potent stuff isnt it? Kinda makes you rethink application > design and chucks out the window the need to learn flash to > make a ria. Except for the fact that very few people use Mozilla. I use it, and like it, but if I wanted to provide an application that everyone could use without having to download and install a browser, I'd choose Flash. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
Thank you Tony. Easy...like I said. Robert O. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
You're missing a right angel bracket after the double quotes. It should read: value="#trim(side_1_comments)#" -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: desktop application
Yes, Andre -- and thanks to your prior response to this thread for suggesting XUL On Apr 5, 2004, at 10:07 AM, Andre Turrettini wrote: > Check out xul. You can write an application in and write a delimited > file > to the harddrive each time someone enters their email. Its kind fo > an xml > _javascript_ approach to writing web apps. Similar to the approach > used by > longhorn and breeze. Its got a pretty sick grid bult in. I dont > think its > much harder than using the hta and fso in ie and when the computer is > eventually connected, just upload it to your cf or php > server. requires > mozilla but that should be ok on a mac. I don't yet understand all I know about it, but I like what I see. It gives you much more control of the DOM than DHMTL ever did, and it works predictably. Coding XUL is different, but not much more difficult than HTML --- though a better tutorial would help. Tags are XML so they are more verbose than HTML, but that should be offset by fewer, more powerful tags. One thing I really like is that the developer has complete control of the entire page real estate. We are not limited to a fixed portion of the page for a Java Applet or Flash Movie (Though we can contain these and html too, if desired). I guess that we as developers have another option for developing platform-independent RIAs and RIDs (Rich Interface Desktop Applications) Dick On Apr 6, 2004, at 8:06 AM, Andre Turrettini wrote: > potent stuff isnt it? Kinda makes you rethink application design and > chucks > out the window the need to learn flash to make a ria. > DRE > > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 4:31 AM > To: CF-Talk > Subject: Re: desktop application > > I have been googling and playing with XUL for several hours and I am > impressed with what it (you) can do. > > XUL has been out there for a while --- guess I just missed it. > > Here's a start (a little dated): > > http://www.sitepoint.com/article/xul-nets-biggest-secret-1 > > XUL is a framework for creating a UI and writing application > programs. > > These programs can be launched and run from a local hard disk or from > a > web server (or both) > > XUL is platform independent -- anywhere Mozilla runs, XUL runs > > XUL provides a consistent UI and program execution > > The above 2 points are similar to Flash advantages > > A XUL program can read and write (with user permission) to the local > file system. > > A XUL program can (by itself) consume web services. > > There are XUL extensions that can directly interface a local SQL > database (currently Postgres and MySQL) > > There are XUL extensions that can execute local programs and scripts > in > C++, Python, Ruby and Perl, with PHP coming -- these are > programs/scripts running on the local machine > > So, I guess it is possible, today, to write a desktop application to > meet the objectives of the originator of this thread: > > You can easily write an XUL app that: > > 1) Runs on the desktop > > 2) Allows people to enter their email addresses (a simple form) > > 3) Saves it (the data from each form submission) to a [local] text > or XML file > > 4) Uploads the file to web server and parsed into the database > > In the near future, you should have the option of parsing the data > with > a local php program and storing the data in a local database -- this > would allow data validation, check for duplicates, etc. > > Actually, you can do this now using a combination of _javascript_ and > XUL > extensions. But, it will be easier with PHP. > > What would really be nice if you could use CFMX as the local scripting > language and db interface... yeah, that would really be nice... > > HTH > > Dick > >> From: Burns, John D [mailto:[EMAIL PROTECTED] >> Sent: Friday, April 02, 2004 2:58 PM >> To: CF-Talk >> Subject: SOT: desktop application >> >> I have a question about what the best practice would be for > creating a >> desktop application. I do websites for some different bands, and > they >> all have an e-mail sign-up on their website. Most of them also > have >> some kind of a paper sign-up at concerts for people to sign up > for > the >> email list. I was considering building an app that would run on > a >> desktop to allow people at concerts to enter their email address > and >> write it to a text or xml file that could then be uploaded to the >> webserver and parsed into the database. >> >> My question is what would be the best method to do this? I was >> thinking >> of doing the front end in Flash but I'm not sure how to write to > a >> file >> from there. In theory, this app would need to work on a mac and > a > pc. >> Any ideas would be greatly appreciated. >> >> John Burns >> >
CFIF within input
I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: > But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMAIL/Eudora/HTML mail
Hey All, I'm sending some HTML formatted mail in CF MX 6.1 via CFMAIL and some folks with Eudora for a mail client are finding that text of the e-mail displaying overtop the graphics and a few other layout oddities. I've heard the Eudora has issues with making links in to proper links (not just plain text) unless there are "<>" wrapped around them.but nothing about this kind of layout flakiness. Anybody else bump into this? any solutions? 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: Strip ()-
ReplaceList(form.PhoneNum, "(,),-", ",,") Hatton > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 10:38 AM > To: CF-Talk > Subject: Strip ()- > > On a phone number field I want to make sure that users haven't added ()-. > I figure the easiest way is to strip it off before entering it into the > database. > How would I set that? > Thanks, > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip ()-
You could just use a regex that replaced anything that wasn't a number.
The only tricky thing with this is when you get into international. If
it's local, you could just strip out all non-numeric characters and see
if the string length is 10 and if not, show an error to the user. Then
on output from the DB, you could use the first 3 numbers in () or
however you want to display it and put dashes in appropriately. It all
depends on what kind of numbers you want to allow.
John
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:50 AM
To: CF-Talk
Subject: RE: Strip ()-
you would do some fancy regex, and im sure someone will chime in
however, ray forgot the ()'s to remove
you could kludge it like this...
replace(replace(replace(my_string,
'-','','ALL'),')','','all'),'(','','all')))
tw
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:44 AM
To: CF-Talk
Subject: Re: Strip ()-
Replace(my_string, '-','','ALL')
At 10:37 AM 4/6/2004, you wrote:
>On a phone number field I want to make sure that users haven't added
()-.
>I figure the easiest way is to strip it off before entering it into the
>database.
>How would I set that?
>Thanks,
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Strip ()-
d'oH! true :) ok...i'm only 3 minutes into Ben's 10 minute book ...and I can kind of visualize the "allow + as first char only"...but it's eluding me. btw, for anybody else who has been wrestling with learning regex (it's been on my 'list' for years), I recently found this site (was posted thru one of the blogs at fullasagoog) http://www.regular-expressions.info. Really really good site IMO. - Original Message - From: "Thomas Chiverton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 06, 2004 8:03 AM Subject: Re: Strip ()- > On Tuesday 06 Apr 2004 15:59 pm, Charlie Griefer wrote: > > phone = rereplace(phone, '[^0-9]', '', 'all'); > > Technicaly you should allow leading '+' for international numbers :-) > > -- > Tom Chiverton > Advanced ColdFusion Programmer > > Tel: +44(0)1749 834997 > email: [EMAIL PROTECTED] > BlueFinger Limited > Underwood Business Park > Wookey Hole Road, WELLS. BA5 1AF > Tel: +44 (0)1749 834900 > Fax: +44 (0)1749 834901 > web: www.bluefinger.com > Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple > Quay, BRISTOL. BS1 6EG. > *** This E-mail contains confidential information for the addressee > only. If you are not the intended recipient, please notify us > immediately. You should not use, disclose, distribute or copy this > communication if received in error. No binding contract will result from > this e-mail until such time as a written document is signed on behalf of > the company. BlueFinger Limited cannot accept responsibility for the > completeness or accuracy of this message as it has been transmitted over > public networks.*** > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript Remoting (js web service accessing stuff)
Thomas It is very much quicker! When I originally got the idea for the thin array it was for an application that had up to 5 selects related. Rather than load them dynamically, as the user chooses, I preloaded the entire set of data with the initial page load, The time to download the thin array and populate the supporting _javascript_ array was a small percentage of the time (unnoticeable) of the page load. Then, when a user made a selection, it was a simple matter to repopulate the next related select box (I used dropdowns,, btw, just to save screen real estate. I didn't do any timing, but consider this: 1) the thin array is much skinnier than the WDDX packet (13% overhead vs 200+% overhead) 2) the thin array can can populate the necessary js arrays with a single split command -- WDDX creates an array, then creates and populates each array element with a separate js statement. To me it was the difference between the approach being usable or not -- wddx was not! Try it, the thin array is just a concept that can be used anywhere you are exchanging data. I just designed it in a way that I could a single js split to create and populate the js arrays, HTH Dick On Apr 6, 2004, at 7:46 AM, Thomas Chiverton wrote: > On Thursday 01 Apr 2004 17:33 pm, Dick Applebaum wrote: > > This Thin Array contains very little non-data overhead and can be > sent > > to the client, quickly with minimal bandwidth usage (and very few > > processing cycles to serialize/de-serialize at either end) . > > Do you have any idea how much quicker than WDDX it is ? > ATM I have a data-driven tree control, that makes a call via > pengoWorks hidden > iframe method to ask the server for date to populate branches when > they are > opened. However, it can be quite slow. > > -- > Tom Chiverton > Advanced ColdFusion Programmer > > Tel: +44(0)1749 834997 > email: [EMAIL PROTECTED] > BlueFinger Limited > Underwood Business Park > Wookey Hole Road, WELLS. BA5 1AF > Tel: +44 (0)1749 834900 > Fax: +44 (0)1749 834901 > web: www.bluefinger.com > Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple > Quay, BRISTOL. BS1 6EG. > *** This E-mail contains confidential information for the addressee > only. If you are not the intended recipient, please notify us > immediately. You should not use, disclose, distribute or copy this > communication if received in error. No binding contract will result > from > this e-mail until such time as a written document is signed on behalf > of > the company. BlueFinger Limited cannot accept responsibility for the > completeness or accuracy of this message as it has been transmitted > over > public networks.*** > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: desktop application
potent stuff isnt it? Kinda makes you rethink application design and chucks out the window the need to learn flash to make a ria. DRE -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 4:31 AM To: CF-Talk Subject: Re: desktop application I have been googling and playing with XUL for several hours and I am impressed with what it (you) can do. XUL has been out there for a while --- guess I just missed it. Here's a start (a little dated): http://www.sitepoint.com/article/xul-nets-biggest-secret-1 XUL is a framework for creating a UI and writing application programs. These programs can be launched and run from a local hard disk or from a web server (or both) XUL is platform independent -- anywhere Mozilla runs, XUL runs XUL provides a consistent UI and program execution The above 2 points are similar to Flash advantages A XUL program can read and write (with user permission) to the local file system. A XUL program can (by itself) consume web services. There are XUL extensions that can directly interface a local SQL database (currently Postgres and MySQL) There are XUL extensions that can execute local programs and scripts in C++, Python, Ruby and Perl, with PHP coming -- these are programs/scripts running on the local machine So, I guess it is possible, today, to write a desktop application to meet the objectives of the originator of this thread: You can easily write an XUL app that: 1) Runs on the desktop 2) Allows people to enter their email addresses (a simple form) 3) Saves it (the data from each form submission) to a [local] text or XML file 4) Uploads the file to web server and parsed into the database In the near future, you should have the option of parsing the data with a local php program and storing the data in a local database -- this would allow data validation, check for duplicates, etc. Actually, you can do this now using a combination of _javascript_ and XUL extensions. But, it will be easier with PHP. What would really be nice if you could use CFMX as the local scripting language and db interface... yeah, that would really be nice... HTH Dick > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Friday, April 02, 2004 2:58 PM > To: CF-Talk > Subject: SOT: desktop application > > I have a question about what the best practice would be for creating a > desktop application. I do websites for some different bands, and they > all have an e-mail sign-up on their website. Most of them also have > some kind of a paper sign-up at concerts for people to sign up for the > email list. I was considering building an app that would run on a > desktop to allow people at concerts to enter their email address and > write it to a text or xml file that could then be uploaded to the > webserver and parsed into the database. > > My question is what would be the best method to do this? I was > thinking > of doing the front end in Flash but I'm not sure how to write to a > file > from there. In theory, this app would need to work on a mac and a pc. > Any ideas would be greatly appreciated. > > John Burns > > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Strip ()-
On Tuesday 06 Apr 2004 15:59 pm, Charlie Griefer wrote: > phone = rereplace(phone, '[^0-9]', '', 'all'); Technicaly you should allow leading '+' for international numbers :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Coding Contest
Can we switch it to monday? I dont think I'll have much time till the weekend. DRE -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 8:18 PM To: CF-Talk Subject: RE: ColdFusion Coding Contest Contest is still open until Friday April 9th, at 12:00pm EST. You can solve it any way you would like. Just understand you are looking for the shortest path, not just any path. Kevin. _ From: Rizal Firmansyah [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 10:10 PM To: CF-Talk Subject: Re: ColdFusion Coding Contest Kevin, just curious... is this contest still open? And are we allowed to play this in "god's mode"? You know... solve it by looking at the whole maze, instead of thinking like the mouse inside (which can only go U,D,L,R). And then backtrack the solution to give the right direction (U,D,L,R)? Rizal At 10:33 PM 4/5/2004, you wrote: >If anyone submitted their code to the CF coding contest we had a while >back ago in January would like to submit their code to me, I am in the >process of putting all of our code together so we can at least see how >each of us did it. Feel free to send them to [EMAIL PROTECTED] > > >Kevin. > >-- >[Todays seoffusion.com/lists.cfm/link=t:4> >Threads] >[This w.houseoffusion.com/lists.cfm/link=i:4:158882> >Message] [Subscription] >[ 4>Fast 949.4> >Unsubscribe] >[User m/signin/> >Settings] > >-- > >1be3985.jpg > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cached Queries
On Tuesday 06 Apr 2004 16:00 pm, Dave Watts wrote: > When you use CFQUERYPARAM, the database will generally cache query > execution plans, which can speed up future database queries using the same > plan. Hmm... :tests I'll typical get consistant ~3ms query times using cfqueryparam, compaired to much longer without. Of course, caching into a persistant scope will get you a 0ms query time, but then you have to manage the cache (I really must write a generic memoiser CFC) yourself. And if you're worried about gaining 3ms/query I think you have too many queries on the page :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cached Queries
> > No, I'm pretty sure that once you run the query with > > CACHEDWITHIN set to a timespan of zero, that'll remove > > the previous cached query from the cache. Someone will > > need to rerun the query against the database to recache > > it, though. > > That was my point (however unclear it may have been!), if I'm > reading your post correctly. When you change the cachedwithin > value to 0, the query does not refresh itself on that > specific call (because you've just changed the value and the > query is still cached). It doesn't get run and re-cached > until the *next* page request (which is usually when that > query is called again, unless you run a cfhttp request to > programatically call that page again or something similar). > > Or did I misunderstand? I'm sorry, I must have misunderstood you. Changing the CACHEDWITHIN value to zero causes the previous recordset to be overwritten with a new one fetched from the database, which is itself immediately discarded since it has a cache time of zero. The net result is that the query is no longer cached. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Strip ()-
instead of looking specifically for those 3 characters, you could just say you want a numeric value (you likely don't want any %!#%! or alphas). so: phone = rereplace(phone, '[^0-9]', '', 'all'); should work. - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 06, 2004 7:37 AM Subject: Strip ()- > On a phone number field I want to make sure that users haven't added ()-. > I figure the easiest way is to strip it off before entering it into the > database. > How would I set that? > Thanks, > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Script vs Tags (was Re: ColdFusion Coding Contest)
agreed. I'm praying that a major improvment in the next cf will be that all (or as many as possible) tags and functions are available within cfscript. -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 6:14 AM To: CF-Talk Subject: Re: Script vs Tags (was Re: ColdFusion Coding Contest) If you can do everything you need in cfscript, it's much more readable IMHO. However the functionality gap between cfscript and cf tags negates this to some degreee. In my experience switching back and forth between tags and cfscript has yielded some very awkward code. I've almost completely stopped using cfscript altogether, simply because of the time I lose trying to maintain a logical block of code in one paradigm or the other. As always your mileage may vary, products may settle during shipping, and objects may be closer than they appear. -- Howard Fore, [EMAIL PROTECTED] On Apr 5, 2004, at 8:40 PM, Philip Arnold wrote: > There is the one advantage to CFSCRIPT over tags > > Readability > > If you can read Script easier than reading tag based code, then use > Script _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip ()-
as I said :) someone will certainly come up with a fancier way...i just suck
@ regex!
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:55 AM
To: CF-Talk
Subject: Re: Strip ()-
On Tuesday 06 Apr 2004 15:49 pm, Tony Weeg wrote:
> you could kludge it like this...
> replace(replace(replace(my_string,
> '-','','ALL'),')','','all'),'(','','all')))
rereplace would look much nicer:
rereplace(my_string,'[-()]','','all')
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay,
BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee only. If
you are not the intended recipient, please notify us immediately. You should
not use, disclose, distribute or copy this communication if received in
error. No binding contract will result from this e-mail until such time as a
written document is signed on behalf of the company. BlueFinger Limited
cannot accept responsibility for the completeness or accuracy of this
message as it has been transmitted over public networks.***
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Strip ()-
On Tuesday 06 Apr 2004 15:49 pm, Tony Weeg wrote:
> you could kludge it like this...
> replace(replace(replace(my_string,
> '-','','ALL'),')','','all'),'(','','all')))
rereplace would look much nicer:
rereplace(my_string,'[-()]','','all')
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cached Queries
> makes it so your query is cached > automatically? No, it doesn't. > I can see using cfqueryparam in the second instance, but I > don't see how it helps in the first and I don't see how using > it caches my queries or improves performance. I looked at > the CFDOCS and don't see any info about it auto-caching when > using . Any insight would be appreciated. When you use CFQUERYPARAM, the database will generally cache query execution plans, which can speed up future database queries using the same plan. It doesn't have anything to do with caching recordsets in memory on your CF server, though, and in fact you can't use CFQUERYPARAM with CACHEDWITHIN/CACHEDAFTER. For this reason, you might consider caching recordsets within persistent memory variable scopes (Session/Application/Server) instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip ()-
you would do some fancy regex, and im sure someone will chime in
however, ray forgot the ()'s to remove
you could kludge it like this...
replace(replace(replace(my_string,
'-','','ALL'),')','','all'),'(','','all')))
tw
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:44 AM
To: CF-Talk
Subject: Re: Strip ()-
Replace(my_string, '-','','ALL')
At 10:37 AM 4/6/2004, you wrote:
>On a phone number field I want to make sure that users haven't added ()-.
>I figure the easiest way is to strip it off before entering it into the
>database.
>How would I set that?
>Thanks,
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cached Queries
> >No, I'm pretty sure that once you run the query with CACHEDWITHIN set to a >timespan of zero, that'll remove the previous cached query from the cache. >Someone will need to rerun the query against the database to recache it, >though. > That was my point (however unclear it may have been!), if I'm reading your post correctly. When you change the cachedwithin value to 0, the query does not refresh itself on that specific call (because you've just changed the value and the query is still cached). It doesn't get run and re-cached until the *next* page request (which is usually when that query is called again, unless you run a cfhttp request to programatically call that page again or something similar). Or did I misunderstand? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript Remoting (js web service accessing stuff)
On Thursday 01 Apr 2004 17:33 pm, Dick Applebaum wrote: > This Thin Array contains very little non-data overhead and can be sent > to the client, quickly with minimal bandwidth usage (and very few > processing cycles to serialize/de-serialize at either end) . Do you have any idea how much quicker than WDDX it is ? ATM I have a data-driven tree control, that makes a call via pengoWorks hidden iframe method to ask the server for date to populate branches when they are opened. However, it can be quite slow. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Strip ()-
Replace(my_string, '-','','ALL') At 10:37 AM 4/6/2004, you wrote: >On a phone number field I want to make sure that users haven't added ()-. >I figure the easiest way is to strip it off before entering it into the >database. >How would I set that? >Thanks, > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Next N with ...next
Well, since no one responded that they'd already made this into a UDF, and
since I advocate for the sharing of code, here's the code for a
"google-like" next-n interface, all wrapped up in a nice little UDF. You
need a few parameters for it, but otherwise, it's pretty well encapsulated.
It's designed so that you can pass in a href parameter that either does or
does not include the ? and some variables. (I'm using it along with a search
cfc that can handle a couple of different kinds of searches, so I needed to
add the searchterm and the type of search.)
It will show the page numbers of the results, showing 10 pages beyond the
current page (just like Google), along with previous and next buttons, if
needed.
I don't do a lot of cfscript, so it could maybe could be cleaned up. But, it
seems to be working:
function googleNextN(href,recordcount) {
// Set inital variables
var next = "false";
var content = "";
var maxpages = "";
// Set the number of records to display on each page.
var >
// Determine the number of pages
var NumPages=Ceiling(RecordCount / OnEachPage);
// Set the pagenum to whatever is passed in, otherwise, set it to 1
if(arrayLen(arguments) gte 4) pageNum = arguments[4];
else pageNum=1;
// This is the maximum number of pages to start with. This will give you 9
pages beyond the current page.
maxpages = 9 + pagenum;
// if the number of pages that the recordcount would return is greater than
the max allowed, limit the pages
if (NumPages GT maxpages) numpages = maxpages;
// Set the default startrow to 1 if a value was not passed.
if(arrayLen(arguments) gte 3) startRow = arguments[3];
else StartRow=1;
//Check to see if the href contains a ? already. If not, add it
if (findnocase(href, "?") is "0") href = "" & "?";
else href = "" & "&";
// Determine whether or not to show the previous or next links.
// Set the value of endrow to the maxrows + startrow - 1
EndRow=StartRow + OnEachPage - 1;
// If the end row is greater than the recordcount, determine how many
records are left.
if (EndRow GTE RecordCount) EndRow=RecordCount;
// Otherwise, set Next to true and determine the next set of records.
else {
Next="true";
if (EndRow + OnEachPage GT RecordCount) NextNum=RecordCount - EndRow;
else NextNum= OnEachPage;
NextStart=EndRow + 1;
}
// If StartRow is 1, set Previous to false.
if (StartRow IS 1) Previous="false";
else {
Previous="true";
PreviousStart=StartRow - OnEachPage;
}
// if Previous is true, display the previous link
if (Previous){
content = '<< Previous ';
}
// Loop through the links
for (i = 1; i lte numpages; i = i + 1){
if (i IS pagenum) content = content & " " & i & " ";
else {
pagenumstart = (((i - 1) * onEachPage) + 1);
content = content & '' &i& ' ';
}//end of else
}// End of loop
// If next is true, display the next link
if (Next) {
content = content & ' Next >>';
}
return content;
}// end of fuction
EXAMPLE (this works with no query, just to show you how it should work).
#googleNextN(cgi.script_name, recordcount, startrow, pagenum)#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
