Re: Anybody up to test something REALLY weird?
Check to make sure it's not a browser issue :) - Original Message - From: Jim Davis To: CF-Talk Sent: Sunday, December 07, 2003 11:05 PM Subject: Anybody up to test something REALLY weird? If I put the following line in a CFM file on a CFMX 6.1 server: img src=""> ightBoston_120x600_1.jpg width=120 height=600 alt=Visit First Night Boston 2004 border=0 It outputs NOTHING to the HTML - no empty tag, no nuthin'. But if I put in the next line (no height and width tags) it works fine: img src=""> ightBoston_120x600_1.jpg alt=Visit First Night Boston 2004 border=0 I've tested this on three servers so far - all the same. This is driving me crazy. Jim Davis [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: trying to run blue dragon.
What version? The 6.1 beta? New Atlanta have support options that may be better suited than this list (at least while it is still a beta product). Charlie Arehart rang me on the weekend all the way from Georgia to assist with an issue I was having. Greatly appreciated Charlie! Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Dan Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, 8 December 2003 5:37 PM To: CF-Talk Subject: trying to run blue dragon. Just installed the developer version. trying to run and get java error... something to do with environment space any ideas? _ __ Daniel Farmer Web Developer Consultant P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Anybody up to test something REALLY weird?
Yeah - I solved it (see the thread Anybody up to test something REALLY weird? - Solved) Turns out it was Norton Internet Security's banner blocker - any image with those height and width attributes set in the HTML is deleted from the HTML without so much as a fare-thee-well. They could have AT LEAST placed a comment: !--- Image removed by Norton --- Jeesh. Jim Davis _ From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 2:18 AM To: CF-Talk Subject: Re: Anybody up to test something REALLY weird? Check to make sure it's not a browser issue :) - Original Message - From: Jim Davis To: CF-Talk Sent: Sunday, December 07, 2003 11:05 PM Subject: Anybody up to test something REALLY weird? If I put the following line in a CFM file on a CFMX 6.1 server: img src=""> ightBoston_120x600_1.jpg width=120 height=600 alt=Visit First Night Boston 2004 border=0 It outputs NOTHING to the HTML - no empty tag, no nuthin'. But if I put in the next line (no height and width tags) it works fine: img src=""> ightBoston_120x600_1.jpg alt=Visit First Night Boston 2004 border=0 I've tested this on three servers so far - all the same. This is driving me crazy. Jim Davis _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:OT: GeoTrust Certs @ 25$ ?
No, not at all. It's $25, no catch. I've purchased numerous certificates through these guys over the past year and a half, there's nothing fishy about it, just a great deal. Jack Hey Stace! I think they offer them so cheap cuz they want to hook you...the next year you have to renew it at full price... --Josh Stacy Young wrote: These guys have GEO Trust certs at $25. Has anyone every used them? https://members.ev1.net/rsMembers/english/ssl/sslorder.asp Just wondering how they can offer it so cheap when GEO themselves sell at $159...perhaps they just purchase a large block? No clue... Thanks Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Anybody up to test something REALLY weird?
I see the image. Stace _ From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:19 AM To: CF-Talk Subject: RE: Anybody up to test something REALLY weird? I've put a file up with only that line and empty application.cfm and onrequestend.cfm files here: http://www.firstnight.org/Test/ Do you see the image?I see nothing (in the page or in the source) from CFMX 6.1 on two servers using IE 6 Jim Davis _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:13 AM To: CF-Talk Subject: RE: Anybody up to test something REALLY weird? Works here too (IE 5.5). Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Andrew Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: 08/12/2003 16:08Subject:RE: Anybody up to test something REALLY weird? Please respond to cf-talk | _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Anybody up to test something REALLY weird?
No problems here Jim. Mike -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:05 AM To: CF-Talk Subject: Anybody up to test something REALLY weird? If I put the following line in a CFM file on a CFMX 6.1 server: img src=""> ightBoston_120x600_1.jpg width=120 height=600 alt=Visit First Night Boston 2004 border=0 It outputs NOTHING to the HTML - no empty tag, no nuthin'. But if I put in the next line (no height and width tags) it works fine: img src=""> ightBoston_120x600_1.jpg alt=Visit First Night Boston 2004 border=0 I've tested this on three servers so far - all the same. This is driving me crazy. Jim Davis _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Anybody up to test something REALLY weird?
Its been solved http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =29158forumid=4 -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 11:34 To: CF-Talk Subject: RE: Anybody up to test something REALLY weird? No problems here Jim. Mike -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:05 AM To: CF-Talk Subject: Anybody up to test something REALLY weird? If I put the following line in a CFM file on a CFMX 6.1 server: img src=""> rstN ightBoston_120x600_1.jpg width=120 height=600 alt=Visit First Night Boston 2004 border=0 It outputs NOTHING to the HTML - no empty tag, no nuthin'. But if I put in the next line (no height and width tags) it works fine: img src=""> rstN ightBoston_120x600_1.jpg alt=Visit First Night Boston 2004 border=0 I've tested this on three servers so far - all the same. This is driving me crazy. Jim Davis _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Anybody up to test something REALLY weird?
On Monday 08 Dec 2003 11:51 am, [EMAIL PROTECTED] wrote: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =29158forumid=4 I had a similar issue at the weekend at SWMBO's parent's. I've now gone through the 'default' and 'site specific' settings with a closely-spaced tooth comb and ripped out all the junk rules. -- 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: Anybody up to test something REALLY weird?
Tom wrote: I had a similar issue at the weekend at SWMBO's parent's. Sorry Tom, it's monday morn... SWMBO???Anybody got a glossary for all these list acronymns :-) -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: copy record in mysql
Hello I google'd this but couldn¹t get an answer. I have a table with lots of columns of different types. I need to copy a row to a new row... How would you do this? Preferable in mysql without coldfusion... But if that¹s not possible, a coldfusion solution will do fine. Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: copy record in mysql
Um, you mean: Insert into mytable select * from mytable where someclause that gets your old column? - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:53 AM Subject: OT: copy record in mysql Hello I google'd this but couldn¹t get an answer. I have a table with lots of columns of different types. I need to copy a row to a new row... How would you do this? Preferable in mysql without coldfusion... But if that¹s not possible, a coldfusion solution will do fine. Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: copy record in mysql
Mysql syntax says you cant insert into the table you select from, unless I read it wrong. On 8/12/03 2:00 pm, Deanna Schneider [EMAIL PROTECTED] wrote: Um, you mean: Insert into mytable select * from mytable where someclause that gets your old column? - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:53 AM Subject: OT: copy record in mysql Hello I google'd this but couldn¹t get an answer. I have a table with lots of columns of different types. I need to copy a row to a new row... How would you do this? Preferable in mysql without coldfusion... But if that¹s not possible, a coldfusion solution will do fine. Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: trying to run blue dragon.
It would help if you share the exact error message and how you got it. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 On Dec 8, 2003, at 1:37 AM, Dan Farmer wrote: Just installed the developer version. trying to run and get java error... something to do with environment space any ideas? _ __ Daniel Farmer Web Developer Consultant P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fusebox - whats the big deal anyway?
Of *course* there are other ways to solve any problem. Let's look at the Java world for a second and look at web-oriented application frameworks: Struts Tapestry Webworx Tourque/Turbine/Velocity etc Plenty to choose from, each with specific advantages and disadvantages. You pick the right framework for you project, which may be one of these, another lesser known framework, or your own. For example, Struts is extremely popular in the Java world (well, extremely *used*) but it's strength IMHO is for form-based applications. I find Fusebox extremely useful because I work on a lot of different projects. I can use one framework (well, let's say two since I now support FB3 and FB4 apps for my client base) and jump back and forth between development and maintenance without a lot of thought since the apps use the same framework. And I find that my clients can frequently find other FB programmers for ongoing maintenance, etc since there are a number of CF folks who've worked with FB. If you're in a more vertical scenario -- your group writes one app (or suite) for one company (your own), then rolling your own framework starts to make a lot of sense. You can optimize for *your* problems, not a general set of problems. I've done a a few VoiceXML apps, and FB3 had some quirks with that which took a little work to fix -- probably could have written a better framework for those apps, but I didn't because I wanted to support as small a number of different frameworks as possible as the client count rises :) My choice -- worked for me. I will say that if you've never designed a framework, and never worked seriously with one, you're far better off to start with an established one or two and learn them so you've got a foundation to start with. Writing frameworks is very time-intensive and complex -- and good programmers do not necessarily make good framework developers (and v-v). You could write *anything* yourself -- a CFML parser, a web server, a database engine, etc. But you pick and choose the components off-the-shelf that speed development -- FB4 (and MachII for that matter) are both functional off-the-shelf and solve a lot of problems without any further work on the framework. I'd rather spend my time solving my clients problems and less time writing frameworks -- that works for me. I've used a lot of frameworks, in multiple languages (eg Mason in Perl, Struts in Java, FB in CF), and I've found that web application frameworks converge onto a small subset of possible solutions to the general problem of building a web site -- there's more similarities than differences between them. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Dan Farmer To: CF-Talk Sent: Saturday, December 06, 2003 11:41 PM Subject: RE: Fusebox - whats the big deal anyway? Thanks to those who responded about Fusebox. I think after listening to everything people have said I do know more about it and can appreciate it more. However, I still believe that there are other ways of doing things...and that we should never accept one way as the best way or The only way. Someone mentioned something about creativity being seperate from designing an app. I would STRONGLY disagree with this person. Programming cannot be defined as strictly a science or an artform, it lays somewhere in between we shouldn't be afraid ( as cliche as this is ) to think outside the Fusebox. =) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: copy record in mysql
Oh. Never mind. (I don't use MySql and figured maybe you just were a sql newbie. :) ) -Deanna - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 08, 2003 8:05 AM Subject: Re: copy record in mysql Mysql syntax says you cant insert into the table you select from, unless I read it wrong. On 8/12/03 2:00 pm, Deanna Schneider [EMAIL PROTECTED] wrote: Um, you mean: Insert into mytable select * from mytable where someclause that gets your old column? - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:53 AM Subject: OT: copy record in mysql Hello I google'd this but couldn¹t get an answer. I have a table with lots of columns of different types. I need to copy a row to a new row... How would you do this? Preferable in mysql without coldfusion... But if that¹s not possible, a coldfusion solution will do fine. Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: copy record in mysql
No probs, thanks anyways... Any other takers? On 8/12/03 2:57 pm, Deanna Schneider [EMAIL PROTECTED] wrote: Oh. Never mind. (I don't use MySql and figured maybe you just were a sql newbie. :) ) -Deanna [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: copy record in mysql
Mysql syntax says you cant insert into the table you select from, unless I read it wrong. INSERT INTO SELECT FROM Should work, but we don't use mySQL, so I can't guarantee it Can you create a View of the table, and then insert from that? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
network monitor
Hello Everybody, Was hoping someone could help me out of my problem. I have been asked to call a webpage which displays the company network monitor (alerts you if a server has crashed, blah, blah). Now this page is served by a server sitting somewhere in the organisation. I have been asked to call this page and apply some logic using coldfusion to get the list of servers that have crashed and display the results in a coldfusion page. The page should have the columns Name and Status. I don't know how to go about doing this. I can call the page with cfhttp if I have all the permissions, but what do I do with the information. How do I then search with the returned results for a service that is down? There isn't any webservice interface. Has anyone done this sort of thing? Please if you have can you help. Best Regards CF Coder __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Anybody up to test something REALLY weird?
On Monday 08 Dec 2003 12:03 pm, [EMAIL PROTECTED] wrote: Sorry Tom, it's monday morn... SWMBO??? Gah, my pardon :-) She Who Must Be Obeyed, otherwise known as SO. Anybody got a glossary for all these list acronymns :-) Google for 'Jargon File'. I believe it's home is http://www.catb.org/~esr/jargon/ -- 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: Anybody up to test something REALLY weird?
Tom wrote: She Who Must Be Obeyed, otherwise known as SO. hahahahahahaa... gotcha :-) Cheers for the link as well -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: network monitor
On Monday 08 Dec 2003 15:27 pm, cf coder wrote: The page should have the columns Name and Status. I don't know how to go about doing this. I can call I assume this is in a HTML table ? Can you get the relavent td elements tagged (then you can just search in the return page for the right td and display anything betwen the tags) ? Otherwise you'll have to figure out a way of finding the right bit youself (find the 3rd img, count in three tr tags, then print every 4th td tag). -- 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: network monitor
Can you provide any portion of your CFHTTP.FileContents without giving away any private information? Then it would easier to see what you are dealing with. -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:28 AM To: CF-Talk Subject: network monitor Hello Everybody, Was hoping someone could help me out of my problem. I have been asked to call a webpage which displays the company network monitor (alerts you if a server has crashed, blah, blah). Now this page is served by a server sitting somewhere in the organisation. I have been asked to call this page and apply some logic using coldfusion to get the list of servers that have crashed and display the results in a coldfusion page. The page should have the columns Name and Status. I don't know how to go about doing this. I can call the page with cfhttp if I have all the permissions, but what do I do with the information. How do I then search with the returned results for a service that is down? There isn't any webservice interface. Has anyone done this sort of thing? Please if you have can you help. Best Regards CF Coder __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfqueryparam, Oracle and doubling single quotes (').
I'm inserting varchar data into a Oracle 8i table using cfqueryparam.For
some reason, if the data contains a single quote ('), the quote is being
doubled ('') when it is stored in the database.Is this correct behavior?
Can I eliminate this?Would PreserveSingleQuotes() be a valid option here?
I thought the cfqueryParam tag was supposed to take care of this?Is this
just an Oracle thing?I've got another application where I put large
amounts of prose text with punctuation into a MSSQL database, I don't recall
using PreserveSingleQuotes() with cfqueryParam there.
Thank You
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: cfqueryparam, Oracle and doubling single quotes (').
you dont mention which version of CF you are using, but there is a problem
with MX whereby if you use functions to deliver the content then the quotes
dont get escaped correctly.
i.e.
CFSET sFoo = Homer's shirt is white
CFQUERYPARAM VALUE=#Trim(sFoo)#...
will produce double quotes rather than single but
CFQUERYPARAM VALUE=#sFoo#...
or
CFSET sFoo = Trim(sFoo)
CFQUERYPARAM VALUE=#sFoo#...
will be OK,I beleive (got this from another list) that
CFQUERYPARAM VALUE=#PreserveSingleQuotes(Trim(sFoo))#...
will work but i havent tried this.
HTH
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, December 8, 2003 15:42
To: CF-Talk
Subject: cfqueryparam, Oracle and doubling single quotes (').
I'm inserting varchar data into a Oracle 8i table using cfqueryparam.For
some reason, if the data contains a single quote ('), the quote is being
doubled ('') when it is stored in the database.Is this correct behavior?
Can I eliminate this?Would PreserveSingleQuotes() be a valid option here?
I thought the cfqueryParam tag was supposed to take care of this?Is this
just an Oracle thing?I've got another application where I put large
amounts of prose text with punctuation into a MSSQL database, I don't recall
using PreserveSingleQuotes() with cfqueryParam there.
Thank You
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: cfqueryparam, Oracle and doubling single quotes (').
Sorry, this is on a CFMX 6.0 no updates machine.
Yes, cfqueryparam value=#(preserverSingleQuotes(form.note))# ... seems
to be working? At least for the moment.Is there a likely chance that this
could cause me a problem, if/when the incorrect behavior in CFMX is
corrected?
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 7:48 AM
To: CF-Talk
Subject: RE: cfqueryparam, Oracle and doubling single quotes (').
you dont mention which version of CF you are using, but there is a problem
with MX whereby if you use functions to deliver the content then the quotes
dont get escaped correctly.
i.e.
CFSET sFoo = Homer's shirt is white
CFQUERYPARAM VALUE=#Trim(sFoo)#...
will produce double quotes rather than single but
CFQUERYPARAM VALUE=#sFoo#...
or
CFSET sFoo = Trim(sFoo)
CFQUERYPARAM VALUE=#sFoo#...
will be OK,I beleive (got this from another list) that
CFQUERYPARAM VALUE=#PreserveSingleQuotes(Trim(sFoo))#...
will work but i havent tried this.
HTH
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, December 8, 2003 15:42
To: CF-Talk
Subject: cfqueryparam, Oracle and doubling single quotes (').
I'm inserting varchar data into a Oracle 8i table using cfqueryparam.For
some reason, if the data contains a single quote ('), the quote is being
doubled ('') when it is stored in the database.Is this correct behavior?
Can I eliminate this?Would PreserveSingleQuotes() be a valid option here?
I thought the cfqueryParam tag was supposed to take care of this?Is this
just an Oracle thing?I've got another application where I put large
amounts of prose text with punctuation into a MSSQL database, I don't recall
using PreserveSingleQuotes() with cfqueryParam there.
Thank You
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Recursive Directory Display
Would anyone know where I can find a recursive directory tag?I just need to display all the file, folders, sub-folders their files. Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue/Wed) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfqueryparam, Oracle and doubling single quotes (').
I dont know im afraid, when we finally tracked down the problem we moved the
string functions outside the query so they are performed first, then the
string is passed into the queryparam.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, December 8, 2003 15:54
To: CF-Talk
Subject: RE: cfqueryparam, Oracle and doubling single quotes (').
Sorry, this is on a CFMX 6.0 no updates machine.
Yes, cfqueryparam value=#(preserverSingleQuotes(form.note))# ... seems
to be working? At least for the moment.Is there a likely chance that this
could cause me a problem, if/when the incorrect behavior in CFMX is
corrected?
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 7:48 AM
To: CF-Talk
Subject: RE: cfqueryparam, Oracle and doubling single quotes (').
you dont mention which version of CF you are using, but there is a problem
with MX whereby if you use functions to deliver the content then the quotes
dont get escaped correctly.
i.e.
CFSET sFoo = Homer's shirt is white
CFQUERYPARAM VALUE=#Trim(sFoo)#...
will produce double quotes rather than single but
CFQUERYPARAM VALUE=#sFoo#...
or
CFSET sFoo = Trim(sFoo)
CFQUERYPARAM VALUE=#sFoo#...
will be OK,I beleive (got this from another list) that
CFQUERYPARAM VALUE=#PreserveSingleQuotes(Trim(sFoo))#...
will work but i havent tried this.
HTH
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, December 8, 2003 15:42
To: CF-Talk
Subject: cfqueryparam, Oracle and doubling single quotes (').
I'm inserting varchar data into a Oracle 8i table using cfqueryparam.For
some reason, if the data contains a single quote ('), the quote is being
doubled ('') when it is stored in the database.Is this correct behavior?
Can I eliminate this?Would PreserveSingleQuotes() be a valid option here?
I thought the cfqueryParam tag was supposed to take care of this?Is this
just an Oracle thing?I've got another application where I put large
amounts of prose text with punctuation into a MSSQL database, I don't recall
using PreserveSingleQuotes() with cfqueryParam there.
Thank You
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Fusebox - whats the big deal anyway?
If your not going to answer the question, feel free not to respond. I too am interested in the why. CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:network monitor
This is the html code taken from the actual cgi file and not the output from the cffile.filecontents. Home Page Code: HTMLHEADMETA HTTP-EQUIV=REFRESH CONTENT=60TITLEMonitor/TITLE/HEAD BODY bgcolor=#FF background=""> H1MONITOR/H1 FONT COLOR=#00TABLE BORDER=2 WIDTH=98% CELLPADDING=3 CELLSPACING=0 BGCOLOR=#C0C0C0 TRTH COLSPAN=2 ALIGN=LEFT BGCOLOR=#0080C0 table width=100% border=0trtdMONITOR /td/tr/table /TH/TR TRTD WIDTH=98% VALIGN=TOPTABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=2 BGCOLOR=#C0C0C0 TRTD WIDTH=40% /TDTD WIDTH=20% /TDTD WIDTH=20% /TDTD WIDTH=20% /TD/TRTRTH ALIGN=LEFTServices/THTH ALIGN=RIGHTServices Up/THTH ALIGN=RIGHTServices Down/THTH ALIGN=RIGHTServicesbrDown/TH/TR TRTDa href="" - DN/a/TD TD bgcolor=#77FF77 ALIGN=RIGHT4/TDTD ALIGN=RIGHT0/TDTD ALIGN=RIGHT0/TD/TR TRTDa href="" Switches - SF/a/TD TD bgcolor=#77FF77 ALIGN=RIGHT116/TDTD bgcolor=#FF ALIGN=RIGHT19/TDTD ALIGN=RIGHT0/TD/TR bgsound src="" valign=top align=left nowrap /td/tr/tablehr/BODY /HTML When you click on any of the links on the home page (say for eg you clicked on Network Switches - SF) you get to this page: HTMLHEADMETA HTTP-EQUIV=REFRESH CONTENT=60TITLEMonitor/TITLE/HEAD BODY bgcolor=#FF background=""> FONT COLOR=#00TABLE BORDER=2 WIDTH=98% CELLPADDING=3 CELLSPACING=0 BGCOLOR=#C0C0C0 TRTH COLSPAN=2 ALIGN=LEFT BGCOLOR=#0080C0 table width=100% border=0trtd Network Switches - SF /tdtd align=righta href="" target=_NEWHelp/a/td/tr/table /TH/TR TRTD WIDTH=98% VALIGN=TOPTABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=2 BGCOLOR=#C0C0C0 TRTH ALIGN=LEFT Name /THTH ALIGN=LEFT Type /THTH ALIGN=LEFT Status /THTH ALIGN=LEFT Services /TH/tr TRTD bgcolor=#77FF77server1.companyname.com/TDTDServer/TDTD bgcolor=#77FF77Active/TDTD/TD/TR TRTD bgcolor=#FFserver2.companyname.com/TDTDServer/TDTD bgcolor=#FFTimed Out/TDTD/TD/TR TRTD bgcolor=#77FF77server3.companyname.com/TDTDServer/TDTD bgcolor=#77FF77Active/TDTD/TD/TR bgsound src=""> /BODY /HTML Hope this helps Can you provide any portion of your CFHTTP.FileContents without giving away any private information? Then it would easier to see what you are dealing with. -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:28 AM To: CF-Talk Subject: network monitor Hello Everybody, Was hoping someone could help me out of my problem. I have been asked to call a webpage which displays the company network monitor (alerts you if a server has crashed, blah, blah). Now this page is served by a server sitting somewhere in the organisation. I have been asked to call this page and apply some logic using coldfusion to get the list of servers that have crashed and display the results in a coldfusion page. The page should have the columns Name and Status. I don't know how to go about doing this. I can call the page with cfhttp if I have all the permissions, but what do I do with the information. How do I then search with the returned results for a service that is down? There isn't any webservice interface. Has anyone done this sort of thing? Please if you have can you help. Best Regards CF Coder __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF pda types of devices
Hi folks, I've never worked on CF app for PDA types of devices or the like such as Windows CE for mobile devices, like HP Journada, Ipaq, and Casio and all the Palm OS devices, all pocket PCs PROVIDED that these devices has net connection. One thing naturally is certain, one does not use FIXed WIDTH for the HTML.Any thoughts, experience sharing would be very much appreciated. Don Li [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive Directory Display
Try this..
index.cfm
---
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
head
titleUntitled/title
/head
body
cfset basedir = d:\sites\bearbox\documentation\
cf_dir basedir = #basedir#
cfdump var=#request.filelist#
/body
/html
---
dir.cfm
---
cfparam name=request.filelist
default=#QueryNew('Filename,FileDate,Size')#
cfdirectory action="" directory=#attributes.basedir# name=list
cfloop query=list
cfif type is File
cfscript
QueryAddRow(request.filelist);
QuerySetCell(request.filelist,FileName,#attributes.basedir##name#);
QuerySetCell(request.filelist,FileDate,#DateLastModified#);
QuerySetCell(request.filelist,Size,#Size#);
/cfscript
cfelse
cfif NOT (name is . or name is ..)
cf_dir basedir = #attributes.basedir##name#\
/cfif
/cfif
/cfloop
---
That works well, but if you want more speed I have a java tag I wrote,
just ask if you need it.
Craig.
-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 15:58
To: CF-Talk
Subject: Recursive Directory Display
Would anyone know where I can find a recursive directory tag?I
just need to display all the file, folders, sub-folders their files.
Thanks,
Scott
Scott Wilhelm
Computer Technician/Web Developer
http://www.sllboces.org http://www.sllboces.org/
[EMAIL PROTECTED]
Canton (Mon/Tue/Wed)
St. Lawrence-Lewis BOCES
PO Box 231, 139 State Street Road
Canton, NY 13617
P.315-386-4504 x 164
F.315-386-3395
Heuvelton (Thu/Fri)
Heuvelton Central School
PO Box 375, 87 Washington Street
Heuvelton, NY 13654
P.315-344-2414 x 3651
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CF pda types of devices
On Monday 08 Dec 2003 15:07 pm, Chunshen (Don) Li wrote: for the HTML.Any thoughts, experience sharing would be very much appreciated. Assuming you are going to use stright HTML, rather than via a WAP proxy or something, then you've already covered the main problem - lack of width and screen real-estate, which can lead to long vertical scroll bars. You can test it by just using a small web browser window on your PC :-) Some devices howver have a 'reformat page' option, which basicaly drops all the table tags, which makes controling layout fun... -- 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: CF pda types of devices
Interesting, do those devices use HTML or WML ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive Directory Display
Thanks a ton!
This might be asking alot, but would by chance have it in an outline format?
Thanks again,
Scott
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 11:01 AM
To: CF-Talk
Subject: RE: Recursive Directory Display
Try this..
index.cfm
---
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
head
titleUntitled/title
/head
body
cfset basedir = d:\sites\bearbox\documentation\
cf_dir basedir = #basedir#
cfdump var=#request.filelist#
/body
/html
---
dir.cfm
---
cfparam name=request.filelist
default=#QueryNew('Filename,FileDate,Size')#
cfdirectory action="" directory=#attributes.basedir# name=list
cfloop query=list
cfif type is File
cfscript
QueryAddRow(request.filelist);
QuerySetCell(request.filelist,FileName,#attributes.basedir##name#);
QuerySetCell(request.filelist,FileDate,#DateLastModified#);
QuerySetCell(request.filelist,Size,#Size#);
/cfscript
cfelse
cfif NOT (name is . or name is ..)
cf_dir basedir = #attributes.basedir##name#\
/cfif
/cfif
/cfloop
---
That works well, but if you want more speed I have a java tag I wrote,
just ask if you need it.
Craig.
-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 15:58
To: CF-Talk
Subject: Recursive Directory Display
Would anyone know where I can find a recursive directory tag?I
just need to display all the file, folders, sub-folders their files.
Thanks,
Scott
Scott Wilhelm
Computer Technician/Web Developer
http://www.sllboces.org http://www.sllboces.org/
[EMAIL PROTECTED]
Canton (Mon/Tue/Wed)
St. Lawrence-Lewis BOCES
PO Box 231, 139 State Street Road
Canton, NY 13617
P.315-386-4504 x 164
F.315-386-3395
Heuvelton (Thu/Fri)
Heuvelton Central School
PO Box 375, 87 Washington Street
Heuvelton, NY 13654
P.315-344-2414 x 3651
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CF pda types of devices
On Monday 08 Dec 2003 16:17 pm, Dan Farmer wrote: Interesting, do those devices use HTML or WML ? My P900 does both - it runs Opera for (X)HTML for instance :-) -- 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: Recursive Directory Display
I've got one that might do what you need.It's rather old, but it does work: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/CustomTags/D P_FileFind/Index.cfm Jim Davis _ From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:58 AM To: CF-Talk Subject: Recursive Directory Display Would anyone know where I can find a recursive directory tag?I just need to display all the file, folders, sub-folders their files. Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue/Wed) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive Directory Display
Not sure what you mean by outline format?
You want me to run through how it works or what? ;-)
-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 16:23
To: CF-Talk
Subject: RE: Recursive Directory Display
Thanks a ton!
This might be asking alot, but would by chance have it in an
outline format?
Thanks again,
Scott
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 11:01 AM
To: CF-Talk
Subject: RE: Recursive Directory Display
Try this..
index.cfm
---
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
head
titleUntitled/title
/head
body
cfset basedir = d:\sites\bearbox\documentation\
cf_dir basedir = #basedir#
cfdump var=#request.filelist#
/body
/html
---
dir.cfm
---
cfparam name=request.filelist
default=#QueryNew('Filename,FileDate,Size')#
cfdirectory action="" directory=#attributes.basedir#
name=list
cfloop query=list
cfif type is File
cfscript
QueryAddRow(request.filelist);
QuerySetCell(request.filelist,FileName,#attributes.basedir##name#);
QuerySetCell(request.filelist,FileDate,#DateLastModified#);
QuerySetCell(request.filelist,Size,#Size#);
/cfscript
cfelse
cfif NOT (name is . or name is ..)
cf_dir basedir = #attributes.basedir##name#\
/cfif
/cfif
/cfloop
---
That works well, but if you want more speed I have a java tag I
wrote,
just ask if you need it.
Craig.
-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 15:58
To: CF-Talk
Subject: Recursive Directory Display
Would anyone know where I can find a recursive directory tag?I
just need to display all the file, folders, sub-folders their
files.
Thanks,
Scott
Scott Wilhelm
Computer Technician/Web Developer
http://www.sllboces.org http://www.sllboces.org/
[EMAIL PROTECTED]
Canton (Mon/Tue/Wed)
St. Lawrence-Lewis BOCES
PO Box 231, 139 State Street Road
Canton, NY 13617
P.315-386-4504 x 164
F.315-386-3395
Heuvelton (Thu/Fri)
Heuvelton Central School
PO Box 375, 87 Washington Street
Heuvelton, NY 13654
P.315-344-2414 x 3651
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CF pda types of devices
so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF pda types of devices Date: Mon, 8 Dec 2003 16:23:43 + MIME-Version: 1.0 Received: from houseoffusion.com ([64.118.64.245]) by mc7-f6.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 8 Dec 2003 08:32:53 -0800 Received: from LOCALHOST by LOCALHOSTwith ESMTP id 1E50022862FD7D47AF87ADCF804B9FE9Mon, 8 Dec 2003 11:25:43 -0500 X-Message-Info: JGTYoYF78jH0WUrlLkM9Hj8F8ul61g5l Message-ID: [EMAIL PROTECTED] Precedence: bulk References: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 08 Dec 2003 16:32:57.0379 (UTC) FILETIME=[EFEA9730:01C3BDA8] On Monday 08 Dec 2003 16:17 pm, Dan Farmer wrote: Interesting, do those devices use HTML or WML ? My P900 does both - it runs Opera for (X)HTML for instance :-) -- 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]
asp equiv to CFFTP
what is the asp equiv to CFFTP ? side note: Annoying ISPs that disable good CF functions.. aargghh _ __ Daniel Farmer Web Developer P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF pda types of devices
Good to know, thanks. On Monday 08 Dec 2003 15:07 pm, Chunshen (Don) Li wrote: for the HTML.Any thoughts, experience sharing would be very much appreciated. Assuming you are going to use stright HTML, rather than via a WAP proxy or something, then you've already covered the main problem - lack of width and screen real-estate, which can lead to long vertical scroll bars. You can test it by just using a small web browser window on your PC :-) Some devices howver have a 'reformat page' option, which basicaly drops all the table tags, which makes controling layout fun... -- 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: Generating Primary Key in Oracle (part 2)
Having a sequence facilitates the currval and nextval functions. If you are new to Oracle sequences I would read up on these two functions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF pda types of devices
Personally in general I would prefer to use ONE for the other option would require much more time/efforts and cost for essentially the same thing.And I would think that browser for PDA type of device would simplify data display and navigation whenever possible as Thomas mentioned. Don so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF pda types of devices Date: Mon, 8 Dec 2003 16:23:43 + MIME-Version: 1.0 Received: from houseoffusion.com ([64.118.64.245]) by mc7-f6.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 8 Dec 2003 08:32:53 -0800 Received: from LOCALHOST by LOCALHOSTwith ESMTP id 1E50022862FD7D47AF87ADCF804B9FE9Mon, 8 Dec 2003 11:25:43 -0500 X-Message-Info: JGTYoYF78jH0WUrlLkM9Hj8F8ul61g5l Message-ID: [EMAIL PROTECTED] Precedence: bulk References: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 08 Dec 2003 16:32:57.0379 (UTC) FILETIME=[EFEA9730:01C3BDA8] On Monday 08 Dec 2003 16:17 pm, Dan Farmer wrote: Interesting, do those devices use HTML or WML ? My P900 does both - it runs Opera for (X)HTML for instance :-) -- 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]
I could use a JS expert right now.
Here is a code snippet from a page the is similar to the bottom of a google.com results page. I'm trying to use dynamic forms instead of long URLs to go from page to page. Assume my CF code is correct. My use of _javascript_ is bombing out. What am I doing wrong? See below. Result Page: 1 2 3 4 5 6 7 8 9 10 Next cfloop index=ThisPage from=1 to=#NumPages# form name=PageSwitch#ThisPage# action=""> method=Post input type=hidden name=Level value=#Attributes.Level# input type=hidden name=StartRow value=#Attributes.PageNumberStart# input type=hidden name=PageNumber value=#ThisPage# input type=hidden name=Action td class=generictexta > href=""> #ThisPage#';return true true#ThisPage#/anbsp;/td /form /cfloop The JS errors read: - Error: document.PageSwitch2.Action has no properties and - Error: document.PageSwitch2.submit is not a function. Source File: _javascript_:document.PageSwitch2.submit(); Thanks Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I could use a JS expert right now.
Not tested... but possibly because you are calling an onclick event and
also using _javascript_ in the href tag?Confusing the useragent?
Could spin it off into a function of its own something like...
function doAction(formNo) {
var theForm = eval(document.PageSwitchformNo);
//Debug output... all should return an object (although the
submit may choke ;-)
//alert(theForm);
//alert(theForm.Action);
//alert(theForm.submit);
theForm.Action.value = 'dispalyProducts';
theForm.submit();
}
Then call it in your code like.
a href="" doAction('1');#ThisPage#/a
You could also do testing... ie the error messages you are recieveing
are saying that they are not objects... validate your HTML and test by
calling alert(document.PageSwitch1) or
alert(document.PageSwitch2.Action)..., you should get an [object]
back.
Sorry bit rusty on the _javascript_ ... the code above may need jiggled a
little bit to work
Only thing I can think of at the moment
--
-dc[ cf5, ora8.1.7, iis5 ]
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 17:20
To: CF-Talk
Subject: I could use a JS expert right now.
Here is a code snippet from a page the is similar to the bottom of a
google.com results page. I'm trying to use dynamic forms instead of long
URLs to go from page to page. Assume my CF code is correct. My use of
_javascript_ is bombing out. What am I doing wrong? See below.
Result Page:
1
2
3
4
5
6
7
8
9
10
Next
cfloop index=ThisPage from=1 to=#NumPages#
form name=PageSwitch#ThisPage#
action="">
method=Post
input type=hidden name=Level value=#Attributes.Level# input
type=hidden name=StartRow value=#Attributes.PageNumberStart#
input type=hidden name=PageNumber value=#ThisPage# input
type=hidden name=Action td class=generictexta
>
href="">
#ThisPage#';return true
true#ThisPage#/anbsp;/td
/form
/cfloop
The JS errors read:
- Error: document.PageSwitch2.Action has no properties
and - Error: document.PageSwitch2.submit is not a function. Source File:
_javascript_:document.PageSwitch2.submit();
Thanks Che
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: I could use a JS expert right now.
- Error: document.PageSwitch2.Action has no properties action is lower case. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I could use a JS expert right now.
I took your code, and removed all cf variable references except thispage, by removing, I mean I put my own values in for them. The page seems to run fine, I do not get any js errors. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:20 PM To: CF-Talk Subject: I could use a JS expert right now. Here is a code snippet from a page the is similar to the bottom of a google.com results page. I'm trying to use dynamic forms instead of long URLs to go from page to page. Assume my CF code is correct. My use of _javascript_ is bombing out. What am I doing wrong? See below. Result Page: 1 2 3 4 5 6 7 8 9 10 Next cfloop index=ThisPage from=1 to=#NumPages# form name=PageSwitch#ThisPage# action=""> method=Post input type=hidden name=Level value=#Attributes.Level# input type=hidden name=StartRow value=#Attributes.PageNumberStart# input type=hidden name=PageNumber value=#ThisPage# input type=hidden name=Action td class=generictexta > href=""> #ThisPage#';return true true#ThisPage#/anbsp;/td /form /cfloop The JS errors read: - Error: document.PageSwitch2.Action has no properties and - Error: document.PageSwitch2.submit is not a function. Source File: _javascript_:document.PageSwitch2.submit(); Thanks Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I could use a JS expert right now.
Nickwrote: - Error: document.PageSwitch2.Action has no properties action is lower case. aha!Action is a reserved word?I think Che has it as a field name... you could also try changing that -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Whats the easiest way to calculate response times of all objects on a web page?
I'm testing a page that has some _javascript_s which pull various objects from several servers. I know one of them is slow but I'm looking to find the easiest way to request a URL and get a spreadsheet with graphs or something showing me what GET requests are taking the longest amount of time. Remember there are _javascript_s at work so it probably needs to work in conjunction with an IE instance. Anybody know of any good tools I can use? My buddy who works on a Mac showed me a mac screen which does exactly that but I'm working on a PC. Aside from using a Mac, what can I get for windows? Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weather feed
I'll note that you didn't bother to tell me.Thanks. You're welcome. :) Thanks for the explanation, that orphan cities thing is fubar'd (thanks NOAA). What a bummer. I can't wait for the day that they get with the program and offer XML feeds of their data. -Original Message- From: Todd Finney [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 12:37 AM To: CF-Talk Subject: Re:weather feed Not as many as the other one, but some of those feeds are not right (wrong city/state). http://weather.boygenius.com/oklahoma-miami_beach.xml http://weather.boygenius.com/oklahoma-miami_beach.xml I promise you there is no Miami Beach, OklahomaI would've already gone there, oh well. Late chiming in, perhaps this is still relevant to someone. The orphan cities are a consequence of the NOAA date that I'm parsing to generate the XML files.The NOAA data is stored in files that look like this: SOUTHWEST OKLAHOMA CITYSKY/WX TMP DPRH WIND PRESREMARKS CLINTONCLOUDY 21857 N330.48F HOBARTCLOUDY 231057 NE9 30.49F WCI13 The file is called something like 'weather-roundup-ok.txt'.All my script does is say ok, we're looking at ok, that's Oklahoma, so take these lines and put them in files called 'oklahoma-clinton.xml' and 'oklahoma-hobart.xml'. The problem with this is that the NOAA isn't really strict about state boundaries in their data.New York City, for example, appears in the New York file, the Pennsylvania file, the New Jersey file, and (oddly enough) the Massachusetts and Maine files. Well, fugly data calls for fugly parsing, so I have this subroutine that says If you see New York City, Massachuettts, it's really talking about New York City, New York.This works fine, except that it requires me to have a line in my script for every NOAA geographical generalization.Every once and a while, a new one pops up, and you get things like oklahoma-miami_beach.xml. This is noted in the changelog on the site: 20030902 - I think I have all of the orphan cities taken care of. If you notice any that I've missed, please tell me. I'll note that you didn't bother to tell me.Thanks. Anyhoo, the file you listed above would have contained the correct weather information for Miami Beach, it would have just had the wrong state name.I don't consider this to be a big deal, because if you want the weather for Miami Beach, the place to look is florida-miami_beach.xml. Todd _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: GeoTrust Certs @ 25$ ?
Jack Dalaa wrote: It's $25, no catch. I've purchased numerous certificates through these guys over the past year and a half, there's nothing fishy about it, just a great deal. I've got the same story, but my experience was a little different. There is, indeed, a catch.As was pointed out earlier renewals are at the full rate of US$119.Try and renew via Rachshack's $29 form (now renamed to ev1.net) and you will find out that GeoTrust auto-senses a renewal and won't let you in for the cheap rate unless you switch domains (i.e. switch to secure.blah.com instead of www.blah.com).So kiss your certificate profits goodbye in Year 2 or kick up your maintenance costs playing games on the renewal. Next, Rackshack/EV1 sends out renewal notices... Both to the tech and the admin contact, so if that's your client they get the notices and then bother you wondering what the deal is.Worse (and I know this is deliberate as I have so many of these installed, and have seen dozens) they send a false expiration email a few days before the cert expiration.This note says the cert expired five days ago.The reality is its got about a week left... It's a ploy to get you to renew. So I moved over to instantssl.com. I'm a reseller there and I pay about US$42 for each cert.Naturally, you can retail them for whatever you want.It's a very, very easy and truly instant process (note that you can only self-verify and get instant issuance if you are an instantssl reseller). Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I could use a JS expert right now.
i don't believe action is a reserved word. I removed the action reference from the href and entered a value for the hidden variable Action. the page still bombs. this sucks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:45 PM To: CF-Talk Subject: RE: I could use a JS expert right now. Nickwrote: - Error: document.PageSwitch2.Action has no properties action is lower case. aha!Action is a reserved word?I think Che has it as a field name... you could also try changing that -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looping through checkbox
How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Fusebox - whats the big deal anyway?
When we started using CF we all sat down and did the 'Allaire SkillBuilding' interactive training CD. This gave us the basics we needed to know but also taught us to do everything wrong in terms of a framework.We developed some pretty bad code in terms of its structure, reusability and maintainability. Now we use FB3 and code is much better in terms of structure, reusability and maintainability. As others have said it's not the only framework and whether its best is a matter of opinion, however its a popular framework and fairly easy to learn and use. Michael Traher -Original Message- From: Dan Farmer [mailto:[EMAIL PROTECTED] Sent: 06 December 2003 18:34 To: CF-Talk Subject: Fusebox - whats the big deal anyway? First off I admit that I don't know much about Fusebox, other than it's a methodology for writing web application software. I've done a bit of research into it. And quite frankly I don't see what the big deal is. I think the thing I don't like about it, is that Fusebox is someone else's idea of how to create a web application. So right off the bat Fusebox developers short-cicrut their own creative ways to use Coldfusion and place themselves into a box that someone else has defined? Again, I'm no expert on programming or coldfusion ( I do know some ), but I think what I do know is creativity. Would it not be more fun, more exciting to develop your own methods of doings things? Methods that are customized to your own unique personality and skill? I do welcome Fusebox developers to enlighten me as to the benefit of using it and why. Maybe even comment on how they can use their own creative processes within it. Right now, Fusebox just seems like a good idea for the person who created. We could all create a new methodology ourselves...right now call it Ultimate Coral Dragon, then write books and articles...I don't know, it all seems silly. _ __ Daniel Farmer Web Developer Consultant P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
are they all the same name? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
Shahzad wrote: How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Who's selected the checkboxes the end-user or you, the developer? -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
Only the value of the selected checkboxes will be passed to the action page. How are you using the checkboxes? Ade -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 18:02 To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I could use a JS expert right now.
Che the page still bombs. this sucks. Can you post the generated source code? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
-Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
- they all have different names - user is selecting the check boxes following is the code the way i am using cfloop query=GetAllUnitPromotionForType tr tdinput type=checkbox name=Unit#Counter# value=#GetAllUnitPromotionForType.PK_UnitPromotion_ID/td ... /cfloop _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 18:04 To: CF-Talk Subject: RE: Looping through checkbox are they all the same name? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looping through checkbox
Shahzad.Butt wrote: How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Ifa checkbox is not selected, its value is NOT passed to the action page... so you can't check to see if it's checked or not.. if the variable name exists (FORM.yourCheckBoxFieldName), then it is checked. Assuming you haven't CFPARAM'ed it yet. Cold Fusion treats the checkboxes with the same name as a comma separated list.If your values have commas in them, it gets much more difficult to loop through them, but otherwise, just use a CFLOOP for a list (see docs for cfloop). If you want to loop through all the checkboxes that were checked, regardless of their name, then you have to name them appropriately (so cold fusion can tell the difference between checkboxes and other input fields), and then loop through the FORM struct (again, see docs for cfloop).Yuck! - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
Only checkboxes that get selected are passed to the action page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:13 PM To: CF-Talk Subject: RE: Looping through checkbox - they all have different names - user is selecting the check boxes following is the code the way i am using cfloop query=GetAllUnitPromotionForType tr tdinput type=checkbox name=Unit#Counter# value=#GetAllUnitPromotionForType.PK_UnitPromotion_ID/td ... /cfloop _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 18:04 To: CF-Talk Subject: RE: Looping through checkbox are they all the same name? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I could use a JS expert right now.
Nick, et al. See attached for the generated code. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:08 PM To: CF-Talk Subject: Re: I could use a JS expert right now. Che the page still bombs. this sucks. Can you post the generated source code? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
Not knowing all of you code... I don't see the need for the checkboxes to be named diff cfloop query=GetAllUnitPromotionForType tr tdinput type=checkbox name=PromoCode value=#Unit#_#GetAllUnitPromotionForType.PK_UnitPromotion_ID#/td ... /cfloop Then on action page... just use form.PromoCode and you will get a comma delimited list of only the selected checkboxes Then you can parse it out as a list with Unit_PromoCode and you will be looping over only what is selected You could maybe even drop the Unit var but I'm sure you'll know whether to do that or not :-) -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Debugging CFQUERYPARAM
Where did you hear that one Jochem?MySQL enforces NOT NULL just fine. mysql create table test (id int not null); Query OK, 0 rows affected (0.05 sec) mysql insert into test (id) values (null); ERROR 1048: Column 'id' cannot be null Cheers, barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 8:16 AM To: CF-Talk Subject: Re: Debugging CFQUERYPARAM Charlie Griefer wrote: does your database accept null values/empty strings for those columns? MySQL does not enforce NOT NULL constraints even if they exist. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
Check #form.fieldnames# and see what you have. I think you'll see then what to do. (Only the checkboxes that are checked will have values). -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:04 PM To: CF-Talk Subject: RE: Looping through checkbox are they all the same name? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
The Value of CFQUERYPARAM
When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Referencing a .CFC in a sub directory.
Hello all, I have a directory structure off a particular webroot on a multihomed server: /admin /public /components. I placed my .cfcs in the /components directory. I am trying to call the CFCs using cfinvoke and also directly using the form action="" attributes. I do not want to have to put the components directory beneath the /admin or /public folder. I want to store all my components in just one directory. How would I reference cfcs from files in the /admin or /public folders? I have tried . notation to no effect. Referencing these cfcs workes perfectly when they are placed in the relevant subdirectory..either /admin or /public. What am I doing wrong? -Gel --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Hard code them Jochem's words of wisdom... Oracle uses cfqueryparam to bind vars If you don't, the DB Query Engine (or summat) will treat them as dynamic bind variables and although it probably doesn't harm that much to have them in cfqueryparam, they aren't bind vars... they are constants thus don't need it ... trying to find the link to it in the archives at the moment to the discussion -- dc -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 18:36 To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Doesn't it only recompile when the values change and queryparam gets around that?I think if the values are constant there is no advantage to putting them in a param, but that depends on if it recompiles every time or not. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:43 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
alternative to CFFTP
I need to pull files from an FTP site...unfortunatley this ISP is not allowing the CFFTP tag... great then I asked what tags they disabled... and they wouldn't tell me... [ insert curses here ] anyway, what other options do I have to accomplish the actions of FTP? Basically I need to open and get a file... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Another consideration is that you cannot use CF query caching on a query that uses CFQUERYPARAM tags.(At least with CF5 and earlier.) Chris -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL col type
Hello All, I don't know if this is possible or not but I thought I would ask.I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying. I am querying one database then inserting info in to another(access) I guess what I am looking for is something like this I run a query Select Name, AccountNumber, Address1, PIN from Table And have something come back like this Name(text), AccountNumber(numeric), Address(text), pin(numeric) I am doing this because I am trying to dynamically wrap text element in ' ' depending on the data type. Am I asking for something impossible? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: GeoTrust Certs @ 25$ ?
So I moved over to instantssl.com. I'm a reseller there and I pay about US$42 for each cert.Naturally, you can retail them for whatever you want.It's a very, very easy and truly instant process (note that you can only self-verify and get instant issuance if you are an instantssl reseller). This is an interesting summary of ssl providers: http://www.sslreview.com/content/table/index.html Tom Nunamaker [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. In the most ineloquent and non-technical way (and with respect to Oracle who supports the bind vars) If you use the cfqueryparam round the static var... then it will treat that bit of SQL as dynamic and will recompile every time If you don't put it in a cfqueryparam then it will tell the dbengine that that bit of SQL is not going to change... dont bother trying to treat it dynamically resources freed I asked this question and quite a discussion broke out between the DB heavyweights (Jochem and Adam I think) I've tried my best to find it in the archives but I can't for some reason. The rule I got from listening to others was to *only* use cfqueryparam for dynamic vars in the SQL (dates are an exception cos there a PITA anyway) if they aint gonnae change, why put them in cfqueryparam? http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_or acle_databases.html#4 snip CFQUERYPARAM In the example query, ColdFusion Server will send the query to the Oracle database as: SELECT username FROM users WHERE user_id=:1 The :1 is a substitution variable (parameter reference). The execution path is the same whether the userID is 2236 or 39393. Because there's no use in parsing it more than once, ColdFusion can use the cached query in the cache and thus conserve server resources. /snip ie what's the point in forcing this parse if it is not necessary it's the DBEngine that caches the query... not CF -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Re:CF pda types of devices
As others have said, if your handheld uses real browser that consumes html, then you just use CF as normal. Some things to keep in mind are that IE on a PocketPC is a strange beast and that the capabilities recently changed significantly with the release of Windows Mobile 2003. Prior to the 2003 OS, the PocketIE was basically just the IE 3 codebase. That means HTML3.2 and no CSS support. The new 2003 OS updated PocketIE to support CSS, but I haven't seen a full breakdown of how well it supports it. I've read that float isn't there. There are also alternate browsers out there for the PocketPC, including NetFront which is on the Clie and something called Thunderhawk. And then, of course, there's the entire non-Pocket PC market of PDAs and cellphones. The most common suggestion I've seen for devloping for handheld browsers is to create a completely CSS based site, and then either design a minimalist CSS display or even trick it to completely hide the CSS display and revert to an unformatted site. Not pretty, but more useable than a design you can't use at all. Also, consider Flash RIAs. Maybe it's just some specific features of your site that you will make available, and those can be best handled by distributing the content in a different way. Flash RIAs can run on PocketPC, Palm and even some cellphones and their implementation is more consistent. Good luck. -Kevin - Original Message - From: Chunshen (Don) Li [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:59 AM Subject: Re:CF pda types of devices Personally in general I would prefer to use ONE for the other option would require much more time/efforts and cost for essentially the same thing.And I would think that browser for PDA type of device would simplify data display and navigation whenever possible as Thomas mentioned. Don so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF pda types of devices Date: Mon, 8 Dec 2003 16:23:43 + MIME-Version: 1.0 Received: from houseoffusion.com ([64.118.64.245]) by mc7-f6.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 8 Dec 2003 08:32:53 -0800 Received: from LOCALHOST by LOCALHOSTwith ESMTP id 1E50022862FD7D47AF87ADCF804B9FE9Mon, 8 Dec 2003 11:25:43 -0500 X-Message-Info: JGTYoYF78jH0WUrlLkM9Hj8F8ul61g5l Message-ID: [EMAIL PROTECTED] Precedence: bulk References: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 08 Dec 2003 16:32:57.0379 (UTC) FILETIME=[EFEA9730:01C3BDA8] On Monday 08 Dec 2003 16:17 pm, Dan Farmer wrote: Interesting, do those devices use HTML or WML ? My P900 does both - it runs Opera for (X)HTML for instance :-) -- 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: OT: GeoTrust Certs @ 25$ ?
Tom Nunamaker wrote: This is an interesting summary of ssl providers: http://www.sslreview.com/content/table/index.html Interesting, and false. Both Comodo and Geotrust maintain phony 'independent' ssl 'choice' sites.sslreview.com changed its name (I forget what it used to be) fairly recently.The former domain records showed an ownership by... guess who?Geotrust. The slant is pretty obvious without the smoking gun of a domain record.Anyone who uses instantssl certs knows the sslreview claims of Comodo using the old Baltimore root are false.Comodo has used the Equifax root for quite some time now.And reading thru the site, notice how EVERY other provider gets some sort of a black eye except one?3 guesses which one comes out clean. Comodo's bogus review site is at http://www.whichssl.com/.Notice how that supposedly independent site spends a lot of time bashing Geotrust.Go figure. Geotrust fibs about Comodo's root; Comodo overblows Geotrust's (statistically bad) ubiquity, among other things.Neither player is a saint.One alternative is Verisign, who we all know is an upstanding bulwark of ethics in this industry. ;-) -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Another consideration is that you cannot use CF query caching on a query that uses CFQUERYPARAM tags.(At least with CF5 and earlier.) I'm pretty sure this is also true with CFMX. 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: The Value of CFQUERYPARAM
I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsedevery time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solution for this because the QUERYPARAM is a bind variable that the DB can handle and knows no to parse again. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:58 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF pda types of devices
I have noticed that you can now get an http server for PocketPC.I have not tested it but I saw it on the MS SDK 2003. Dave Adams [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Getting 2 first lines from textarea formatted field
Hi all i need to get 2 firt lines (or 150 first chars) from textarea formatted field like macromedia search action... Is possible? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF pda types of devices
I have noticed that you can now get an http server for PocketPC. I have not tested it but I saw it on the MS SDK 2003. That has been available for quite some time - since Pocket PC 2000, I believe. It can also run ASP! I've run it on my Pocket PCs for a while, just for kicks. However, it only supports one or two concurrent requests, and I wasn't able to connect it to a database (SQL Server CE) through ASP (although admittedly I didn't try very hard). It's really intended for custom Windows CE devices that need web administration interfaces. 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: Getting 2 first lines from textarea formatted field
Left(string, 150) Will get you the first 150 characters... Am I missing something? If you need the first two lines then read in the file and treat it as a Chr(10) delimited list. -Novak -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:42 AM To: CF-Talk Subject: Getting 2 first lines from textarea formatted field Hi all i need to get 2 firt lines (or 150 first chars) from textarea formatted field like macromedia search action... Is possible? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: GeoTrust Certs @ 25$ ?
The old name was www.whichssl.org That's good to get another opinion besides that one site.I had noticed GeoTrust did come out smelling like a rose.I have a site that uses VeriSign's Pay Flow Pro payment processing.When I was on the phone to the sales rep at VeriSign, he asked me if I needed an SSL certificate. I said I did but that VeriSign's were too expensive.He then told me if he were me, he wouldn't get a VeriSign one either.:) Thanks for the different perspective. Tom Tom Nunamaker wrote: This is an interesting summary of ssl providers: http://www.sslreview.com/content/table/index.html Interesting, and false. Both Comodo and Geotrust maintain phony 'independent' ssl 'choice' sites.sslreview.com changed its name (I forget what it used to be) fairly recently.The former domain records showed an ownership by... guess who?Geotrust. The slant is pretty obvious without the smoking gun of a domain record.Anyone who uses instantssl certs knows the sslreview claims of Comodo using the old Baltimore root are false.Comodo has used the Equifax root for quite some time now.And reading thru the site, notice how EVERY other provider gets some sort of a black eye except one?3 guesses which one comes out clean. Comodo's bogus review site is at http://www.whichssl.com/.Notice how that supposedly independent site spends a lot of time bashing Geotrust.Go figure. Geotrust fibs about Comodo's root; Comodo overblows Geotrust's (statistically bad) ubiquity, among other things.Neither player is a saint.One alternative is Verisign, who we all know is an upstanding bulwark of ethics in this industry. ;-) -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Just for fun then if you have a mix of constants and variables would it be written like this? SELECT * FROM table WHERE status = 'A' AND ID = cfqueryParam value=1246 ... or SELECT * FROM table WHERE status = cfqueryParam value=A ... AND ID = cfqueryParam value=1246 ... I would think the former from the answers in this forum, but I'm not sure. Or are they both the same really, and it doesn't matter? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsedevery time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solution for this because the QUERYPARAM is a bind variable that the DB can handle and knows no to parse again. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:58 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
I would think the former from the answers in this forum, but I'm not sure. Or are they both the same really, and it doesn't matter? The second answer still uses the CFQUERYPARAM bonuses for queries, so if you use the same SQL somewhere else, just changing the one field, then use CFQUEYPARAM... Disadvantage of using CFQUERYPARAM? You can't cache them! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Both will work, both will be cached.IMHO it is easier to read the query if the constants are not bind variables. Shawn McKee -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:54 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Just for fun then if you have a mix of constants and variables would it be written like this? SELECT * FROM table WHERE status = 'A' AND ID = cfqueryParam value=1246 ... or SELECT * FROM table WHERE status = cfqueryParam value=A ... AND ID = cfqueryParam value=1246 ... I would think the former from the answers in this forum, but I'm not sure. Or are they both the same really, and it doesn't matter? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsedevery time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solution for this because the QUERYPARAM is a bind variable that the DB can handle and knows no to parse again. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:58 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
That made little sense.I meant to write:L SELECT * FROM table WHERE status = 'A' AND ID = cfqueryParam value=#form.ID# ... or SELECT * FROM table WHERE status = cfqueryParam value=A ... AND ID = cfqueryParam value=#form.ID#... That should be a better example. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Ian Skinner Sent: Monday, December 08, 2003 11:54 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Just for fun then if you have a mix of constants and variables would it be written like this? SELECT * FROM table WHERE status = 'A' AND ID = cfqueryParam value=1246 ... or SELECT * FROM table WHERE status = cfqueryParam value=A ... AND ID = cfqueryParam value=1246 ... I would think the former from the answers in this forum, but I'm not sure. Or are they both the same really, and it doesn't matter? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsedevery time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solution for this because the QUERYPARAM is a bind variable that the DB can handle and knows no to parse again. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:58 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
The second answer still uses the CFQUERYPARAM bonuses for
queries, so if you use the same SQL somewhere else, just
changing the one field, then use CFQUEYPARAM...
Disadvantage of using CFQUERYPARAM? You can't cache them!
You can't use cachedwithin/cachedafter. You can certainly cache it manually.
if(not isdefined(application.foo)) {
do the query and store in app scope
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: The Value of CFQUERYPARAM
If you've got both, it doesn't really matter, though the former is probably a hair faster, and it's certainly easier to read. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:54 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Just for fun then if you have a mix of constants and variables would it be written like this? SELECT * FROM table WHERE status = 'A' AND ID = cfqueryParam value=1246 ... or SELECT * FROM table WHERE status = cfqueryParam value=A ... AND ID = cfqueryParam value=1246 ... I would think the former from the answers in this forum, but I'm not sure. Or are they both the same really, and it doesn't matter? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsedevery time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solution for this because the QUERYPARAM is a bind variable that the DB can handle and knows no to parse again. Shawn McKee -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 12:58 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB server. However, if you use cfqueryparam what is sent: SELECT M FROM S WHERE W = ? ? = 'huh' So the DB compiles (only once) the query and puts in 'huh' as the argument. Summarizing it doesn't matter whatever 'huh' is static or from a variable, it is still treated the same way. Also, it would help to remember that #your_var_here# causes the value of the var to be printed and it becomes static text. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:47 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Even though the value is static and unchanging, the query will be recompiled every time?This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:43 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Use CFQUERYPARAM as the DB engine will only compile you query once and hopefully cache it. Otherwise it will re-compile every time. TK -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPARAM When writing a select statement, if I have a part of a WHERE clause that will be static, always the same value, and this value is not passed in with a variable or constant, is there any inherent value in cfqueryParam ... tags? An Example: WHERE STATUS = cfqueryParam value=M ... or WHERE STATUS = 'M' Is there any real advantage of one of these forms over the other? Just to repeat, these are hard coded, unchanging values NOT passed in with variables or constants.I understand the value of the cfqueryParam tags in conjunction with passing in data with variables, especially data from user forms. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Do you apply tax after shipping costs?
Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Do you apply tax after shipping costs?
before, im pretty sure. your paying taxes for the goods. not the shipping costs. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:04 PM To: CF-Talk Subject: OT: Do you apply tax after shipping costs? Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL col type
I don't know if this is possible or not but I thought I would ask.I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying. If this is MX, and you want to write some Java code, you can do it via the JDBC metadata interface. ADO can also give you this info. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Do you apply tax after shipping costs?
It depends on the State.Some states charge tax on the shipping as well. they gotta get every cent they can you know. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 2:07 PM To: CF-Talk Subject: RE: Do you apply tax after shipping costs? before, im pretty sure. your paying taxes for the goods. not the shipping costs. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:04 PM To: CF-Talk Subject: OT: Do you apply tax after shipping costs? Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Referencing a .CFC in a sub directory.
Just some additional info, I have gotten the CFCs to work perfectly via the FORM Action attribute using the html pathname of the CFC. Action="" Method=POST Works fine. Can't get the CFINVOKE to work. -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Hello all, I have a directory structure off a particular webroot on a multihomed server: /admin /public /components. I placed my .cfcs in the /components directory. I am trying to call the CFCs using cfinvoke and also directly using the form action="" attributes. I do not want to have to put the components directory beneath the /admin or /public folder. I want to store all my components in just one directory. How would I reference cfcs from files in the /admin or /public folders? I have tried . notation to no effect. Referencing these cfcs workes perfectly when they are placed in the relevant subdirectory..either /admin or /public. What am I doing wrong? -Gel --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Do you apply tax after shipping costs?
That's what I'm figuring...but someone else had just advised me otherwise. Doh. Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:07 PM To: CF-Talk Subject: RE: Do you apply tax after shipping costs? before, im pretty sure. your paying taxes for the goods. not the shipping costs. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:04 PM To: CF-Talk Subject: OT: Do you apply tax after shipping costs? Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Do you apply tax after shipping costs?
No, that's a good question. I think Tony is right cuz you pay taxes on goods, not services. Right? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:04 PM To: CF-Talk Subject: OT: Do you apply tax after shipping costs? Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: GeoTrust Certs @ 25$ ?
The old name was www.whichssl.org ah yes, thats it... I think they were first and Comodo fired up the .com as a counterattack. One thing I didn't mention is the hi-pressure sales tactics Comodo uses.Don't call them unless you are ready to go, otherwise an account rep will try to become your new best friend. I mis-stated Comodo's root earlier.Its the GTE Cyber-Trust root.The Equifax CA is owned by Geotrust. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
