Re: Sessions - won't stick around
I am not using client variables ... This was working .. I was coding and then refreshed and it stopped working... I hadn't changed any settings ... just coding and saving and reloading the browser .. and then poof! It stopped working. I am going to load some old code and see if it is something I possibly did ... Paul Giesenhagen QuillDesign - Original Message - From: Andre Turrettini To: CF-Talk Sent: Friday, October 10, 2003 3:16 PM Subject: RE: Sessions - won't stick around Paul, it appears youre not having cf send cookies to the browser. So, in this case you would have to add the cfid and token to your url string. Are you doing this? If not, I'd try setting setclientcookies = 'yes'. DRE -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 1:46 PM To: CF-Talk Subject: Sessions - won't stick around Has anyone ever been working with application that uses sessions and for some reason, your server will not hold sessions? All of a sudden CFMX 6.1 stopped .. i could set the session, but as soon as I reloaded the page, the session was gone. Exampe: It would output just fine .. and then if I reload the page, session.sessionTest was not there. I have this in my application.cfm file: setclientcookies="no" setdomaincookies="no" sessiontimeout="30"> And in the CF Admin sessions are set to 20 minutes .. NOTHING has changed in the application or CF Settings .. I have even rebooted the server. Very strange.. Also, I though maybe some code I put in possibly was deleting the session .. but I put that sessionTest in the app and it didn't stick either .. CFMX 6.1 WindowsXP (local box). Thanks Paul Giesenhagen QuillDesign _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sessions - won't stick around
Deleting all my cookies didn't work .. also, this was working fine for days .. just this day it decided to crap out .. Paul Giesenhagen QuillDesign - Original Message - From: Matt Robertson To: CF-Talk Sent: Friday, October 10, 2003 4:18 PM Subject: Re: Sessions - won't stick around Paul wrote: >I am not using client variables ... If you shut off client management you also shut off CF's ability to track your sessions on its own, since it keeps track of visitors server-side via client.cfid and client.cftoken. Setclientcookies has to be set to "yes" (or left out as its the default) as it sets the key pair on the client side. You need 'em both to get the job done, but you can do without one, the other or both if you faithfully, manually pass the key pair around. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Can't Load a Null
I am getting this error when activating a component .. this is an extention of what I thought was a session issue, but now it is just an argument issue. I for the life of me cannot figure this one out. Below is the error first and then the code: (any help is appreciated) can't load a null The error occurred in C:\CFusionMX\wwwroot\cart.cfm: line 74 72 : argumentcollection="#FORM#"> 73 : 74 : 75 : 76 : component="#request.componentDirectory#.cartController" method="cartAdd" returnvariable="cart" argumentcollection="#FORM#"> component="#request.componentDirectory#.cartController" method="cartMod" returnvariable="order"> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Query
I need to write a query and really don't know where to start -- here is the description. I have a number of reports all dated, but dated by day (no time). Some of the reports are on the same day If I have an ID value, I need to grab the report before and the report after that ID and it needs to be by date. Here is what the data looks like: ReportID | ReportDate | Report | 19/10/2003 29/11/2003 39/11/2003 49/11/2003 59/12/2003 89/12/2003 99/14/2003 1110/01/2003 etc.. If I am looking at ReportID (5), then I want to know that reportID 4 is previous and reportID 8 is next So my output should be Previous = 4 This > Next = 8 Oh, and I need to know if previous is Nothing or Next is nothing (ie there isn't anymore eitherway). ANY help would be greatly appreciated! Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
The dataset is fairly small .. I doubt it would be over a few hundred records for awhile .. and in a few years maybe up to 2000, so I don't think it will be a huge ordeal. Thanks in advance, I will give it a try! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
Ok here is the query that I have ... and the error that is showing up. I am using MS SQL 2000 ( SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ) ORDER BY tripDate ERROR: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near ')'. SQL = "SELECT TOP 1 * FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = 1032) UNION SELECT * FROM beaverReports WHERE reportID = 1032) UNION SELECT TOP 1 * FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = 1032) ORDER BY tripDate" Thanks for the help! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Service not running
I tried to install CFMX 6.1 on my notebook and when I tried to setup an Access DB in the Datasources, I recieved the following message: The ColdFusion MX odbc server service is not running or has not been installed. Anyone know how to go about getting this running? (I looked at the services and both ODBC MX services are running). Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
No, this query still isn't working .. what the problem is some of the dates are the same ie there may be three reports on 10/22/2003 and 0 on 10/23/2003 and 1 on 10/24/2003 So the question is this, since my dates are duplicated, this may be impossible correct? What other solutions could be possible? I would hate to put in a sort method as below, it would be unconventional .. though it would work ... and it would then sync everything up .. would this be poor practice? I am assuming yes. IF not, would there be a better way to do it? SELECT reportID FROM beaverReports ORDER BY tripDate DESC UPDATE beaverReports SET tripSort = #thisQuery.currentRow# WHERE reportID = #thisQuery.reportID# Paul Giesenhagen QuillDesign - Original Message - From: Tony Weeg To: CF-Talk Sent: Friday, October 17, 2003 12:01 PM Subject: RE: OT: SQL Query does this work? SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport# UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ORDER BY tripDate same thing minus the beginning ( and ending ) you had followed by a straggler order by tripDate? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 12:40 PM To: CF-Talk Subject: Re: OT: SQL Query Ok here is the query that I have ... and the error that is showing up. I am using MS SQL 2000 ( SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ) ORDER BY tripDate ERROR: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near ')'. SQL = "SELECT TOP 1 * FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = 1032) UNION SELECT * FROM beaverReports WHERE reportID = 1032) UNION SELECT TOP 1 * FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = 1032) ORDER BY tripDate" Thanks for the help! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
High ASCII Characters
We have a problem and maybe someone has dealt with this before: Our Setup: CFMX 6.1 MySQL 4.x Solaris Apache If I put ® into a textarea box, it goes into the database fine, I view the data in the database and it is still fine, I output it on a page and yet still fine, BUT, if I load that into a form Textarea, it changes it to a unknown box and thus if I click update transfers it into the database and IE displays it as a chinese character. So everything works until I bring it out of the database into a textarea form field ... Is this an IE setting, or what? We have never had this problem before running on Windows 2k, CF5 Thanks in advance! Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Tool to move Access-to-MySQL
It's not free, but it works great they have converters for just about everything: ($39.00) http://www.convert-in.com/ Paul Giesenhagen QuillDesign - Original Message - From: Ketan Patel To: CF-Talk Sent: Thursday, November 20, 2003 9:29 AM Subject: Tool to move Access-to-MySQL Hi All, Does anybody know about free tools which will move Access-to-MySQL and which will not spoil or change the data structure. Ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Query
I have three tables and I know the guideID. The Fusion table below brings the guides and the lakes together. If a Guide is a guide at 1 or more lakes, the lakeID and the guideID are put into a row into the fusion table. Guides can be associated with many lakes and many lakes associated with a guide. I want to display a series of checkboxes for the list of ALL lakes .. and then denote (check) the checkboxes of the lakes that the KNOWN guideID is a part of. So If I am viewing guideID = 1001 then I want to see all the lakes, but distinguish which lakes are associated with guideID = 1001 Can this be done in a single query or am I going to need some CF integration.? Lakes Table: lakeID, lakeName Guide Table guideID, companyName Fusion Table fusionID, lakeID, guideID Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: US Sales Tax Question
To where it is shipped as it's final destination. Made in Missouri - Shipped to warehouse in Kansas, sold to end user in Kentucky --- Kentucky tax. This is how I understand it ... but I would check with a tax fella! Paul Giesenhagen QuillDesign - Original Message - From: Stacy Young To: CF-Talk Sent: Wednesday, December 03, 2003 12:15 AM Subject: OT: US Sales Tax Question If a product is manufactured in one state but distributed from another...which state tax applies? From where it's shipped? Thanks! 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: write a file using CFFILE with CF tags in it
Try this: #variables.left#cfset id = myquery.id#variables.right# #variables.left#cfinclude template="../mypage.cfm"#variables.right# Paul Giesenhagen QuillDesign - Original Message - From: Ketan Patel To: CF-Talk Sent: Monday, December 22, 2003 9:30 AM Subject: write a file using CFFILE with CF tags in it Hi, I want to write a file with following 2 cf tags in it output=" " addnewline="no"> I am getting an error. Ketan Patel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Columns in MS Access
Is there a syntax that you can pass to a MS Access Db to get a list of column names for a particular table? Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Columns in MS Access
Nope, that is what I was looking for ... Thanks Paul Giesenhagen QuillDesign - Original Message - From: Charlie Griefer To: CF-Talk Sent: Wednesday, December 31, 2003 2:51 PM Subject: Re: Columns in MS Access you can query on SELECT *, and then do a #queryname.columnlist# ? or are you looking for something within Access itself? - Original Message - From: Paul Giesenhagen To: CF-Talk Sent: Wednesday, December 31, 2003 1:47 PM Subject: SOT: Columns in MS Access Is there a syntax that you can pass to a MS Access Db to get a list of column names for a particular table? Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CMS Solutions (Friendly URL's)
Though this is true and needs to be addressed when building a site, you should always keep a few things in mind, 1) Quality of content on your site (clear content for actual human eyes who are reading). This should outweigh anything else on your website. 2) Though there are many things that are relevant to search engines, they all have various weights and some things are more important than others. More effort should be put on keyworded content and relavant keywords than on how many levels a page goes deep ... I have seen too many website owners who get hung up on the statements below that they loose sight of what their webpage is all about. If you can accomplish all aspects of quality content, relative keywords and search engine friendly keywords great ... but if you can't pick away at whats important first.. and do your best at whats left over. Paul Giesenhagen QuillDesign - Original Message - From: John Quarto-vonTivadar To: CF-Talk Sent: Friday, January 02, 2004 4:33 AM Subject: RE: CMS Solutions (Friendly URL's) It's not the friendliness to users which is significant but rather the friendliness to search engines coupled with how they weight various aspects of a given resource on the web. Short URLs are given a much higher weight than long(er) URLs, (presuming the content is otherwise the same). Ditto again for the size of the query string on the URL. And relevancy of the name of the file in the URL, if any, also is given high weight *if* that also corresponds to in-document context. This is why the so-called 'search engine safe" URLs don't really do much for most sites if all they do is substitute slashes for ampersands and equals signs; most search engines will start decrementing relevancy weight once the URL is more than 2-3 levels deep. One needs short relevant file names in a short shallow URL corresponding to actual content in the document to make the biggest impact in the search engine rankings. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 4:33 PM To: CF-Talk Subject: RE: CMS Solutions (Friendly URL's) Just out of curiosity, but why is the URL "awful"? Sure, it's not something you can memorize, but outside of that, who cares how crazy it looks. The typical user will just bookmark it and not even notice what the URL says. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
XPay - CFMX - XML
I guess the first question would be, has anyone setup for Xpay? (Secure Trading)? If so, would you mind sharing some information? Xpay facilitates the processing of realtime credit cards. I need to send an XML document to the XPay via internal TCP/IP socket then XPay picks up the XML and sends it on for processing and sends back the response. The question is, how do I send an XML string to the XPay client via an internal socket? It resides on 127.0.0.1 port 5000 if that helps ... I usually do not deal in these types of issues so I am alittle lost! Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XPay - CFMX - XML
The XML packet is being pushed to the IP on port 5000. Paul Giesenhagen QuillDesign - Original Message - From: Robert Munn To: CF-Talk Sent: Tuesday, July 20, 2004 4:53 PM Subject: Re: XPay - CFMX - XML > The question is, how do I send an XML string to the XPay client via an > internal socket? It resides on 127.0.0.1 port 5000 if that helps ... Is it using Web services or is it just a raw XML packet being pushed to the IP on port 5000? If it uses Web services, you can use cfinvoke to invoke it. Here is an example from the CFMX docs: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/webser16.htm Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Best Practice - Forms
I am not sure what you are actually asking ... Questions back at you: 1) Are you concerned with someone who inserts a form and hitting their back button only to get the form again without anything in it or an EXPIRED page? 2) Or are you asking if someone goes into a page where they are updating information, and then hits refresh? Wouldn't it just refresh the page and the data from the db? Maybe I am missing something on your original post. Paul Giesenhagen QuillDesign - Original Message - From: Jeff Chastain To: CF-Talk Sent: Wednesday, July 28, 2004 1:33 PM Subject: Best Practice - Forms I have dealt with this in a variety of different ways in the past, I am wanted to see how other people did it. I have a form. This same form is reused for creating a new record as well as updating an existing record. So, the question is how do people 'control' the back button and the case where the user submits the form, backs up, and resubmits it again? In the case of a create operation, the first time the form is displayed it would be empty, but upon reloading the form, it would contain the original data and would now be an update operation. In the case of an update operation, the first time the form is displayed, it would contain the current data, but upon reloading the form, it would contain the updated data and still be an update operation (would go to an update query instead of an insert). So, what are your best practices for handling form input and reusing a form? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ecommerce storefronts
We are the makers of SiteDirector... I think you are asking if the storefronts like the ones listed below process the actual credit card transactions with VISA/MC and others. The answer is no, they are the actual store or the online catalog. They use "gateways" to talk with VISA/MC once the order is placed. There are many gateways such as AuthorizeNet, Versign, CDG Commerce and others. The storefronts pass information to the gateways who then approve/decline your customer's card, then the storefront handles the response appropriately. Once the funds are extracted from the card they are then deposited into your bank account. This is usually a 1-2 day process. I hope this helps! Paul Giesenhagen QuillDesign - Original Message - From: daniel kessler To: CF-Talk Sent: Thursday, July 29, 2004 2:48 PM Subject: ecommerce storefronts It seems like that when people speak of ecommerce and CF together, they're talking about storefronts. Do I use these systems (some listed below) to go directly to VISA/MC or do I always have to go through an online merchant bank, which I find for myself? Here are the ones that I've seen listed on my houseOfFusion search: NetReady: http://www.aloha-webdesign.com/index.asp?fuseaction=details&pid=19 CFWebStore: http://cfwebstore.com/ -- looks nice SiteDirector: http://www.quilldesign.com/site/index.cfm And here's some payment services that we've considered instead of storefronts: http://www.clickandpledge.com/ https://www.verisign.com/products-services/payment-processing/online-payment/payflow-pro/index.html www.paypal.com https://www.paypal.com/PROMO/GOOGLE/MR69 http://www.prestocart.com/cgi-bin/prestocart_donations.pl?ref=google3&fr=pch Most any comments are welcome. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
I hope this helps Paul Giesenhagen QuillDesign - Original Message - From: Mark Drew To: CF-Talk Sent: Monday, August 09, 2004 9:53 AM Subject: Getting an image.. before display Imagine the situation.. you have thousands of records in a databse that refer to some images, you loop through these trying do display them I get a lot of broken images and some not. How would I go about checking that the image is there first and if so displaying otherwise... just go along my merry way? How would you go about it? -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
would be your next best bet ... but that will be a performance hit ... but it would work.. Paul Giesenhagen QuillDesign - Original Message - From: Mark Drew To: CF-Talk Sent: Monday, August 09, 2004 10:05 AM Subject: Re: Getting an image.. before display I dont know the phisical path.. was looking for a url and a relative one at that! On Mon, 9 Aug 2004 10:00:42 -0500, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > > > > > > > I hope this helps > Paul Giesenhagen > QuillDesign > > > > - Original Message - > From: Mark Drew > To: CF-Talk > Sent: Monday, August 09, 2004 9:53 AM > Subject: Getting an image.. before display > > Imagine the situation.. you have thousands of records in a databse > that refer to some images, you loop through these trying do display > them > > > > > > I get a lot of broken images and some not. How would I go about > checking that the image is there first and if so displaying > otherwise... just go along my merry way? > > > > > > How would you go about it? > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Shared Server / 500 Error
I am doing some development on a shared server for a customer and am getting an Internal 500 Server error ... is there ANY way around this error? We don't have access to the CF Admin so I can't view the error logs ... anything you can suggest? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Shared Server / 500 Error
Yes, we are creating an XML String wit hCFSCRIPT, then sending that script with and waiting for a response. I am getting nothing .. just the 500 error (script is from the company providing the services). Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Ray Champagne To: CF-Talk Sent: Tuesday, August 10, 2004 10:31 AM Subject: Re: Shared Server / 500 Error What are you trying to do? Some kind of code or explanation of what the page is doing would help. Any CFHTTP tags being used? Ray At 11:26 AM 8/10/2004, you wrote: >I am doing some development on a shared server for a customer and am >getting an Internal 500 Server error ... is there ANY way around this >error? We don't have access to the CF Admin so I can't view the error >logs ... anything you can suggest? > >Paul Giesenhagen >QuillDesign >417-885-1375 >http://www.quilldesign.com > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT Unix
If you want to create a directory with cfdirectory that is moving a file from one location into the newly created directory and you wanted it to be available for download via http ... what MODE would you set on the new directory and file? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Unix
Yes, that is alittle strong .. I was thinking it was 755 .. but wanted to make sure from some of the U Guru's out there. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Thursday, August 12, 2004 8:15 PM Subject: RE: OT Unix that's all permissions to all users right? > mode=777 > _ > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 12, 2004 8:07 PM > To: CF-Talk > Subject: OT Unix > If you want to create a directory with cfdirectory that is > moving a file > from one location into the newly created directory and you > wanted it to be > available for download via http ... what MODE would you > set on the new > directory and file? > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > _ s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Unix
Perfect .. thanks! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: chris johnson To: CF-Talk Sent: Thursday, August 12, 2004 9:03 PM Subject: Re: OT Unix On Thu, 12 Aug 2004 21:51:27 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > I thought you only needed read rights to download it and that 777 > would provide all users with all rights (including delete)? ... > Granted that I'm pretty sure there's no way to take advantage of > delete privileges via a web browser, but then I'm not a unix guru > either, so... In part, the permissions that you place on the file will depend on how you wish to distribute the file. If you are going to link to the file directly, then you should allow for read only and not write or execute (744). If you are going to use CFMX to server up the file to your users, then all you really need to provide is enough permissions to allow CF to access the file. As the file should be created using the same user and group that CF is running under, something as little as 700 should do it. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: SQL Query
I tried to ask this on Experts Exchange without any luck ... maybe one of you guys may be able to help out. I am trying to build some pricing levels into our application and having a hard time with SQL query, here is an explination. I have 2 tables: LEVELS levelID, code, description, status LEVELPRICING levelPriceID, levelID, productID, Price I am running the following query: = SELECT l.levelID, l.code, l.description, p.price FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID WHERE (p.productID = #url.productID# OR p.productID IS NULL) AND l.status = 1 = Basically I have the tables above (let me populate some data: Levels levelID, code, description, status 1 555 Wholesale 1 2 444 Gold Member 1 3222 Silver Member 0 LevelPricing levelPriceID, levelID, productID, Price 1 1 18 30.00 2 1 29 25.00 3 2 18 25.00 4 2 4227.00 I want to pull out WHOLESALE AND GOLD MEMBER (Silver is status 0 so it is turned off). I should be pulling out 2 records IF I am passing URL.PRODUCTID = 18, I should have 30.00 and 25.00 for wholesale and gold. IF my url.productID is 0 (a new product page). Then I STILL want to pull out the two rows for WHOLESALE and GOLD MEMBER, but the price should be NULL (since there is not a record for productID 0 in the levelPricing table. SO for productID = 18 l.levelID, l.code, l.description, p.price 1 555 Wholesale 30.00 2444 Gold Member 25.00 For ProductID = 0 l.levelID, l.code, l.description, p.price 1 555 Wholesale NULL 2444 Gold Member NULL On the product building page I would like to list out all the various descriptions of level pricings from the levels table. IF the productID matches up, I would like to output the associated price with the level. IF productID is 0 (or a new record), I would like it to list out the levels.description with a NULL price. This query is not working, if there are prices associated with the productID it shows the levels, but if there are not pricing associated with the productID it doesn't show the various levels. Any suggestions? I have tried multiple variations without avail. (Needs to work in MS Access and MS SQL) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query
I tried your example query, and recieved a "join _expression_ not supported" error. I assume that is an MS Access error .. I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Christian Watt To: CF-Talk Sent: Friday, August 13, 2004 5:02 PM Subject: RE: SQL Query You need to take your Where clause out and include it on the join. I believe that since you are including the outer joined table in the where, you are not going to return any records that don't match the Where statement. FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID and (p.productID = #url.productID# OR p.productID IS NULL) -Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 4:50 PM To: CF-Talk Subject: OT: SQL Query I tried to ask this on Experts Exchange without any luck ... maybe one of you guys may be able to help out. I am trying to build some pricing levels into our application and having a hard time with SQL query, here is an explination. I have 2 tables: LEVELS levelID, code, description, status LEVELPRICING levelPriceID, levelID, productID, Price I am running the following query: = SELECT l.levelID, l.code, l.description, p.price FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID WHERE (p.productID = #url.productID# OR p.productID IS NULL) AND l.status = 1 = Basically I have the tables above (let me populate some data: Levels levelID, code, description, status 1 555 Wholesale 1 2 444 Gold Member 1 3222 Silver Member 0 LevelPricing levelPriceID, levelID, productID, Price 1 1 18 30.00 2 1 29 25.00 3 2 18 25.00 4 2 4227.00 I want to pull out WHOLESALE AND GOLD MEMBER (Silver is status 0 so it is turned off). I should be pulling out 2 records IF I am passing URL.PRODUCTID = 18, I should have 30.00 and 25.00 for wholesale and gold. IF my url.productID is 0 (a new product page). Then I STILL want to pull out the two rows for WHOLESALE and GOLD MEMBER, but the price should be NULL (since there is not a record for productID 0 in the levelPricing table. SO for productID = 18 l.levelID, l.code, l.description, p.price 1 555 Wholesale 30.00 2444 Gold Member 25.00 For ProductID = 0 l.levelID, l.code, l.description, p.price 1 555 Wholesale NULL 2444 Gold Member NULL On the product building page I would like to list out all the various descriptions of level pricings from the levels table. IF the productID matches up, I would like to output the associated price with the level. IF productID is 0 (or a new record), I would like it to list out the levels.description with a NULL price. This query is not working, if there are prices associated with the productID it shows the levels, but if there are not pricing associated with the productID it doesn't show the various levels. Any suggestions? I have tried multiple variations without avail. (Needs to work in MS Access and MS SQL) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query
I tried your example query, and recieved a "join _expression_ not supported" error. I assume that is an MS Access error .. I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Christian Watt To: CF-Talk Sent: Friday, August 13, 2004 5:02 PM Subject: RE: SQL Query You need to take your Where clause out and include it on the join. I believe that since you are including the outer joined table in the where, you are not going to return any records that don't match the Where statement. FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID and (p.productID = #url.productID# OR p.productID IS NULL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query
Same error on that one ... I guess I could use the query below for MS SQL and then run a loop with MS Access .. it just seems so simple ... it should work with access. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Christian Watt To: CF-Talk Sent: Friday, August 13, 2004 5:29 PM Subject: RE: SQL Query Paul, I just test this code in MSSQL. Access my not like the or, but this one works for ProductID of 0 or 18 and works the way you want. I am not sure if access will like it. You don't have to stipulate the ProductID as null since you are doing an outer join, also, sorry I didn't catch this last time, but you want a left outer join, not right. SELECT l.LevelID, l.Code, l.description, p.Price FROM Levels l LEFT OUTER JOIN LevelPricing p ON l.LevelID = p.LevelID AND p.ProductID = #url.ProductID# WHERE (l.Status = 1) Christian -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 5:13 PM To: CF-Talk Subject: Re: SQL Query I tried your example query, and recieved a "join _expression_ not supported" error. I assume that is an MS Access error .. I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Christian Watt To: CF-Talk Sent: Friday, August 13, 2004 5:02 PM Subject: RE: SQL Query You need to take your Where clause out and include it on the join. I believe that since you are including the outer joined table in the where, you are not going to return any records that don't match the Where statement. FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID and (p.productID = #url.productID# OR p.productID IS NULL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Blown Away Query
Ok, this blows me away .. here is the query: INSERT INTO boatOptions (boatID,option) VALUES(13,'x') Simple enough? Well I am getting Syntax Errors with it.. BoatID = Int option = VarChar (75) Am I missing something here ...? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blown Away Query
Figured it out ...DB didn't like "option" .. I changed it to boatOption and it worked ... go figure.. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Paul Giesenhagen To: CF-Talk Sent: Friday, August 13, 2004 8:09 PM Subject: OT: Blown Away Query Ok, this blows me away .. here is the query: INSERT INTO boatOptions (boatID,option) VALUES(13,'x') Simple enough? Well I am getting Syntax Errors with it.. BoatID = Int option = VarChar (75) Am I missing something here ...? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blown Away Query
Yes, just before I recieved your message I figured that one out :) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Friday, August 13, 2004 9:44 PM Subject: Re: Blown Away Query did you not get my reply? ... :) that was my first guess -- option is a reserved word. :) > Figured it out ...DB didn't like "option" .. I changed it > to boatOption and it worked ... go figure.. > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > - Original Message - > From: Paul Giesenhagen > To: CF-Talk > Sent: Friday, August 13, 2004 8:09 PM > Subject: OT: Blown Away Query > Ok, this blows me away .. here is the query: > INSERT INTO boatOptions (boatID,option) VALUES(13,'x') > Simple enough? Well I am getting Syntax Errors with > it.. > BoatID = Int > option = VarChar (75) > Am I missing something here ...? > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blown Away Query
Shoot, I would call :) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Friday, August 13, 2004 9:53 PM Subject: Re: Blown Away Query > Yes, just before I recieved your message I figured that > one out :) > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com Damn I'm good. :) I need to start an ESP tech-support company. :P s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Queries/Arrays/Structs
I have some Queries that I want to convert a record to either an Array or a Struct (different queries, different requirements). What is the easiest way to Query -> Struct and Query -> Array I was about to roll through the resultset and create a struct and array .. but I was curious if there is a "simpler" way. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfhttp showing default info, not my site
Send your code .. I will test it from here. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: joe velez To: CF-Talk Sent: Friday, August 27, 2004 12:45 AM Subject: cfhttp showing default info, not my site when i CFHTTP to my own site instead of seeing my site, i get a THIS IS THE DEFAULT PLESK PAGE .. i can CFHTTP to other sites no problem. any suggestions for a fix? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfhttp showing default info, not my site
Joe, It IS going to your site, but it doesn't like the value of 'thispage' it gives off an error. Place characters around yoru #cfhttp.filecontent# and you will see it in the result .. which is telling me that the code is not producing the error, but the page it is calling. If you change the NAME of your cfhttpparam from pageid to something like X, your site loads up fine ... you will need to check the code on yoru index.cfm file that you are POSTING too. Hope this helps Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: joe velez To: CF-Talk Sent: Friday, August 27, 2004 12:59 AM Subject: Re: cfhttp showing default info, not my site #cfhttp.filecontent# I tried both and (see how set the webpath with a trailing slash) i think its because the site is behind a firewall, and the box cant see itself. but then... how does CFSchedule work every day??? :) and then i try to hard code a different site on the same server, works ok, then i try the same function in their site, and i get the same error. im confused! -joe > Send your code .. I will test it from here. > > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > - Original Message - > From: joe velez > To: CF-Talk > Sent: Friday, August 27, 2004 12:45 AM > Subject: cfhttp showing default info, not my site > > > when i CFHTTP to my own site instead of seeing my site, i get a THIS > IS THE DEFAULT PLESK PAGE .. i can CFHTTP to other sites no problem. > > any suggestions for a fix? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfhttp showing default info, not my site
It worked fine for me .. it pulled up the web hosting site ... Dunno what to tell ya .. sorry! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: joe velez To: CF-Talk Sent: Friday, August 27, 2004 1:14 AM Subject: Re: cfhttp showing default info, not my site ya i saw the value of pageid, but that would at least provide an error, and save the error. im not getting htat, im getting the default page .. but i tried a couple other sites running on a different IP and it works fine for them, so it must jsut be my site for some reason. gotta figure out why. btw, i fixed it to be #thispage# ... but cfhttp to my site on the server itself is not working, but works for other sites. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Weather Feed - Custom Tag
I am looking for weather feeds that I can get for multiple locations and very detailed, ie 5 day forecasts and the link. I am looking for something that is hopefully a custom tag. I have looked at Macromedia and nothing really is current. Any suggestions would be great! (preferrably free) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Weather Feed - Custom Tag
I have signed up for the Weather.com XML feed and am going to create a tag to do the processing ... (unless someone comes up with something better first!) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, September 01, 2004 1:54 PM Subject: Re: Weather Feed - Custom Tag I have been using this same feed for about a year and a half. It has always been reliable except for about a 1 week period that they were down. Funny, someone mentioned to me earlier that our weather component wasnt working then I read this post. So I too would be interested in another provider if someone knows of a good free one. Thanks, David -Original message- From: Charlie Griefer [EMAIL PROTECTED] Date: Wed, 1 Sep 2004 14:19:34 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Weather Feed - Custom Tag > I've used one that's located at > http://www.ejse.com/services/weather_xml_web_services.htm for quite > some time now and have had little to no problems. > > Unfortunately, my site's unavailable at the moment to show you my > implementation...but > > d'oH! > > BREAKING UPDATE ...i was looking at their site to tell you exactly > which service I'm using (they have 4 listed)...and none of them > currently work. They all return "This weather service has been > retired as of 9/1/2004 12:00:00 AM. Please visit > http://www.ejse.com/services/weather_xml_web_services.htm for > information regarding our new weather services." :( > > so i guess it looks like I'm interested in answers to this question too :) > > > On Wed, 1 Sep 2004 13:08:43 -0500, Paul Giesenhagen > <[EMAIL PROTECTED]> wrote: > > I am looking for weather feeds that I can get for multiple locations and very detailed, ie 5 day forecasts and the link. > > > > I am looking for something that is hopefully a custom tag. I have looked at Macromedia and nothing really is current. > > > > Any suggestions would be great! (preferrably free) > > > > Paul Giesenhagen > > QuillDesign > > 417-885-1375 > > http://www.quilldesign.com > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Weather Feed - Custom Tag
Yes, but it is alot of crap that they put together to offer up for free ... no big deal on most of it ... there are services out there that charge alot of $$ per month and you don't have to do any of that. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Adam Haskell To: CF-Talk Sent: Wednesday, September 01, 2004 3:12 PM Subject: Re: Weather Feed - Custom Tag - Only display weather data for one location at a time - Adhere to the data request rules, usage rules, and refresh rates outlined in Section 8 of this Guide - Clearly separate TWCi data from data within a single visual element - Identify that the weather data comes from TWCi and provide a link to the weather.com home page as set forth in Section 9 of this Guide - Provide three promotional links back to weather.com for additional weather information as set forth in Section 9 of this Guide - Be free of charge to your end users - Have fewer than 25,000 active users in any given month Thats a lot of crap you are supposed to do to use it Adam H On Wed, 1 Sep 2004 15:03:49 -0400, Matthew Fusfield <[EMAIL PROTECTED]> wrote: > Weather.com now has free XML feeds, try > http://registration.weather.com/registration/xmloap/step1 > > Matt > > On Wed, 1 Sep 2004 13:08:43 -0500, Paul Giesenhagen > <[EMAIL PROTECTED]> wrote: > > I am looking for weather feeds that I can get for multiple locations and very detailed, ie 5 day forecasts and the link. > > > > I am looking for something that is hopefully a custom tag. I have looked at Macromedia and nothing really is current. > > > > Any suggestions would be great! (preferrably free) > > > > Paul Giesenhagen > > QuillDesign > > 417-885-1375 > > http://www.quilldesign.com > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
XML Testing
How do you test to see if an XML variable is defined or not? I have tried IsDefined, but it errors out. Basically I am testing to see if the XML code has an error block, if everything is fine, this variable is NOT valid #xmlresponse.error.err.xmlText# IF there is a problem, it is and it is the error response code. So what I would like to do is FIRST check to see if this variable exists ... Any suggestions? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Date Records
I need to pull records out that have a date stamp of less than or equal to the past 30 days. My WHERE statement would be what? WHERE lastDateEdited = past 30 days (if LONGER than 30 days, I do not want to include this record into the resultset). Oh CFMX 6.1 and SQL 2000 Thanks in advance. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Return Links (best practice)
What are some of you doing to return people to where they were once they have logged in. I am curious what are some of the best methods to returning users back to where they came from after they log in. Example; user is browsing your website and comes to a form to submit some information. But they have to be logged in as a member first. So instead of showing them the form, you re-direct them to the login page where they can either login or sign up. Also assuming there are MANY places for this type of situation to happen throughout the site. What are some good methods to get them back AFTER they have logged in and/or signed up. Thanks Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Return Links (best practice)
Yes, but that can be unreliable ... but what I am looking for is are you passing this information via what type of variable. url, session, client ect... Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Micha Schopman To: CF-Talk Sent: Tuesday, September 07, 2004 1:34 AM Subject: RE: Return Links (best practice) Save the referrer when locating them to the login page. Use that referrer upon login to relocate again. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Return Links (best practice)
Sometimes servers turn those off but that is not the point of my question, my question is how would are some folks storing and processing this? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Micha Schopman To: CF-Talk Sent: Tuesday, September 07, 2004 1:44 AM Subject: RE: Return Links (best practice) Why would that be unreliable? Yes you can spoof referrers as a client, but they are only used as a relocate target not as a check whether someone is logged in. You can store paths in sessions etc. but you must make sure you update the path on each request, and ignore the setting of the path during the logging procedure. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFTRANSACTION
No, you can only have one datasource per CFTRANSACTION. Would be nice, but it isn't possible. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: vishnu prasad To: CF-Talk Sent: Wednesday, September 15, 2004 11:45 PM Subject: CFTRANSACTION Hi All is it possible to have one CFTRANSACTION for multiple datasource i write the follwing code insert statment insert statment i verify the connection in cf admin ,but when i execute the code i got message as datasource verification failed how can i overcome this [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFTRANSACTION
Without testing it here, are you getting an SQL error? I think SQL doesn't allow you to do this, OR it could be the Driver you are using. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: vishnu prasad To: CF-Talk Sent: Thursday, September 16, 2004 12:05 AM Subject: Re: CFTRANSACTION Hi Paul thks for your response,i think its possible in java is it not possible to have implement tow phase commit in Coldfusion > No, you can only have one datasource per CFTRANSACTION. > > Would be nice, but it isn't possible. > > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > - Original Message - > From: vishnu prasad > To: CF-Talk > Sent: Wednesday, September 15, 2004 11:45 PM > Subject: CFTRANSACTION > > > Hi All > > is it possible to have one CFTRANSACTION for multiple datasource > i write the follwing code > > > > insert statment > > > > insert statment > > > > i verify the connection in cf admin ,but when i execute the code i got > message as datasource verification failed > > how can i overcome this [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFTRANSACTION
That is because TRANSACTIONS are not CF they are somethign your DB uses it is something that DB will do to roll back if there is a problem, it is not a CF issue... You must have your transactions all using the same datasource. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: vishnu prasad To: CF-Talk Sent: Thursday, September 16, 2004 12:26 AM Subject: Re: CFTRANSACTION when i run the query like this its working fine insert statment insert statment but when i put in transcation i got the error insert statment insert statment [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Query of Queries - Repost
I am not sure if this ever made it to the list because I didn't recieve it back myself so here is the repost: I am having trouble with a query of query. Is there a known issue with 0 values in query of queries? I have a result set called getShipping that produces the following result set: getShipping result set == 18|0|Free Shipping 19|15|2nd Day Air 20|20|3 Day Select 22|25|Next Day Air Note: 18|0|Free Shipping, the 0 is the value for shipping. Then I try to run the following query of queries (without ANY other code in between) SELECT code,rate,description FROM getShipping And here is it's result set: (Note the 18//Free Shipping the 0 is now gone. I could write some code to look for the "" and then replace it with a 0 but that seems hacked and wanted to know if I am missing something. Shipping query of queries result set: 18//Free Shipping 19/15/2nd Day Air 20/20/3 Day Select 22/25/Next Day Air Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFML from a DB
If I have a constant variable such as #request.dsn# And I want to enter it into a textarea that inserts it's contents into a database, how do I pull out that information and display it. I want to enter into the textarea Hello, my DSN is "#request.dsn#" And when displayed on the page Hello, my DSN is "someDSN" Right now, if I insert it it outputs Hello, my DSN is "#request.dsn#" I know this is probably simple. Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFML from a DB
Doesn't seem to work. Let me explain alittle more
I add the original information into the text area and save the whole textarea into the db,
then I run a query and output the results
So
INSERT INTO tablename
(content)
VALUES('#form.content#')
Then
SELECT content
FROM tablename
#getContent.content#
It still displays the same. and doesn't show the value of the variable.
Paul Giesenhagen
QuillDesign
- Original Message -
From: Mike Townend
To: CF-Talk
Sent: Monday, April 19, 2004 9:00 AM
Subject: RE: CFML from a DB
Something like
#Evaluate(DE(Form.Text))#
HTH
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 14:53
To: CF-Talk
Subject: CFML from a DB
If I have a constant variable such as #request.dsn#
And I want to enter it into a textarea that inserts it's contents into a
database, how do I pull out that information and display it.
I want to enter into the textarea
Hello, my DSN is "#request.dsn#"
And when displayed on the page
Hello, my DSN is "someDSN"
Right now, if I insert it it outputs
Hello, my DSN is "#request.dsn#"
I know this is probably simple.
Thanks
Paul Giesenhagen
QuillDesign
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFMX for sale
Adam, I agree with your comments completely! Paul Giesenhagen QuillDesign - Original Message - From: Adrocknaphobia To: CF-Talk Sent: Tuesday, April 20, 2004 3:39 PM Subject: Re: CFMX for sale Susan, You should sell your copy guilt free. It's your copy and yours alone, what you do with it is your business. No, I'm not intrested in buying it. It's just no one else's bizness what you do with it. I think it's commendable that you offered through this list to developers who will use it to it's full potential. -adam > -Original Message- > From: Ryan Hartwich [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 20, 2004 06:18 PM > To: 'CF-Talk' > Subject: Re: CFMX for sale > > Susan, > > If you won the raffle via a CF or Macromedia user group, I urge you to please reconsider your sale. Sure, getting some $ for it is nice, but I'm pretty sure that MM did NOT intend for the winners to be reselling the software on the open market. > > If users start selling the software that MM gives us to promote the groups, we seriously run the risk of being cut off. They (our sponsors at MM) have to fight to get us the software as it is. > > If you are unable to use the CF software and it came from a user group, please contact your user group manager and maybe we can work out a way to swap the software for something that will be of use to you. > > Ryan, Kansas City CFUG Manager > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Getting the id of the row you just inserted...
I usually do not auto number, I always insert a UUI! Before my inserts: insert. Then variables.newid is always available. Paul Giesenhagen QuillDesign Home of SiteDirector - Commerce Builder http://ww.quilldesign.com > It seems to me that there are three basic ways to get the id of the row you > just inserted. > 1) @@identity > and > 2) cflocking the insert statement and the select max(id) statement. > and > 3) qualifying the select max(id) statement to avoid problems caused by > multiple threads. > > I'm curious which method people use and which they find to be the best. > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Final Check through
Mike, 1) Make sure blank form fields are accounted for 2) Make sure taxes and shipping and total price all total correctly 3) Any secure information being sent via email? 4) Chck to make sure people cannot hack into your system to obtain users information (cc numbers ect..) 5) Cross your fingers!! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I know this may not be very good, but I want to make sure I do this right. I am just about to go live with a site with the whole shopping cart thing, Its all ready but it being my first cart I was wondering if anyone had any final checks just to make sure...like security and dumb users. I am pretty sure I have gone over everything and had many people test it, It would just be nice to lean on everyone and all your experience. > > thanks > mike > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP
This information will pull weather data from accuweather.com for Dryden Ontario (Canada) http://www.accuweather.com/adcbin/intlocal_index?wxcity2=DRYDEN&wxcount ry=CA;ON&metric=0" RESOLVEUL="true" throwonerror="true"> #variables.final_content# Hope this helps... take a look at the orginial url and it's content and it will hopefully make more sense... basically the whole html file is retrieved, and you just look for a starting point and an ending point and strip out everything outside of that. Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I recently made a simple page using CFHTTP that pulled a webpage and > displayed it. What I heard could be done with CFHTTP was you could pull > a page and have CF look at the source and only display certain parts > that are between a start and end point that you specify. Could someone > give me an example of this? > > Thanks, > Jim Vosika > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP
The example below basically is doing that, it is just taking out the middle area. You need to find distinct places within the code to decern starting and ending points. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I need help with taking one page apart using CFHTTP. > Actually I need to take the page on 3 parts, like header, middle, and > footer, based on comments. > Is somewone had to do similar thing? > Could anybody give asample of it? > Thanks a lot. > Max. > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 30, 2002 1:11 AM > Subject: Re: CFHTTP > > > > This information will pull weather data from accuweather.com for Dryden > > Ontario (Canada) > > > > > > > > > > > > > > > > URL="http://www.accuweather.com/adcbin/intlocal_index?wxcity2=DRYDEN&wxcount > > ry=CA;ON&metric=0" RESOLVEUL="true" throwonerror="true"> > > > > > > > > > > > >> variables.orginal_content)> > > > >> variables.orginal_content, variables.edit_content)> > > > >> variables.edit_content, > > variables.final_edit_content-198-variables.edit_content)> > > > > > > > > #variables.final_content# > > > > > > Hope this helps... take a look at the orginial url and it's content and it > > will hopefully make more sense... basically the whole html file is > > retrieved, and you just look for a starting point and an ending point and > > strip out everything outside of that. > > > > Good Luck > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector - Commerce Builder > > > > > > > I recently made a simple page using CFHTTP that pulled a webpage and > > > displayed it. What I heard could be done with CFHTTP was you could pull > > > a page and have CF look at the source and only display certain parts > > > that are between a start and end point that you specify. Could someone > > > give me an example of this? > > > > > > Thanks, > > > Jim Vosika > > > > > > > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: File upload trouble
In your form are you specifiying multipart/form-data?
It needs to know that there is a file
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
> Can anyone tell me why I get an error on this code?
>
>action="UPLOAD"
> filefield="File2Upload"
> destination="G:\Websites_CF\BerresBros\Admin\"
> attributes="readOnly">
>
> I get the following error:
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> Error in CFFILE tag
>
> The form field specified in the CFFILE tag ('FILE2UPLOAD') does not
contain
> an uploaded file. Please be sure that you have specified the correct form
> field name.
>
> The error occurred while processing an element with a general identifier
of
> (CFFILE), occupying document position (38:9) to (42:31) in the template
file
> G:\Websites_CF\BerresBros\Admin\File_Upload.cfm.
>
>
> Date/Time: 01/30/02 10:22:43
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Q312461)
> Remote Address: 209.234.84.35
> HTTP Referrer: http://www.berresbrothers.com/Admin/File_Upload.cfm
>
> --
--
>
>
>
> and my debug information is as follows:
>
> Parameters
> Form Fields:
>
> FIELDNAMES=FILE2UPLOAD,UPLDFILE
> FILE2UPLOAD=C:\My Documents\Test_Newsletter.htm
> UPLDFILE=Upload File to System
>
> Any immediate help on this would be GREATLY appreciated.
> I know that the MM debate is awfully important and all.
>
> TIA
>
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
>
> CONFIDENTIALITY NOTICE
> The information contained in this e-mail is intended only for the use of
the
> individual or entity to which it is addressed. This e-mail may contain
> information that is privileged, confidential, and/or personal. If the
reader
> of this message is not the intended recipient (or the employee or agent
> responsible to deliver it to the intended recipient), you are hereby
> notified that any dissemination, distribution, or copying of this
> communication is prohibited.
> If you have received this communication in error, please notify us at the
> email listed above.
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio 5 Downward Compatible?
Yup, It is independent .. .but the help topics may be alittle off ... new features and such... Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Jeff Stevens" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 30, 2002 11:45 PM Subject: CF Studio 5 Downward Compatible? > I want to upgrade but I have some sites still using CF 4.x. Will Studio > work with previous versions of CF. > > Thank You > > > > _ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The darndest time w/ Cookies. Actually form checking.
If you are setting a CFCOOKIE, you have to stop the page. Are you putting a
CFLOCATION or serverside redirecting them after you set the cookie? If you
are then the cookie is not setting.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - CommerceBuilder
> I am having the hardest time setting a cookie. I think it is actually in
> testing for the form field.
>
> Simple login application.
> -User comes to page
> -gets authorized
> -If "remember me" is checked, set a cookie
>
> Here is the code for setting the cookie.
>
>
>
>
>
>
> alert("Hey set a cookie will you!")
>For testing of course
>
>
>
> The form field looks like this
> face="Tahoma"> Remember Me
>
> I have tried everything I can think of. I have read 3 diferent examples
of
> this exact thing. Could it be that I am using the cf4.5 svr that comes w/
> cfstudio, and not on a real live server? I know that some things do not
> function properly on this version of the server software, but I don't know
> which things.
>
> Thanks
>
> Chris Luksha
> IS/Web Programmer
> Helmers Publishing, Inc.
> Publishers of
> Desktop Engineering and
> Supply Chain Systems Magazines
> (603)924-9631 ext. 267
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The darndest time w/ Cookies. Actually form checking.
I do this alot:
and then refresh them elsewhere:
you can set content=".1" for pretty fast refresh rate.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
> It wouls seem the cflocation could be the key here. What is my way
> around
> this?
> I remember somewhere there being a way to send user to another page via
> javascript. Anyone remember this? Can I pass the session.sendmeto
> variable
> I created?
>
> Here is the full code for that section
>
>
>
>
>
>
>
>
> EXPIRES="NEVER">
>
>
>
>
>
>
>
>
>
>
> url="#getfilefrompath(getbasetemplatepath())#?message=#urlencodedfor
> mat(mess
> age)#" ADDTOKEN="no">
>
>
>
>
> -Original Message-
> From: David Schmidt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 3:55 PM
> To: CF-Talk
> Subject: RE: The darndest time w/ Cookies. Actually form checking.
> Importance: High
>
>
> Chris,
>
> Make sure you do not do any cflocation's after you set your cookie.
> This
> is
> a pretty common mistake, particulary with authentication routines.
> Cooki
> es
> are only set when the browser receives the completed page.
>
> David Schmidt
>
>
> -Original Message-
> From: Chris Luksha [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 12:39 PM
> To: CF-Talk
> Subject: The darndest time w/ Cookies. Actually form checking.
>
>
> I apologize if this ends up getting posted a couple times. I haven't
> se
> en
> the first posting in over an hour and I got a bounceback message from
> the
> second attempt. So here is the third...
>
> I am having the hardest time setting a cookie. I think it is actually
> in
> testing for the form field.
>
> Simple login application.
> -User comes to page
> -gets authorized
> -If "remember me" is checked, set a cookie
>
> Here is the code for setting the cookie.
>
>
>
>
>
>
> alert("Hey set a cookie will you!")
>For testing of course
>
>
>
> The form field looks like this
> face="Tahoma"> Remember Me
>
> I have tried everything I can think of. I have read 3 diferent
> examples
> of
> this exact thing. Could it be that I am using the cf4.5 svr that comes
> w
> /
> cfstudio, and not on a real live server? I know that some things do
> not
> function properly on this version of the server software, but I don't
> kno
> w
> which things.
>
> Thanks
>
>
>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isnumeric trouble
I am shooting in the dark here .. could the ' quotes around it be giving you fits? Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > This is frustrating. I am checking to make sure a value is numeric. when I use NOt isnumeric it runs through the query and it accepts letters. If I take it away it won't go through the query. Almost like its backwards. Plus it thinks of numbers and letters are the same. Am I doing something wrong? > > > > > > > > DELETE > FROM tblshopping_cart > WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX# > > UPDATE tblshopping_cart > SET QUANTITY_S = '#LISTGETAT(Q, variables.STEP)#' > WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX# > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Print Friendly Web Site
It all depends on who your customer base is. Do you want the homepage to be printable .. does it need to be printable. Is the person who is paying the bill's wanting it to be printable. We have an issue with our pages not being printable as well, we decided that it was more important to have all of our content laid out in 800x600 than to worry about it being printed. We have also made sure that NOTHING on the right hand side is important enough that if it was printed it wouldn't matter if it showed up or not. Gives you something to think about! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I'm working with a Web site obtimized for 800x600 displays. As it stands, > pages are horizontally cropping on a printout. This has concerned one of my > managers. I'm not too bothered because pages that are more likely to > printed (press releases, for instance) have seperate "print friendly" > versions (stripping out logos, navigation, etc...). Who really prints the > homepage of a Web site? :) > > Is it a bad thing to have printouts crop like that? Should good designs > accomodate printers? > > > Eric Carlisle > Web Site Developer > Progress Energy IT Systems Delivery > E-mail: [EMAIL PROTECTED] > Phone: (919) 546-4739 > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practice on using/optimizing cfoutput and cfloops
is much faster than cfloop always try to use cfoutput when you can. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I am wondering if anyone can advise if one practice (below) is more > efficient than the other. > > > Practice 1: Enclosing every instance on #variables# in cfoutput tags > > > > #query_variable# > > > > > > VERSUS > > > > Practice 2: Enclosing the entire code in a single cfoutput and use cfloop > when necessary > > > > > #query_variable# > > > > > > > Any advise to demystify any 'performance penalties' would be appreciated. > > > > Thanks, > > Michael > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cookie error
I am dynamically creating cookies and getting the following error. I create the cookie by setting a uuid, then strip out everything but the first part of the uuid Example: When i do that, I then set a cookie such as But then on another page, I check for that cookie and get the following error. . Here is the error: Parameter 1 of function IsDefined which is now "cookie.00A27221" must be a syntactically valid variable name What is the syntax problem .. do cookie names not like either alpha or numeric characters? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cookie error
Thanks, that is what I figured out ...great minds huh? Thanks again Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > A variable name cannot begin with a digit. maybe you should put an append an alpha character to the beginning of the cookie name. > > HTH, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 4:09 PM > Subject: cookie error > > > > I am dynamically creating cookies and getting the following error. > > > > I create the cookie by setting a uuid, then strip out everything but the > > first part of the uuid > > > > Example: > > > > > > > > > > > > > > When i do that, I then set a cookie such as > name="#Variables.cookieid#" value="1"> > > > > But then on another page, I check for that cookie and get the following > > error. > > > > > > . > > > > Here is the error: > > Parameter 1 of function IsDefined which is now "cookie.00A27221" must be a > > syntactically valid variable name > > > > > > What is the syntax problem .. do cookie names not like either alpha or > > numeric characters? > > > > Thanks > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector - Commerce Builder > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Damn it's quiet
I would agree, you guys have no life!! My wife and kids are gone for a week .. so I can finish up a new version of our Application Hey wait ... I have no life eitherugh! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I am looking for some help online right now deciding how to make Informal > Scenarios into Class diagrams and use case models for my software > engineering project. :-) > > I think I win the battle of no life. My whole dorm is at the bar listening > to Irish drinking songs. > > :-) > > Mike > > > - Original Message - > From: "David Schmidt" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 10:31 PM > Subject: Re: Damn it's quiet > > > > I'm just having fun creating an online game for the kids using CF. > > > > God I need a life! > > > > > > David Schmidt > > > > > > > > - Original Message - > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, February 01, 2002 7:30 PM > > Subject: Re: Damn it's quiet > > > > > > > Well if everyone on the list is eastcoasters, then I know who is hoggin > > > all the CF Jobs.Bogarts! > > > > > > Poor westcoaster :-( > > > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > > > BSD. We don't believe this to be a coincidence. > > > > > > > > > > > > Doug Brown > > > - Original Message - > > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Friday, February 01, 2002 4:02 PM > > > Subject: Damn it's quiet > > > > > > > > > > Just thought I would mention that!!! > > > > > > > > > > > > > > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > > > > > > > BSD. We don't believe this to be a coincidence. > > > > > > > > > > > > > > > > Doug Brown > > > > > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Damn it's quiet
I'll host it!! someone buys it!maybe weekendloosers.com Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Michael T. Tangorre" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 9:36 PM Subject: Re: Damn it's quiet > I think we should all combine forces and create a site called > FridayNightLosers.COM > and work on it every friday night.. I bet we could finihs it in about a week > :-) > > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 10:35 PM > Subject: Re: Damn it's quiet > > > > I would agree, you guys have no life!! > > > > My wife and kids are gone for a week .. so I can finish up a new version > of > > our Application > > > > Hey wait ... I have no life eitherugh! > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector - Commerce Builder > > > > > > > I am looking for some help online right now deciding how to make > Informal > > > Scenarios into Class diagrams and use case models for my software > > > engineering project. :-) > > > > > > I think I win the battle of no life. My whole dorm is at the bar > listening > > > to Irish drinking songs. > > > > > > :-) > > > > > > Mike > > > > > > > > > - Original Message - > > > From: "David Schmidt" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Friday, February 01, 2002 10:31 PM > > > Subject: Re: Damn it's quiet > > > > > > > > > > I'm just having fun creating an online game for the kids using CF. > > > > > > > > God I need a life! > > > > > > > > > > > > David Schmidt > > > > > > > > > > > > > > > > - Original Message - > > > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Friday, February 01, 2002 7:30 PM > > > > Subject: Re: Damn it's quiet > > > > > > > > > > > > > Well if everyone on the list is eastcoasters, then I know who is > > hoggin > > > > > all the CF Jobs.Bogarts! > > > > > > > > > > Poor westcoaster :-( > > > > > > > > > > > > > > > There are two major products that come out of Berkeley: LSD and > [Unix] > > > > > BSD. We don't believe this to be a coincidence. > > > > > > > > > > > > > > > > > > > > Doug Brown > > > > > - Original Message - > > > > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Friday, February 01, 2002 4:02 PM > > > > > Subject: Damn it's quiet > > > > > > > > > > > > > > > > Just thought I would mention that!!! > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > There are two major products that come out of Berkeley: LSD and > > [Unix] > > > > > > > > > > > BSD. We don't believe this to be a coincidence. > > > > > > > > > > > > > > > > > > > > > > > > Doug Brown > > > > > > > > > > > > > > > > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Damn it's quiet
Sad thing, I was born in St. Joseph Missouri (where the pony express began and Jessie James ended), moved to California and now back in Missouri ... Southern ... close to Arkansas.. whoo-hoo! Did you know that the toothbrush had to be invented in Arkansas .. if it were invented anywhere else it would have been called the TEETHbrush. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > I live in California, but grew up in North Carolina. So I will have to > agree that wal-mart is the place to be. :-) isnt much else there!!! > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > - Original Message - > From: "John Cummings" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 9:47 PM > Subject: RE: Damn it's quiet > > > > I've said it before and I'll say it again - the best way to survive a > > downtick in the economy is to move to an area that never had an > uptick. > > You don't even feel a bump. > > > > And by the way Keen, just because you're a CA surfer-dude now doesn't > > mean you can hide your hilljack roots. :) > > > > > > -Original Message- > > From: Keen [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, February 02, 2002 12:41 AM > > To: CF-Talk > > Subject: RE: Damn it's quiet > > > > Hey for someone who lives in WV like you, going to Wal-Mart is what > life > > is > > all about :-P > > > > -Original Message- > > From: John Cummings [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 8:45 PM > > To: CF-Talk > > Subject: RE: Damn it's quiet > > > > > > Nothing positive to contribute to the discussion - just couldn't enjoy > > reading the thread while still trying to hide the fact that I am > indeed > > quite the weekend loser as well. > > > > Oh well - going to Wal-Mart in the morning, so I do have that to look > > forward to. :) > > > > > > -Original Message- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 11:48 PM > > To: CF-Talk > > Subject: Re: Damn it's quiet > > > > bitch.hahahahahahhaha > > > > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > > BSD. We don't believe this to be a coincidence. > > > > > > > > Doug Brown > > - Original Message - > > From: "Brendan Avery" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, February 01, 2002 8:26 PM > > Subject: RE: Damn it's quiet > > > > > > > my friend mike used to work at macromedia (before layoffs) -- his > job > > title > > > on the mm business card actually read: "bitch" > > > > > > > -Original Message- > > > > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] > > > > Sent: Friday, February 01, 2002 20:19 > > > > To: CF-Talk > > > > Subject: Re: Damn it's quiet > > > > > > > > > > > > Yeah.. > > > > well i actually make $6.75 and my official title is Web > > > > Programming Manager > > > > A.K.A. Web Team Slave. :-) > > > > > > > > I did get a fully licensed, legal copy of CF Studio since > > > > version 4 :-) > > > > Although Id rather make more per hour and buy it myself. > > > > > > > > > > > > - Original Message - > > > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Friday, February 01, 2002 11:24 PM > > > > Subject: Re: Damn it's quiet > > > > > > > > > > > > > Och! I make that on unemployment right now geeesh. > > > > > > > > > > > > > > > > > > > > > > > > > There are two major products that come out of Berkeley: LSD > > > > and [Unix] > > > > > BSD. We don't believe this to be a coincidence. > > > > > > > > > > > > > > > > > > > > Doug Brown > > > > > - Original Message - > > > > > From: "Mich
Re: Setting Query results as a Variable
Ok so that was much easier than how I went around it .. :) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Use to grab the output and save it in a variable, or if > you need a single column and want it as a list use ValueList() or > QuotedValueList(). > > --- Ben > > > -Original Message- > From: Jim Vosika [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 2:18 PM > To: CF-Talk > Subject: Setting Query results as a Variable > > > I am querying my Database and getting back multiple results, as you with > any query. I would like to put those results into a Variable to be used > in a CFFILE function like: OUTPUT="#MyQueryVariable#"> > > Here is my query if it matters: > > SELECT * > FROM RNI > WHERE rniPID=225221 > ORDER by rniSection, rniSortOrder; > > > #rniContents# - This outputs all > the rows as needed. > > I tried setting the variable using: > and then > outputting the variable in the CFFILE tag but that seemed to only return > the first row of results. > > I also tried OUTPUT="#QueryRNI.rnoContents#"> This also only gave back one row of > results. > > Any suggestions on where to go from here? Is this a Query of Query's > thing? I have never used QofQ before but I didn't think it was the > solution. > > Thanks, > Jim Vosika > SoftwareSuperMall.Com > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Outputting issue
Ok, I have a pretty basic question, but haven't used it much in the past so I am needing alittle help. I have a query: Select header,type,id,name from items Each item coming from the above query has a header value, and I want to display the results as such: HEADER1 ITEM 1 ITEM 2 ITEM 3 HEADER2 ITEM 4 ITEM 5 ITEM 6 HEADER 3 blah blah How do I do this without multiple queries... Thanks (I know it's basic) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outputting issue - RE-DO
Sorry, my original post didn't make my output very clear Ok, I have a pretty basic question, but haven't used it much in the past so I am needing alittle help. I have a query: Select header,type,id,name from items Each item coming from the above query has a header value, and I want to display the results as such: EACH row has a header, and possibly different header values .. thus I want to group by header and display the header value (one for each group of items) HEADER1 ID/type/name2 ID/type/name 3 HEADER2 ID/type/name 4 ID/type/name 5 ID/type/name 6 HEADER 3 blah blah How do I do this without multiple queries... Thanks (I know it's basic) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML in Forms throwing page off
Try wrapping the output in #htmleditformat(form.content)# See if that works for ya. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Jim Vosika" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 2:31 PM Subject: HTML in Forms throwing page off > I'm just handling cosmetic problems on my page I have a form that I > need to enter HTML code into but it throws my page off. Because I > usually start by entering some 's which poses a problem. Is there > some sort of tag I can wrap around the value so it so it doesn't do > that? > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outputting issue
What if I cannot do an OUTPUT query="getitems" (already inside of an output) . - Original Message - From: "Garza, Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 2:35 PM Subject: RE: Outputting issue > Try using the group attribute in your CFOUTPUT. > > > #Header# > > #Type# -- #id# -- #Name# > > > > You should also use an order by clause in your select statement... > > Jeff Garza > Lead Developer/Webmaster > Spectrum Astro, Inc. > 480.892.8200 > [EMAIL PROTECTED] > http://www.spectrumastro.com > > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 1:30 PM > To: CF-Talk > Subject: Outputting issue > > > Ok, I have a pretty basic question, but haven't used it much in the past so > I am needing alittle help. > > I have a query: > > > Select header,type,id,name > from items > > > Each item coming from the above query has a header value, and I want to > display the results as such: > > HEADER1 > ITEM 1 > ITEM 2 > ITEM 3 > HEADER2 > ITEM 4 > ITEM 5 > ITEM 6 > HEADER 3 > blah blah > > How do I do this without multiple queries... > > Thanks (I know it's basic) > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom Tags
I have a question -- looking for a better way of doing things: Currently, I am using custom tags to run queries, and take the various bits of information and re-package it into queries, THEN packaging the results up into a WDDX Packet. Outside of the Custom Tag I am unpackaging the WDDX Packet (which is the query that I built in the Custom Tag) and then running my outputs on it to get the results. This seems like alot of jumping back and forth to get to the result Is it possible to do this differently? My whole goal is to run some pretty nasty queries/joins/hoops and bumps inside the custom tag, so the html group can then just run standard cfoutputs and/or cfloops to output the data. Anyone have any words of wisdom that might be a better solution? Thanks Paul Giesenahgen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Find & Replace on #cfhttp.filecontent#
that should do it for you. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Is there a way to do a find and replace function on the code returned > from doing a cfhttp? I simply need to change a number every place that > it appears > > Thanks. > Jim Vosika > SoftwareSuperMall.Com > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: date format
This should do the trick! #DateFormat(Now(), " dd, ")# Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 8:03 AM Subject: date format > Hello, > > I know this is an easy one, but I can't get it to work. How can I have > the current date display as Month, Day, Year? The DateFormat parameter > doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, > ")# > > Any help appreciated. Thanks. > > Robert O. > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating Database Date using Coldfusion
Could it be the ' around the the formatted date in your update?
SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
> Hi
>
> I am trying to update records in my oracle database table and am receiving
> the following error
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> Oracle Error Code = 1747
>
> ORA-01747: invalid user.table.column, table.column, or column
> specification
>
>
>
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (33:1) to (33:60).
>
>
>
>
>
> Any ideas on what is causing this from the code below which I am using to
> update the data...
>
>
>
>
> UPDATE whatson
>
> SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
> eventexpires = TO_DATE ('#format_date#', 'MM/DD/'),
>
> location ='#form.location#',
>
> longtitle ='#form.longtitle#',
> telephone ='#form.telephone#',
> email ='#form.email#',
> url ='#form.url#',
> eventsummary ='#form.eventsummary#',
>
>
> '#file.serverFile#'NULL
>
>
> WHERE eventid = #form.eventid#
>
>
>
>
> DECLARE new_text LONG;
> BEGIN
> new_text := '#content#';
> UPDATE whatson
> SET description = new_text
> WHERE eventid = #eventid# and location = '#location#' and homepagetitle =
> '#homepagetitle#' and telephone = '#telephone#' and email = '#email#' and
> longtitle = '#longtitle#' and url = '#url#' and imgsrc = '#imgsrc#' and
> eventsummary = '#eventsummary#' and eventexpires =
> TO_DATE('#format_date#', 'MM/DD/') and eventdate =
> TO_DATE('#formatted_date#', 'MM/DD/');
> END;
>
>
>
>
> Ian
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Passing HTML to a FORM
I have a developer that is having a tough time with an HTML FORM and submitting HTML text via hidden form fields. He has a form that has two parts, one an html designer inputs HTML text into a textarea field. The other part of the form, accepts product ids and then the system will generate default HTML text for those product id's. Now, both of these sniplets of HTML have to be passed over from our Cold Fusion Servers to the Java Servers via form submit. But it is breaking. What is the best way to send over HTML code via hidden form fields to another application that needs that HTML text. I am sure there is an easy answer... Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Load Testing
Try http://www.websitegarage.com I haven't used it in alooong while so I am not sure how reliable they are (looks like they are with Yahoo now). Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Anyone out there know of a web site where you can enter your URL and get > stats on page load and size etc? I used to know one - but I've forgotten > it. Also, does anyone have a recommendation for a -FREE- load tester > (hopefully something you have used yourself). Thanks. > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfhttp / cfhttparam waaaait
Quick question, If I am doing a cfhttp and passing some for variables via cfhttparam, will my code wait for the server to respond before it continues on within the code? (If the responding server has to do some chugin and it could take 1-2 minutes) I need to wait for a response will it? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfhttp / cfhttparam waaaait
Very much so ... that is what I figured, but since I have not used it a bunch I just wanted to verify Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Since ColdFusion processes code from top to bottom, it would make sense that > the CFHTTP call would have to finish first. > > Think about it, if you run a query, the rest of the page doesn't process > until the query runs. Otherwise, any resulting query output could be run > before obtaining the query results, which you throw an error. > > Note that CFFLUSH only flushes what *has already processed*. > > Hope this helps, > Dave. > > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, February 05, 2002 11:03 PM > Subject: cfhttp / cfhttparam wit > > > > Quick question, > > > > If I am doing a cfhttp and passing some for variables via cfhttparam, will > > my code wait for the server to respond before it continues on within the > > code? (If the responding server has to do some chugin and it could take > 1-2 > > minutes) I need to wait for a response will it? > > > > Thanks > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector - Commerce Builder > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Location dependence
Though it is not included by default, SiteDirector is open source and adding something like that is not too difficult. We had one client who wanted all items in one particular city to have free shipping ... doing the same thing with product pricing would be simple. If you just need a shopping cart only (without the store building part) QD Cart is also open source and is the same shopping cart (for the most part) that ships with SiteDirector... http://www.quilldesign.com Let me know if you have any questions Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Parker, Kevin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 12:02 AM Subject: Location dependence > Does anyone know of any of the CF based store apps that can handle different > prices based on location of the customer (and I don't mean postal rates). > > In a nutshell, people who are resident in this state (South Australia) are > eligible for certain items free, whereas outside the state there is a fee. > We capture the state as part of the order form on a lookup list so we can > determine their origin. > > > ** > > Kevin Parker > Web Services Manager > WorkCover Corporation > > [EMAIL PROTECTED] > www.workcover.com > > p: 08 82332548 > f: 08 82332000 > m: 0418 806 166 > > ** > > > > > This e-mail is intended for the use of the addressee only. It may > contain information that is protected by legislated confidentiality > and/or is legally privileged. If you are not the intended recipient you > are prohibited from disseminating, distributing or copying this e-mail. > > Any opinion expressed in this e-mail may not necessarily be that of the > WorkCover Corporation of South Australia. Although precautions have > been taken, the sender cannot warrant that this e-mail or any files > transmitted with it are free of viruses or any other defect. > > If you have received this e-mail in error, please notify the sender > immediately by return e-mail and destroy the original e-mail and any > copies. > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Generic Hosting Contract
Try http://www.quickforms.net they have some useful generic contracts and such. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Does anyone have a generic hosting contract they would mind sharing? > > Just the basic things covering liability, loss of business, etc. > > Thanks, > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Neo / AS400
Anyone on this list on the beta team for the beta 1 of neo that is testing on an AS400? Would be interested in knowing if anyone is up for that? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [2] Jeremy Allaire interview on DevX
That spooks me! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 11:25 AM Subject: RE: [2] Jeremy Allaire interview on DevX > > It's called consistency, and that is the driving force behind > > toolkits in the first place, it is much easier for the user > > if one programs "checkbox" > > looks and works the same as other program's checkboxes. Not > > to mention that it vastly increases code reuse and helps to > > enforce a modular > > approach for the engineer. Flash isn't designed to be an > > interface toolkit, it is designed to deliver animation and > > whizzy interactive things, let it do > > what it's best at, leave the interface display to the various > > libraries designed to be interface toolkits (and in the case > > of web sites, to the HTML). > > > this sounds scarily like this argument: > > It's called consistency, and that's the driving force behind command-lines > in the first place, it is much easier for the user if one types "ls" and it > works the same as other shell's ls. Not to mention it vastly increases > efficiency and helps to enforce a standard look and feel for the engineer. > GUI's aren't meant to run real operating systems, they are designed to > deliver icons for unbright users and whizzy interactive things, let it do > what it's best at, leave the real applications to the various command-lines > and keep it under the hood. > > > Not trying to put words in your mouth, just pointing out similarities in > your argument. > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QueryNew - order by
Quick question, I am creating a query with QueryNew ... is there anyway to do an order by type action to a CF created query? (I do not want to use a Query of Queries... I need something supported for v4.5 + Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QueryNew - order by
Hint on how you would write the routine? I can't really picture it in my head... a hint will probably do the trick :) Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 9:38 PM Subject: RE: QueryNew - order by > > Quick question, I am creating a query with QueryNew ... is > > there anyway to do an order by type action to a CF created > > query? (I do not want to use a Query of Queries... I need > > something supported for v4.5 + > > Not directly, but there's nothing to stop you from reordering it yourself > (you could do this with any query, not just ones created with QueryNew, > though). You'd have to build your own sort routine, which would loop through > the query object and "reorder" rows. You'd probably want to have your > routine build a new query object. > > I wouldn't be surprised if there was a custom tag available for this > already, but if there isn't, it shouldn't take more than a few minutes to > write, I'd guess. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled Events
Without alot of thought .. but something you might investigate ... It will create scheduled events .. Create a master application that will do a lookup on your database and find out how many records you have .. (say 10,000). Have this master application then create 20 (20x500 = 10,000), scheduled events in the cf scheduler pointing to another application that will process your 500 rows... with say URL parameters of startrows=1, startrows=501 ect.. So at 2AM, the master app runs and creates the 20 events. ... those twenty events looks something like this: http://www.woohoo.com/events/runme.cfm?startrows=1 http://www.woohoo.com/events/runme.cfm?startrows=501 http://www.woohoo.com/events/runme.cfm?startrows=1001 ect... Oh and when you set they dynamic scheduled events, have them separated however long you want ... Dunno if that is feasible .. but just a thought! Good Luck and let us know how it goes Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 10:29 PM Subject: Scheduled Events > I need to accomplish the following but am not sure how: > > I have a template scheduled to run that processes records in a db in blocks > of 500. (Each record is marked as it is processed) > > After the template has processed its 500 records I would like the template > to "sleep" for two minutes and then reload itself. I don't want to use a > counter since that will eat up processor and memory. > > Any suggestions for the reload and wait? > > Thx, > Duane > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Escaping characters
Same way ... double quotes ""640"" Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Jim Vosika" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 10:34 PM Subject: Escaping characters > Earlier Ben Forta told me that to escape a character like in: > > bgcolor=#ff width=1>", " new code ", "ALL")> > > that I needed to change #FF to ##FF so it doesn't think it is a > variable. Now I am trying to replace How do I work > around the quotes? > > Thanks, > Jim Vosika > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled Events
Oh ... and have your master application create a final app that will run last that deletes all the dynamically created events... (good cleanup). Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 10:29 PM Subject: Scheduled Events > I need to accomplish the following but am not sure how: > > I have a template scheduled to run that processes records in a db in blocks > of 500. (Each record is marked as it is processed) > > After the template has processed its 500 records I would like the template > to "sleep" for two minutes and then reload itself. I don't want to use a > counter since that will eat up processor and memory. > > Any suggestions for the reload and wait? > > Thx, > Duane > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Random row from SQL
We used the code below to get random products out of the database select * from osprods output code here... I think this might help you out... let me know Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 1:30 PM Subject: Random row from SQL > A while back someone posted some code to generate a random number between > two numbers using SQL. I'd like to be able to do that. I want to be able > to return a random row from among rows in an ad database. Does anyone have > ideas on how this might be accomplished? > > Mark > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX
Some may not like the way I use one implementation of WDDX, but it works really well with variable databases... Here is an article on an "other" way to use WDDX. http://www.quilldesign.com/developer/knowledge.cfm?mode=view&owner=209D3EA7- 3585-4DF0-A2C0DE72865FF804 It's not for everyone, but it might perk some thoughts! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > > I'm not sure if this is OT or not but here goes... > > > > Why would I use WDDX instead of just using straight XML? > > -there are SEVERAL good parsers out there. > > -The javascript that it takes to create the "packets" is not that > complex. > > -The "packets" aren't really any kind of packets their just strings > that > are parsed...XML? > > and more... > > > > I actually am interested in using it and I have no direct quams with > using > WDDX but why would I use it when we have an XML framework already > built for other applications? > > > > Thanks- > > Savan > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX
Common' now "ewww" that makes it sound so bad ... it has been working great for us ... (building content sites http://www.outdoorsite.com) and other sites. If you keep your most commonly needed data outside (or in both places), it doesn't effect too much if at all. Since we use generic database structures it really benefits with our design... It can be helpful to others who have a particular need for it.. The article is a suggestion to let people know another way to do things. It isn't for everyone and it has it's drawbacks (and it's plus's). Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 4:49 PM Subject: RE: WDDX > > Here is an article on an "other" way to use WDDX. > > > > http://www.quilldesign.com/developer/knowledge.cfm?mode=view&o > > wner=209D3EA7-3585-4DF0-A2C0DE72865FF804 > > > > It's not for everyone, but it might perk some thoughts! > > Ewww. That's what Spectra does, you know. In any case, the advantages of > relational databases are discarded when you do this - you're effectively > denormalizing your data. In general, within transactional applications, this > is a very bad, bad thing, although it does potentially have some appeal for > content-management apps. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam - order of where/and
I read an article by Ben Forta in CFDJ about using I wanted to test it out, but had a question, well actually two questions. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the and clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
If you are wanting the session to END, just (Wrap it in cflock EXCLUSIVE) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > Hi,All: > > I know you can set time out for a session variable by changing the > default value in CF administration, but can you time out a session > variable manually? For example, if the user clicks a button called > "logout", then the next page sets the session expire or time out. > > > Nathan > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
Steve's dumps the session totally and my example keeps the session, but drops anything in it. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Nathan Chen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 10:48 PM Subject: Re: simple question - how do you manually time out a session variable > Thank you, Paul and Steve, for your help. > > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 14, 2002 9:31 PM > Subject: Re: simple question - how do you manually time out a session > variable > > > > If you are wanting the session to END, just > > > > > > > > (Wrap it in cflock EXCLUSIVE) > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector - Commerce Builder > > > > > > > Hi,All: > > > > > > I know you can set time out for a session variable by changing the > > > default value in CF administration, but can you time out a session > > > variable manually? For example, if the user clicks a button called > > > "logout", then the next page sets the session expire or time out. > > > > > > > > > Nathan > > > > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
I agree ... (didn't actually disagree) ..
does about the same thing and IsDefined...
I just happen to be working with sessions at that time, and that is one w
ay
I was clearing it out .. but I didn't want to loose the session either ...
If I were just doing a login/logout yeah .. your way is the way to go.. b
ut
eitherway will accomplish the same result
Cheers
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 11:15 PM
Subject: RE: simple question - how do you manually time out a session
variable
> Why keep the session if there's nothing in it :)
>
> Dropping the session will log them out.
>
> If he's tracking loggedin status by isDefined("SESSION.loggedin"), he'd
> have to go through and add AND len(SESSION.loggedin) since your way jus
t
> sets them to "".
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 14, 2002 11:51 PM
> To: CF-Talk
> Subject: Re: simple question - how do you manually time out a session
> variable
>
>
> Steve's dumps the session totally and my example keeps the session, but
> drops anything in it.
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
> - Original Message -
> From: "Nathan Chen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 14, 2002 10:48 PM
> Subject: Re: simple question - how do you manually time out a session
> variable
>
>
> > Thank you, Paul and Steve, for your help.
> >
> >
> > - Original Message -
> > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 14, 2002 9:31 PM
> > Subject: Re: simple question - how do you manually time out a session
> > variable
> >
> >
> > > If you are wanting the session to END, just
> > >
> > >
> > >
> > > (Wrap it in cflock EXCLUSIVE)
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector - Commerce Builder
> > >
> > >
> > > > Hi,All:
> > > >
> > > > I know you can set time out for a session variable by changing th
e
> > > > default value in CF administration, but can you time out a sessio
n
> > > > variable manually? For example, if the user clicks a button
> called
> > > > "logout", then the next page sets the session expire or time out.
> > > >
> > > >
> > > > Nathan
> > > >
> > > >
> > >
> >
>
>
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
Thinking about it more: your way in some cases would add extra steps..
..do this
..do that
.do something else
Your way
..do this
..do that
.do something else
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 11:20 PM
Subject: Re: simple question - how do you manually time out a session
variable
> I agree ... (didn't actually disagree) ..
>
> does about the same thing and IsDefined
..
>
> I just happen to be working with sessions at that time, and that is one
w
> ay
> I was clearing it out .. but I didn't want to loose the session either
..
>
> If I were just doing a login/logout yeah .. your way is the way to go..
b
> ut
> eitherway will accomplish the same result
>
> Cheers
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
>
> - Original Message -
> From: "Steve Oliver" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 14, 2002 11:15 PM
> Subject: RE: simple question - how do you manually time out a session
> variable
>
>
> > Why keep the session if there's nothing in it :)
> >
> > Dropping the session will log them out.
> >
> > If he's tracking loggedin status by isDefined("SESSION.loggedin"), he
'd
> > have to go through and add AND len(SESSION.loggedin) since your way j
us
> t
> > sets them to "".
> >
> > __
> > steve oliver
> > atnet solutions, inc.
> > http://www.atnetsolutions.com
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 14, 2002 11:51 PM
> > To: CF-Talk
> > Subject: Re: simple question - how do you manually time out a session
> > variable
> >
> >
> > Steve's dumps the session totally and my example keeps the session, b
ut
> > drops anything in it.
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector - Commerce Builder
> > - Original Message -
> > From: "Nathan Chen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 14, 2002 10:48 PM
> > Subject: Re: simple question - how do you manually time out a session
> > variable
> >
> >
> > > Thank you, Paul and Steve, for your help.
> > >
> > >
> > > - Original Message -
> > > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, February 14, 2002 9:31 PM
> > > Subject: Re: simple question - how do you manually time out a sessi
on
> > > variable
> > >
> > >
> > > > If you are wanting the session to END, just
> > > >
> > > >
> > > >
> > > > (Wrap it in cflock EXCLUSIVE)
> > > >
> > > > Paul Giesenhagen
> > > > QuillDesign
> > > > http://www.quilldesign.com
> > > > SiteDirector - Commerce Builder
> > > >
> > > >
> > > > > Hi,All:
> > > > >
> > > > > I know you can set time out for a session variable by changing
th
> e
> > > > > default value in CF administration, but can you time out a sess
io
> n
> > > > > variable manually? For example, if the user clicks a button
> > called
> > > > > "logout", then the next page sets the session expire or time ou
t.
> > > > >
> > > > >
> > > > > Nathan
> > > > >
> > > > >
> > > >
> > >
> >
> >
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
