Re: OT SQL SERVER Backup
Hi Jim, Yes.Go to Enterprise Manager Select the database--Right Click --All Tasks --Backup Select Database - Complete. Add Destination ( where the back up file to be taken) Click Ok. The Backup is created on file selected for backup In Options Tab See that the Following are checked. Verify Backup Upon Completion.(It will ensure after backup is completed successfully). Regards Nagaraj. - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 15, 2002 6:24 AM Subject: OT SQL SERVER Backup Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? - j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cffile parsing problem
Hi , If you just want to export the file to Access manually you can use import feature of Access It will ask where you follow the wizard will help you to export the text file data to Access table later you can import the data to appropriate table. Regards Nagaraj.A - Original Message - From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:22 PM Subject: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, I don't know how to get rid of the last comma in each line, and then how to parse with a blank line between each record. I've tried this CFFILE action=READ file=D:\InetPub\wwwroot\_Candelo\database\candeloweb1603.txt variable=Candelo !--- Set a variable to hold the ascii values for a line break and a carriage return --- CFSET new_line=Chr(10) Chr(13) !--- Loop thru lines of text --- CFLOOP index=i list=Candelo delimiters=new_line cfoutput#Candelo#/cfoutputBR /CFLOOP and get this (but repeated three times!) SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, Can anyone give me some clues or help please Many thanks Seamus __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Annoying DB question
Hi Bill, It Seem that Same Primary Key Value is been inserted.You can do like this.Prior Inserting You make a check if it is existing Give a message that already existing else go with insertion.This way there is no chance of Inserting on Refreshing the page also. With Regards Nagaraj.A - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:08 PM Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: javaScript (simple)
Hi Deborah Curley, Try this out. html head titletest/title /head SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- function checkdelete() { if (confirm(Are You sure to Perform Delete or not)) { alert(Yes Go for Deleting to the next form); document.frm.submit(); } } //-- /SCRIPT body form NAME=frm ACTION=test.html METHOD=post input type=text name=one value= input type=button name=Del value=Delete onClick=javascript:checkdelete() /FORM /body /html Regards Nagaraj.A - Original Message - From: Deborah Curley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 26, 2002 4:45 PM Subject: javaScript (simple) Hi all, Anyone have the code readily available for an OnClick action to make sure a customer wants to delete the record (i.e., click the delete button, get prompted for whether you really want to delete and don't do the action unless you. TIA, Deb _ Chat with friends online, try MSN Messenger: http://messenger.msn.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Keeping track of logged-in users...
Hello, But If User Leave the system or Session Expires.The database is not updated from flag=1 to flag=0.This may lead to problems.I think you can preserver LastLogin time.i.e. When ever user log in we keep the User login information in db.If we are known with session time out peroid we can use that information to find out logged users. If you can you can store the Information in Application variable a structure.But It has its own drawbacks. But Still you can give a try to one of the above. With Regards Nagaraj.A - Original Message - From: Dimple Goshar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 3:05 PM Subject: RE: Keeping track of logged-in users... Hi, If you want to avoid updates to your database, you can have another column in your users database , loggedon which is set to 1 when the user logs on to the site and set to 0 when the user logs off Then u can give ur report on the basis of this column Regards Dimple -Original Message- From: Kevin Langevin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:42 PM To: CF-Talk Subject: Keeping track of logged-in users... Hi all- Got a best practices question for you. I've got a client site which uses client variables to track users' sessions for auto-logout. When a user logs on, a CLIENT.lastAccess variable is set to now(). In the application.cfm, a check is run to see if CLIENT.lastAccess is defined and if it's more recent than 20 minutes. If it is, then CLIENT.lastAccess is set to now() again, and processing continues. As long as the client hits a page before the 20 minute time limit runs out, works great. To log the user out, I delete certain client variables, especially lastAccess. Now my dimlemma. The client decided that he wants to track how many users are logged on (how many have accessed a page in the last 20 minutes and haven't yet been logged off. The only way I can see to do this is to ALSO write now() into a lastAccess field in the member database on each hit right after writing the client variable, so that the home page, which is supposed to display the number of users logged in, can run a query on members with a lastAccess field with a time less than 20 minutes ago. This just seems like a lot of DB access (one write when setting the CLIENT variable, and another when updating the member table), but I'm wondering if anyone has experience doing something like this, and whether that one extra update on each page hit will hurt that much. Assume a few thousand members hitting the site daily, spread out, most likely, but probably surfing around a fair bit (lots of articles, and a message board). Doing the CLIENT variable update seems to impact the site not at all, but I've not tested under really heavy load. Does anyone have a more elegant way of doing this, like parsing the Client DB for the CLIENT.lastAccess variable and getting a count of the ones with a value less than 20 minutes ago. Any suggestions would be most appreciated. Thanks... Kevin Langevin Flying Chimp Media 954-585-0999 [EMAIL PROTECTED] http://www.FlyingChimp.com -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 4:51 AM To: CF-Talk Subject: RE: CF's Most Wanted :: Hi Peoples Well, I can say, since its public knowledge in some circles that locking will no longer be required with Neo - the server will handle this side of things. CFMX has addressed the fact that failure to lock shared scope vairables will not cause memory corruption while a write operation is in progress. **However**, you will still have to lock for the legitimate use - to prevent synchronous activity ensuring that requests are requests are processed one at a time. For example, if I am about to reread a cached query I might decide that all requests that need this query should wait so as to ensure that they have the newer data. Hope this helps! Neil Team Macromedia http://www.macromedia.com/go/team __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Keeping track of logged-in users...
Hi, Btw how can we Track that User has closed the Browser Window.How does server get notified about that event. With Regards Nagaraj.A - Original Message - From: Dimple Goshar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 3:49 PM Subject: RE: Keeping track of logged-in users... Which means there is no problem of session timeout Then in that case u can very well have an additional column loggedon which is set to 1 when the user logs in and set to 0 when the user logs out or closes the browser window -Original Message- From: Kevin Langevin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:41 PM To: CF-Talk Subject: RE: Keeping track of logged-in users... Actually, I'm using Client variables...no session vars at all. Kevin Langevin Flying Chimp Media 954-585-0999 [EMAIL PROTECTED] http://www.FlyingChimp.com -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 6:02 AM To: CF-Talk Subject: RE: Keeping track of logged-in users... You are basically going to have to use session vars so you may as well use a structure which has the total of users logged in etc... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Timing a CFHTTP Request
Hi Tim, It varies from depending on the band width .Its is not fixed with certain time.If you want you can measure the time by Function called GetTickCount() ,before and after CFHTTP operation.By which you can calculate the Time take for CFHTTP to perform required task. Rgds Nagaraj.A - Original Message - From: Tim Claremont [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 7:08 PM Subject: Timing a CFHTTP Request I would like to measure the amount of time that an HTTP request takes to complete. Anyone have an example of how to do this? Tim __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled Tasks in Admin
Hello Bosky Dave, Does it is requesting any session variables which are to set before.I had same problem What i did is First Created the scheduler and Then in CFADMIN where the schedulers list is shown there is a run link .Which i need to run it explicitly. Even you can go with Windows Scheduler.Did you ever tried with windows scheduler? It works better than CFADMIN schedulers. With Regards Nagaraj.A - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 2:17 AM Subject: Scheduled Tasks in Admin I'm trying to schedule a task in cfadmin but won't run at all. I can pull the url up in a browser ok but when I put it inside the task-url box it doesn't work. Any ideas? Thanks, Dave __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: database design question re:product price changes
Hi Kola Oyedeji, You Can Store the Product Price in orders table as it will save you from making joins which is more overhead then querying same table and having the prices in it. With Regards Nagaraj.A - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 6:08 AM Subject: OT: database design question re:product price changes Hi I have a table which holds orders. The productid and the quantity of items purchased are held in this table amongst other things such as the order date, customer id etc. Orders are calculated by getting the product cost and multiplying it by quantity. Its occured to me that if the price of items changes,because the total of an order is always calculated the order total for previous orders will change. IS there any better way to store orders and price info or should I also store the current price of each product when the order is made in the order table - wouldn't this lead to data being duplicated? Thanks in avance Kola __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: database design question re:product price changes
Hello Kola Oyedeji, Oops..It was Order detail Table.rather than order table Regards Nagaraj.A - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 6:08 AM Subject: OT: database design question re:product price changes Hi I have a table which holds orders. The productid and the quantity of items purchased are held in this table amongst other things such as the order date, customer id etc. Orders are calculated by getting the product cost and multiplying it by quantity. Its occured to me that if the price of items changes,because the total of an order is always calculated the order total for previous orders will change. IS there any better way to store orders and price info or should I also store the current price of each product when the order is made in the order table - wouldn't this lead to data being duplicated? Thanks in avance Kola __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP Error
Hi , I am using CFPOP to retrieve one of the email Box, But i am getting the following error, Connection Failure Caught an exception, type = COM.ALLAIRE.COLDFUSION.POPCONNECTIONFAILURE The contents of the tag stack are: What could be reason for this.? Any Help is really appreciated. With Regards Nagaraj.A __ 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: is this possible?
Hi Jeff, Yes It is posssible.If you know that there are 8 elements and keep track of how to show.Then it is possible. Once the 8 variables are finished then you divert the submission to original page.Till that you will be revolving in same page with different variables requesting. Cheers! Regards Nagaraj.A - Original Message - From: Jeff Fongemie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 6:16 PM Subject: is this possible? Hello cf-talk, Can someone steer me in the right direction to look for this? I need to take a list of names passed by a form. Then generate an html page with release form info and the first name so the user can print. User clicks next and then another page with release form and the second name, user clicks next and another page with the third name and so on until there are no more names left. So if the form gave 8 names, there would be 8 pages with one name each until the last page. Is this even possible? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ 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: Export to text
Hi Kelly, Go To Query Analyzer and query the table you wish and The result fo r that Query is shown in result pane below, There by you can select the result set Right Click you have options of S ave AS, 1. Here you can save it as CSV file 2 Select ALL and copy and Paste it on any text file. Cheers! Regards Nagaraj - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 5:00 AM Subject: Re: Export to text Ah, the ol' cf way - I thought there might be a way directly for the SQ L Server Enterprise Manager. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 4:22 PM Subject: RE: Export to text Sure.. Do a query that pulls all the data out of the table. Run a CFLOOP us ing the query, and output the info as you like, using CFFILE to append ea ch row to the text file. Piece'o'cake. ;) Lee | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, February 20, 2002 3:19 PM | To: CF-Talk | Subject: Export to text | | | Can anyone tell me how to export a sql server table to a text | file (each column seperated by pipes and data incased in | double quotes)? | | Thanks! | __ 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: How do you get the ID number of newest record added to a table?
Hi, Put this code under transaction to get the row inserted and get just inserted rowID cftransaction cfquery datasource=dsn name=insdata insert into table1(col1,col2) values(#val1#,#val2#) /cfquery cfquery datasource=dsn name=getmaxid select max(id) from table1 /cfquery /cftransaction Cheers. Nagaraj - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 15, 2002 2:17 PM Subject: Re: How do you get the ID number of newest record added to a tab le? How do you get the row ID number of the newest record added to a table? I want to insert a record and then outout the info from that record by the autocreated row ID number, because there's no other unique identifier f or the info in each record. Is there a function that tells you the highest row ID number, which consequently would be the newest and latest addition to that table? __ 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: Connecting to Sybase database on Sun
Hi Nyon, Which version of CF are you using. If you using CF5.0 It has an option of Using thru OLEDB Regards Nagaraj.A - Original Message - From: YC Nyon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 08, 2000 8:31 AM Subject: Connecting to Sybase database on Sun Hi, I need to extract data from a Sybase database residing in a Sun server to a CF application on Windows. Not sure how to do this especially on the Sun side? Nyon __ 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
Free CF Hosting on Linux
Hai CFer's, Is there any company give free hosting for developer to test there application using CF on Linux Environment.? Any help ? Rgds Nagraj __ 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: Problem with DateFormat when using DateAdd
Hi Stephen, Dont hold the formatted value in session variable you store just date obj ect i.e !--- creates date for when a registration has first been created --- cfset session.DateRegistrationCreated = Now() !--- created date seven days after DateRegistrationCreated --- cfset session.DateRegistrationExpired = DateAdd(ww, 1, session.DateRegistrationCreated) Now on this session object you can use the Dateformat(). Cheers Regards Nagaraj.A - Original Message - From: Stephen Adams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 7:59 PM Subject: Problem with DateFormat when using DateAdd Hi, I am trying to create two separate dates, the present date and the date a week later, as today is 06/02/02 that is one date then next one is 13/02/ 02. The problem I am having is with formatting the second date. As I am in the UK I want the format of the dates to be dd/mm/yy, but when I go to ad d this extra week on to the date it adds three days onto the day and four months onto the month, so today's date becomes 09/06/02. Here's the code I am using: !--- creates date for when a registration has first been created --- cfset session.DateRegistrationCreated = #DateFormat(Now(),dd/mm/yy )# !--- created date seven days after DateRegistrationCreated --- cfset session.DateRegistrationExpired = #DateFormat(DateAdd(ww, 1, session.DateRegistrationCreated), dd/mm/yy)# How can I change this so I can keep the same format and still get the d ate added to. Stephen __ 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: database security
Hi Seamus Campbell, Currently I store the database in a non-web-accessible directory on a shared server, but that's it. This is better solution.But By putting Password also may not help much on ce mdb is obtained. Regards Nagaraj.A - Original Message - From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 3:46 AM Subject: database security Hi I'm working with a database programmer (in access) who is paranoid abou t his databases. He is very worried about the security of his database. Is there anything else I can reasonably do? (the website is being done quite cheaply) I have read some articles on security but they all seem to focus on encrypting a string rather than actually protecting the database as suc h. Any clues please?? __ 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: Good WHOIS
Hi Neil, can you give the URL for whois Engine.I am in need of it Regards Nagaraj - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 12:09 PM Subject: Good WHOIS I am trying a really good CF based Whois for domain names? I tried ODSWHOIS and its nice but it doesn't show record created and expiration dates. Anyone know of one that does? Thanks, Neil __ 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: CFPOP
Hi Bob, Are you using proxy server or connected directly to Internet connected system. Rgds Nagaraj - Original Message - From: Bob Imperial [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 13, 2002 2:24 AM Subject: CFPOP Anybody out there have any luck with CFPOP? I'm playing around with trying to build a webmail app just for the experience ... I keep getting a CF error: Connection Failure The error occurred while processing an element with a general identifier of (CFPOP), Here's the tag it craps out on: CFPOP SERVER=#server# USERNAME=#user# PASSWORD=#password#ACTION=GetHeaderOnly NAME=inbox Any help would be appreciated TIA __ 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: CFPOP
Hi Bob, I used the below code cfpop server=#server# name=inbox username=#username# password=#password# action=GetHeaderonly timeout=60 cfoutputTotal Emails : #inbox.recordcount#/cfoutputbr cfoutput query=inbox #from#--#subject#br /cfoutput It worked fine for me.If so please send a test email and check it,and als o make sure to find any problem with your mail server if so. Rgds Nagaraj - Original Message - From: Bob Imperial [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 14, 2002 2:58 AM Subject: Re: CFPOP Nagara, I am on a T1 behind a FW at the office and on a direct cable connection from my home office. Bob On Sun, 13 Jan 2002 16:26:55 +0530 nagraj [EMAIL PROTECTED] wrote: Hi Bob, Are you using proxy server or connected directly to Internet connected system. Rgds Nagaraj - Original Message - From: Bob Imperial [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 13, 2002 2:24 AM Subject: CFPOP Anybody out there have any luck with CFPOP? I'm playing around with trying to build a webmail app just for the experience ... I keep getting a CF error: Connection Failure The error occurred while processing an element with a general identifier of (CFPOP), Here's the tag it craps out on: CFPOP SERVER=#server# USERNAME=#user# PASSWORD=#password#ACTION=GetHeaderOnly NAME=inbox Any help would be appreciated TIA __ 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
Happy new year
Dear CFers Wish You All a Happy new Year __ 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
using ASPMail component
Hi C'Fers, I am trying to use the aspcomponent given by www.serverobject.com I written the following code in my page It is really driving crazy, The code is as follows, cfobject TYPE=COM ACTION=CREATE CLASS=SMTPsvg.Mailer name=objMail cfset success=0 cfset objMail.FromName=Aenugula Nagaraj cfset objMail.FromAddress=[EMAIL PROTECTED] cfset objMail.RemoteHost=10.0.0.95 cfset objMail.AddRecipient(Aenugula Nagaraj,[EMAIL PROTECTED]) cfset objMail.subject=This is test Email cfset objMail.bodyText=MailBody cfset objMail.CharSet=2 cfset objMail.ConfirmRead=true cfset objMail.ContentType= cfset objMail.CustomCharSet=ISO-2022 cfset objMail.DateTime=Fri, 02 May 1997 10:53:49 -0500 cfset objMail.Encoding=1 cfset objMail.ReturnReceipt=true cfset objMail.SMTPLog =c:\smtplog.txt cfset success=objMail.Sendmail CWebException: Error: Attempting to call a method as a PROPERTYGET assignment. For methods with no arguments please use empty parenthesis ! Explanation: unknown error while executing a tag. I tried same using CDONTS. I simply worked out with out any problem. Any Help is really appreciated. With Regards Nagaraj.A ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: using ASPMail component
Dear Jochewm, Thanks Really it worked out. With Regards Nagaraj.A - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:38 PM Subject: Re: using ASPMail component nagraj wrote: cfset success=objMail.Sendmail CWebException: Error: Attempting to call a method as a PROPERTYGET assignment. For methods with no arguments please use empty parenthesis ! This error message decodes to something like: cfset success=objMail.Sendmail() But I am not sure whether that is valid. Jochewm ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: asp vs. cf
CF- Need Addition Application Server Where By You dont need any kind of Application Server w.r.t ASP - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 8:16 PM Subject: asp vs. cf My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: asp vs. cf
CF is Real Web RAD when Compared with ASP - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 8:16 PM Subject: asp vs. cf My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: asp vs. cf
CF- Easy to Code and Debug. Not so easy With ASP. - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 8:16 PM Subject: asp vs. cf My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF-Flash
Hai , I had downloaded the flash component kit from macromedia.Can anybody tell wether we need to have flash loaded at server to make flash component run.I am even having trouble in making it activated. Can any body help me. Any help is really appreciable. Regards Nagaraj.A ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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-Flash
Hai Dave, Thanks,then I will give one more try to configure the Flash Development Kit with Coldfusion With Regards Nagaraj.A - Original Message - From: David Hannum (Ohio University) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 6:21 PM Subject: Re: CF-Flash Hello Nagaraj.A Flash is not a server. Flash (Flash Player) is 1) a plug-in for browsers and 2) a development tool for creating the .swf files that the Flash Player plays. (SWF is open, so you can use other tools to create them) You don't need anything for your server. You need to code your pages so that the swf file is downloaded to the browser (much the same as an image or Java Applet are) and the browser's Flash Plug in then handles the rest. Dave - Original Message - From: nagraj [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 6:18 AM Subject: CF-Flash Hai , I had downloaded the flash component kit from macromedia.Can anybody tell wether we need to have flash loaded at server to make flash component run.I am even having trouble in making it activated. Can any body help me. Any help is really appreciable. Regards Nagaraj.A ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: IE6 and double insertion
Hai Ramakrishna, Can you post the code for display and action page.I'll just figure it out. Regards Nagaraj - Original Message - From: Venkata Ramakrishna [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 09, 2001 4:15 PM Subject: IE6 and double insertion Hi all, We have got a peculiar problem. When a page containing a list box is submitted for data insertion,it is observed that an extra record is getting inserted for each row in the list box. Action page is built in CF 4.5 When the same is tried in IE5 or Netscape Navigator 4.5,the above problem is not encountered. If someone has got any idea about this,please help me out. TIA, Ramakrishna. ICQ NO: 135914693. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: printing
Hai Joshua Anyone know either through style sheets or some other way to make a document print landscape? When you say print() function,we get the window before printing where by we can opt for Landscape or normal prinitng, Does it does'nt workout? Regards Nnagaraj ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTTP Posts with a java cfx
Hai Craig, This is specially when you donot give exception throws exception clause processrequest() method. Is the syntax as below. Please check it public void processRequest(Request req,Response res) throws Exception { } Regards Nagaraj - Original Message - From: Craig Dudley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 3:15 PM Subject: HTTP Posts with a java cfx Good morning all, I'm trying to write a java custom tag to do a simple http post and read the response into a variable, I'm getting the same error no matter what method I try. Basically it's for posting small xml packets to an SMS service provider. I've tried this with 20+ differnet url's, all of which exist. Error; --- java.io.FileNotFoundException: http://localhost/public/sms/smsin.cfm. Java exception occurred in call to method. --- What I don't undestand is why it would say file not found when I'm opening a connection to a url, not a file? Are there any java experts out there that can give me some advice? Code follows; sendMessages.class --- import com.allaire.cfx.* ; import java.net.*; import java.io.*; public class sendMessages implements CustomTag { public void processRequest( Request request, Response response ) throws Exception { // validate that required attributes were passed if ( !request.attributeExists( XMLDATA ) ) { throw new Exception( Missing attribute ( XMLDATA is a + required attribute for this tag) ) ; } String strName = request.getAttribute( XMLDATA ); URL url = new URL(http://localhost/public/sms/smsin.cfm;); URLConnection connection = url.openConnection(); connection.setDoOutput(true); connection.setDoInput (true); connection.setUseCaches (false); connection.setRequestProperty(Content-Type, application/x-www-form-urlencoded); PrintWriter out = new PrintWriter(connection.getOutputStream()); out.println(XMLDATA= + strName); out.close(); BufferedReader in = new BufferedReader(new InputStreamReader(connection.getInputStream())); String inputLine; String ReturnXML = ; while ((inputLine = in.readLine()) != null) { ReturnXML = ReturnXML + inputLine; } in.close(); response.setVariable( ReturnXML , ReturnXML ); response.write(ReturnXML); } } --- Sorry for the slight OT post, but at least it's a java CFX. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: good cf developers in the UK
Hello Ben, what kind of CFX /Custom Tag you are willing to Outsource. Rgds Nagaraj ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Networksolutions using CFM
Hey , I felt the CF is Really a RAD tool in Web Development . Yes the same question I too have as I am a coldfusion developers.I try to ask this question to myself few times. And no offense to you guys who believe JSP is better because some of you are undoubtedly better CFers than me.. but so far the only ones I've encountered that prefer JSP are the ones who code Cold Fusion literally like this: cfoutput#variable1#/cfoutputcfoutput#variable2#/cfoutput cfoutput#variable3#/cfoutputcfoutput#variable4#/cfoutput cfoutput#variable5#/cfoutputcfoutput#variable6#/cfoutput This can also be written is good way as below cfoutput #variable1# #variable2# #variable3# #variable4# #variable5# #variable6# /cfoutput Rgds Nagaraj ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Networksolutions using CFM
Dear Friend, You words really mean it.I really appreciate your thinking. Rgds Nagaraj - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 9:01 PM Subject: RE: Networksolutions using CFM Keep in mind that purchasing decisions are typically made by management, not developers. And there are a lot of companies that use PHP and Perl. And yes, they are very powerful and free. I don't care for Perl personally, but PHP is quite a cool little language. Why do people buy CF? 1) ROI and 2)support Blah. I hate languageX vs languageY stuff. I say learn it all, and pick the best one for the situation. Once you've learned one web language, anyone with a handful of braincells can EASILY pick up another one (unless you allow yourself to be convinced that the language you love is the only one worth learning) --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 6:11 AM To: CF-Talk Subject: Re: Networksolutions using CFM One thing you can't do with Cold Fusion is convince people of the language's strength.. cf_moron problem=ignorance NumberOfTimesToTryExplaining=50 IfNegativeResults=You'll see. I've only gotten one php developer to migrate to Cold Fusion.. Here's the question I ask of developers.. IF PHP and Perl are so powerful and free then why does anyone buy Cold Fusion? And doesn't it seem like it would be the toy developers who would use the free languages? Oh, my boss would have loved having Cold Fusion for free, lol.. And another thing.. can someone tell me what's so divinely awesome about JSP?? I've looked at it and I'd rather write CF.. anyday.. And no offense to you guys who believe JSP is better because some of you are undoubtedly better CFers than me.. but so far the only ones I've encountered that prefer JSP are the ones who code Cold Fusion literally like this: cfoutput#variable1#/cfoutputcfoutput#variable2#/cfoutput cfoutput#variable3#/cfoutputcfoutput#variable4#/cfoutput cfoutput#variable5#/cfoutputcfoutput#variable6#/cfoutput Thanks, Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com - Original Message - From: Michael Vinson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 4:40 PM Subject: Re: Networksolutions using CFM .. sentiments well taken, but for late entrants (like myself) into the corporate transaction-based world, this is very useful (important) reading. I'm on the cusp of a decision (offer) to move into jsp/oracle/beans/etc. ... from a pretty rewarding 10+ years of building educational multimedia. The market is just a tad too soft I feel that I have reached a plateau with that other Macromedia product (Director). -mv Billy Cravens wrote: I get the feeling this thread is about to digress into a CF vs. [insert language here] thread ... Please no... --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Brunt, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:35 PM To: CF-Talk Subject: RE: Networksolutions using CFM Since the Verisign thing the new (netsol I think) web site is pretty aweful and yes it does look like java now. Why oh why can't people be satisfied to use ColdFusion after all this time we are still seen as toy developers by some. The reality is there is little or nothing you cannot do with CF. Mike Brunt Sempra Energy 213.244.5226 The nice thing about standards is that there are so many to choose from. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:27 PM To: CF-Talk Subject: RE: Networksolutions using CFM Verisign now owns them...officially anyway. Seems they are using quite a bit of jhtml too. Dan Phillips Lead Support Technician\ColdFusion Administrator Express Technologies, Inc. dba CFXhosting.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 4:24 PM To: CF-Talk Subject: Networksolutions using CFM I just got an email from Networksolutions and in the email were links to CFM pages. Pretty cool to see Networksolutions using Cold Fusion for some things! ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: URGENT: Postpone data connection
Hai Tony, There is good solution for it. Btw what database are you using.. If you using Access database ,Put a query like this select * from notable As there is no table in your database named by notable which will result in error and free the connection.There by you can play with it. I can't access my database.. I can't overwrite it.. something went wrong.. Is there a way in CF,JSP or ASP to put it on pause so that I can upload the database and 'hit play' again? Thanks, Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Split Variable
Hai Joshua, cfset str=Lonwood Leesburg cfset tok1=ListGetAt(str,1,' ') cfset tok2=ListGetAt(str,2,' ') After this tok1=Lonwood and tok2=Leesburg That's it Cool I have a variable that is passed such as Lonwood Leesburg. Sometimes Central Orlando. I need to know how to split it at the space then insert one half into one column of a db and the other half to another column of the db. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Output Issue
Hi Mike Its some thing like this cfloop list=#form.fieldnames# index=x delimiters=, tr td cfoutput#x#/cfoutput /td td cfoutput#evaluate(x)# /cfoutput /td /tr /cfloop Ok Cool.. Nagraj I have the following code: cfloop list=#form.fieldnames# index=x delimiters=, tr td cfoutput#x#/cfoutput /td td cfoutput#form.#x## /cfoutput /td /tr /cfloop The value for the form field throws an error the way I am doing it. I am not familiar with the Evaluate function and the concatonation of strings, is this what I should do? Thanks for any help or explanation. Mike === Michael T. Tangorre Web Applications Developer Alfred University Webteam Slave :-) [EMAIL PROTECTED] AIM: CrazyFlash4=== Friends don't let friends code before coffee!=== ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL question about related tables
Hai , WHERE Product.CategoryID = Category.CategoryID ? This is good way .As cfloop will take little more time to execute the and not suggestive to do so. Nagaraj - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 01, 2001 8:05 PM Subject: SQL question about related tables Im wondering what is the best way to get related data from two tables. This would be the MySQL database structure: Table Name: Category CategoryID (autonumber) CategoryName (text) Table Name: Subcategory SubcategoryID (autonumber) SubcategoryName (text) Table Name: Product ProductID (autonumber) CategoryID (linked to category table) SubcategoryID (linked to subcategory table) ProductSKU (text) If i know the ProductID, what is the BEST way to get the CategoryName, and SubcategoryName? Two Querys (one in a CFLOOP) ? Query inside of a Query ? INNER JOIN ? WHERE Product.CategoryID = Category.CategoryID ? Thanks In advanced, Chad ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists