SQL Question
Hello, Can someone please help me. I wish to delete part of a text in student field keeping part of the text in the same field intact. Database: Access. Table name is: TopStudents The field names are: studentid, studentdetails, percentage, grade. The contents of the rows in the studentdetails field are similar to this: Student Name1 - Year 1950 Student Name2 - Year 1953 Student Name3 - Year 1953 Student Name4 - Year 1953 Student Name5 - Year 1954 I have about 500 rows of data in the table. What I wish to do is to keep the student names in the rows intact and delete everything on the righthand side from the -. Any help would be much appreciated. Regards SB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: dancing 'round the mullberry bush
Hi, CF Schedule is most probably the most unreliable tag in CF. Like you, we have never been able to make much use of it on CF5. Srimanta - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:04 PM Subject: dancing 'round the mullberry bush I first tried long ago to get CFSchedule to actually, like, you know, run a scheduled task. I've tried many times over the years on all kinds of different machines, different versions, different tasks to get the damn thing to work. Ain't never worked for me. Just got a new CFMX server ... first code I put on it was a simple little scheduled task. It's executed faithfully twice now. So I'm dancing a little jig. Just wanted to share. H.\ ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with Search Engine
Hello Forum. I have been askedby an Internet Retailer (Computer products) to develop a template that would accomplish the following: 1. Search several URL's /Websites (those of competing internet retrailers) (Upto 20) and grab info on pricing, models and stock.on consumer items eg cameras, laptops etc.on a daily basis. 2. Update my clients database so that its prices are the lowest. (provided my clients sp is not less than pp) Well.. Part 2 is easy. However I am not sure how to implement Part 1. I have not done Search Engine stuff before except for queries that search databases. Can someone please guide me in the right direction. Any help would be much appreciated... Kind Regards, Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cannot convert to number.
Yes, I have had similar errors. Its usually when your query does not return a numerical data where a number is expected. Check your database--specially the rows in numerical columns. Replacing null/empty numerical cells with 0 (zero) might solve your problem HTH Srimanta htttp://www.digitalshop.co.nz - Original Message - From: Jillian Carroll [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 12, 2003 10:15 PM Subject: Cannot convert to number. I am having a really weird problem... I do some calculations in CF, they work on my development machine (Windows XP Home/Apache) but when I upload them to my host (Windows 2000/IIS) they don't work. I get this error... anybody able to help me on this one? *** *** *** Error Diagnostic Information An error occurred while evaluating the expression: EndRow = StartRow + OnEachPage - 1 Error near line 39, column 8. Cannot convert to number. Please, check the ColdFusion manual for the allowed conversions between data types The error occurred while processing an element with a general identifier of (CFSET), occupying document position (39:2) to (39:43). Date/Time: 01/12/03 23:33:29 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 207.195.97.118 *** *** *** My code is below: !--- QUERIES AND VARIABLE SETTING --- cfquery name=tools datasource=#dsn# username=jubilee password=cds337 SELECT jubileeid, globalnumber, nanumber, rotundanumber, binlocation, name FROM tools ORDER BY name ASC /cfquery !--- END QUERIES AND VARIABLE SETTING --- !--- Next/Previous Logic Start --- !--- Set the number of records to display on each page. --- CFSET OnEachPage = #toolsviewnum# !--- Set the default startrow to 1 if a value was not passed. --- !--- Determine whether or not to show the previous or next links. --- CFPARAM NAME = StartRow DEFAULT = 1 !--- Set the value of endrow to the maxrows + startrow - 1 --- CFSET EndRow = StartRow + OnEachPage - 1 !--- If the end row is greater than the recordcount, determine how many records are left. --- CFIF EndRow GTE tools.RecordCount CFSET EndRow = tools.RecordCount CFSET Next = false !--- Othereise, set Next to true and determine the next set of records. --- CFELSE CFSET Next = true CFIF EndRow + OnEachPage GT tools.RecordCount CFSET NextNum = tools.RecordCount - EndRow CFELSE CFSET NextNum = OnEachPage /CFIF CFSET NextStart = EndRow + 1 /CFIF !--- If StartRow is 1, set Previous to false. --- CFIF StartRow IS 1 CFSET Previous = false !--- Othewise, determine the previous set of records. --- CFELSE CFSET Previous = true CFSET PreviousStart = StartRow - OnEachPage /CFIF !--- Determine how many pages will be displayed. --- CFSET NumPages = Ceiling(tools.RecordCount / OnEachPage) CFPARAM NAME = PageNum DEFAULT = 1 !--- Next/Previous Logic End --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Redirection based on IP address.
Hello Forum, I have been asked to create a template which will redirect viewers to their respective country page depending on their IP address/location. The client has a website where there are seperate pages for countries eg Australia, UK, New Zealand US. What the client wants is visitors from each of these countries should be automatically redirected to country specific home page when they visit the website. What would be the best approach to achieve this? Any help would be much appreciated. Regards, Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Redirection based on IP address.
Yup. Thanks. How do I reliably determine the country from the IP address realtime. I think that the tricky part. Is there a CF tag that will do that for me? Srimanta - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 4:01 PM Subject: Re: Redirection based on IP address. Assuming you can reliably determine which IP addresses go with which country, it should be fairly easy using CGI.remote_addr (which gives you their IP address). Of course, what if an Australian user is on vacation in the US and wants to see the Australian page? I'd suggest still giving the users the option to go to other country pages (so the aforementioned Aussie will initially get the US page but can switch go the Australian pages [and keep the preference with a cookie/session variable]). Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Australian NZ Stock Quotes
Hi Forum, Can anyone recommend a custom tag / Java Script code to display Australian and/or New Zealand stock quotes? Any help would be much appreciated. Cheers Srimanta http://www.digitalshop.co.nz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Preventing URL Display in Status bar
Hello Forum, Is there a way to stop the status bar from displaying the URL / path when the pointer is over a hypertext link on a website. I remember reading an article somewhere (probably in this forum) some time back but now cant find it. Any Help would be much appreciated. Regards, Srimanta http://www.digitalshop.co.nz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Preventing URL Display in Status bar
Thanks Steve. Srimanta http://www.digitalshop.co.nz - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, November 17, 2002 8:38 PM Subject: RE: Preventing URL Display in Status bar Is there a way to stop the status bar from displaying the URL / path when the pointer is over a hypertext link on a website. Use JavaScript a href=index.cfm?fuseaction=home onmouseover=window.status='Click for home page...'; return true onmouseout=window.status=''; return trueHome/a . this will put the text 'Click for home page...' in the status bar instead of the URL. HTH, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Email authentication
Hello Forum. Is there a tool or utility or script capeable of checking email addresses real time? I am trying to create a CF application which will allow visitors to browse certain section(s) in the website depending on whether the email address provided by the user is valid and functional. Any help would be much appreciated. Thanks Srimanta http://www.digitalshop.co.nz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Email authentication
Thanks Matthew, Very helpful info. Kind Regards, Srimanta - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 4:24 PM Subject: RE: Email authentication Hi Srimanta, We use HexValidEmail form hexillion.com for this. It's pretty easy to use although the docs are a bit confusing. Ask if you need help. Matthew Walker http://www.matthewwalker.net.nz/ -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, 15 November 2002 2:32 a.m. To: CF-Talk Subject: OT: Email authentication Hello Forum. Is there a tool or utility or script capeable of checking email addresses real time? I am trying to create a CF application which will allow visitors to browse certain section(s) in the website depending on whether the email address provided by the user is valid and functional. Any help would be much appreciated. Thanks Srimanta http://www.digitalshop.co.nz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Query size
Hi Forum, I need a way to display the query size (in Kb or Mb) in a Cold Fusion application and then use it to bill a client. Unusual requirement. Had a quick look through the list of Cf functions ... didnt seem to find one or did I miss ? Is there a cold fusion function to get the size of query resultsets? I need to be able to display / output the size and then use it for billing purposes. I know one can know the query size and time in the debugging environment, but this is for the client to view. any Help would be much appreciated. Thanks Srimanta - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 2:22 PM Subject: Re: sorry if repost Someone said that the HoF server was hitting them with what looked like a DoS attack. I couldn't find the problem and took the server down to look more. I havn't heard back from the guy to know if the problem was fixed or not (I think it was a change in his anti-spam routing, but) As for the question, look at these functions: From bin to dec (converts a string to a decimal integer using the radix - second attribute) #InputBaseN(1010, 2)# from dec to bin (converts a decimal integer to a string using the radix - second attribute) #formatbaseN(10, 2)# sorry if this is a repost for some of you, however I didn't get my postreally, I hardly ever get my post, I get it like an hour later or sobut never on time? mike? does anyone know of an easy method of transforming a binary number to a decimal number? cfset newNumber = binaryToDecimal(1110) something that would look like that :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
QUERY SIZE.
Hi Forum, I need a way to display the query size (in Kb or Mb) in a Cold Fusion application and then use it to bill a client. Unusual requirement. Had a quick look through the list of Cf functions ... didnt seem to find one or did I miss ? Is there a cold fusion function to get the size of query resultsets? I need to be able to display / output the size and then use it for billing purposes. I know one can know the query size and time in the debugging environment, but this is for the client to view. Help would be much appreciated. Thanks Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Query size
Thanks, The best solution would have been to get the exact query size. Unfortunately average values will not do the job in this case. Dont think writing it to a file and then using CF directory to get the file size will work either as more than one user can run multiple queries simultaneously. Locking is an option. Will have to experiment and see how it works. Would be happy to see Macromedia provide a function to get query size in the future versions of CF. I think I am in trouble as I promsed my client that it can be easily done... Kind Regards, Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:26 PM Subject: RE: Query size Well, it's not in KBs or MBs, but you can use queryName.RecordCount to determine the number of results in the record. Multiply that by some multiple and you have an average (perhaps?) size. Sort of. 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, November 08, 2002 2:56 PM To: CF-Talk Subject: Query size Hi Forum, I need a way to display the query size (in Kb or Mb) in a Cold Fusion application and then use it to bill a client. Unusual requirement. Had a quick look through the list of Cf functions ... didnt seem to find one or did I miss ? Is there a cold fusion function to get the size of query resultsets? I need to be able to display / output the size and then use it for billing purposes. I know one can know the query size and time in the debugging environment, but this is for the client to view. any Help would be much appreciated. Thanks Srimanta - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 2:22 PM Subject: Re: sorry if repost Someone said that the HoF server was hitting them with what looked like a DoS attack. I couldn't find the problem and took the server down to look more. I havn't heard back from the guy to know if the problem was fixed or not (I think it was a change in his anti-spam routing, but) As for the question, look at these functions: From bin to dec (converts a string to a decimal integer using the radix - second attribute) #InputBaseN(1010, 2)# from dec to bin (converts a decimal integer to a string using the radix - second attribute) #formatbaseN(10, 2)# sorry if this is a repost for some of you, however I didn't get my postreally, I hardly ever get my post, I get it like an hour later or sobut never on time? mike? does anyone know of an easy method of transforming a binary number to a decimal number? cfset newNumber = binaryToDecimal(1110) something that would look like that :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Query size
Thanks, I am using MS SQL. Srimanta - Original Message - From: Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:13 PM Subject: RE: Query size What database are you using? Does this have to be a ColdFusion solution? Or can you work it on the Database end? Jeff -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, November 08, 2002 6:34 PM To: CF-Talk Subject: Re: Query size Thanks, The best solution would have been to get the exact query size. Unfortunately average values will not do the job in this case. Dont think writing it to a file and then using CF directory to get the file size will work either as more than one user can run multiple queries simultaneously. Locking is an option. Will have to experiment and see how it works. Would be happy to see Macromedia provide a function to get query size in the future versions of CF. I think I am in trouble as I promsed my client that it can be easily done... Kind Regards, Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:26 PM Subject: RE: Query size Well, it's not in KBs or MBs, but you can use queryName.RecordCount to determine the number of results in the record. Multiply that by some multiple and you have an average (perhaps?) size. Sort of. 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, November 08, 2002 2:56 PM To: CF-Talk Subject: Query size Hi Forum, I need a way to display the query size (in Kb or Mb) in a Cold Fusion application and then use it to bill a client. Unusual requirement. Had a quick look through the list of Cf functions ... didnt seem to find one or did I miss ? Is there a cold fusion function to get the size of query resultsets? I need to be able to display / output the size and then use it for billing purposes. I know one can know the query size and time in the debugging environment, but this is for the client to view. any Help would be much appreciated. Thanks Srimanta - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 2:22 PM Subject: Re: sorry if repost Someone said that the HoF server was hitting them with what looked like a DoS attack. I couldn't find the problem and took the server down to look more. I havn't heard back from the guy to know if the problem was fixed or not (I think it was a change in his anti-spam routing, but) As for the question, look at these functions: From bin to dec (converts a string to a decimal integer using the radix - second attribute) #InputBaseN(1010, 2)# from dec to bin (converts a decimal integer to a string using the radix - second attribute) #formatbaseN(10, 2)# sorry if this is a repost for some of you, however I didn't get my postreally, I hardly ever get my post, I get it like an hour later or sobut never on time? mike? does anyone know of an easy method of transforming a binary number to a decimal number? cfset newNumber = binaryToDecimal(1110) something that would look like that :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Query size
Would be happy to get a CF solution to the problem. Dont really want to work at db end for the solution. What about other platforms-- ASP--PHP? (Iam probably going off the track.) Thanks Srimanta - Original Message - From: Srimanta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 08, 2002 6:21 PM Subject: Re: Query size Thanks, I am using MS SQL. Srimanta - Original Message - From: Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:13 PM Subject: RE: Query size What database are you using? Does this have to be a ColdFusion solution? Or can you work it on the Database end? Jeff -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, November 08, 2002 6:34 PM To: CF-Talk Subject: Re: Query size Thanks, The best solution would have been to get the exact query size. Unfortunately average values will not do the job in this case. Dont think writing it to a file and then using CF directory to get the file size will work either as more than one user can run multiple queries simultaneously. Locking is an option. Will have to experiment and see how it works. Would be happy to see Macromedia provide a function to get query size in the future versions of CF. I think I am in trouble as I promsed my client that it can be easily done... Kind Regards, Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:26 PM Subject: RE: Query size Well, it's not in KBs or MBs, but you can use queryName.RecordCount to determine the number of results in the record. Multiply that by some multiple and you have an average (perhaps?) size. Sort of. 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:mail;designshop.co.nz] Sent: Friday, November 08, 2002 2:56 PM To: CF-Talk Subject: Query size Hi Forum, I need a way to display the query size (in Kb or Mb) in a Cold Fusion application and then use it to bill a client. Unusual requirement. Had a quick look through the list of Cf functions ... didnt seem to find one or did I miss ? Is there a cold fusion function to get the size of query resultsets? I need to be able to display / output the size and then use it for billing purposes. I know one can know the query size and time in the debugging environment, but this is for the client to view. any Help would be much appreciated. Thanks Srimanta - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 2:22 PM Subject: Re: sorry if repost Someone said that the HoF server was hitting them with what looked like a DoS attack. I couldn't find the problem and took the server down to look more. I havn't heard back from the guy to know if the problem was fixed or not (I think it was a change in his anti-spam routing, but) As for the question, look at these functions: From bin to dec (converts a string to a decimal integer using the radix - second attribute) #InputBaseN(1010, 2)# from dec to bin (converts a decimal integer to a string using the radix - second attribute) #formatbaseN(10, 2)# sorry if this is a repost for some of you, however I didn't get my postreally, I hardly ever get my post, I get it like an hour later or sobut never on time? mike? does anyone know of an easy method of transforming a binary number to a decimal number? cfset newNumber = binaryToDecimal(1110) something that would look like that :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
OT: Browser Usage
Hi All, Does any one know what percentage of users use/ prefer Netscape 4.5 or 6 over IE. Thanks S ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CF Currency Conversion
Hi All, Is there a CF tag availabe that can convert currency values depending on user selection (country)? I have a CF application which requires displaying currency values depending on the exchange rates. The default currency is Australian Dollars. However users need to see other values eg NZ Dollars, UK Pounds, HKDollars, US dollars etc. Changes have to be real time. I have seen similar in some ASP run websites. Any ideas as to how to implement it in CF ? Thanks Srimanta - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 12:25 PM Subject: Re: OT: SQL Question Tony Carcieri wrote: Hi all, Here's what I want to do: UPDATE tablename SET column = 0 WHERE ID = ??? I want to specify a range of numbers (like 100-200) and increment it by 2. So, 100, 102,104etc would only be updated and the rest wouldn't. WHERE ID BETWEEN 100 AND 200 AND MOD(ID, 2) = 0 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Time Required for Updating DB
Thanks Mosh This is what I am using: This update Query is not working. After seven hours of hard work my hard drive has stopped making the horrible grinding sound. The Result: None of the records were updated. Can someone please help. I am trying to update price field in Table named Product with values from field newprice in Table named New. The primary key in both the tables is dealerpart no (Text) which is unique. Note: All the records need to be updated CFQUERY name=UpdatePrice Datasource=XYZ Select New.newprice,New.dealerpartno,New.publisher, Product.publisher,Product.dealerpartno,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Thanks Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:28 PM Subject: RE: Time Required for Updating DB Like (I think) Isaac said, there's probably something wrong with the code, but it's kind of hard to tell for sure without looking at the code. I apologize if this is obvious, but since you didn't really explain the particulars of the situation, I wanted to make sure that you weren't inadvertently making this harder than need be. Does the situation allow for you to update the column via a single UPDATE query as in: UPDATE fooTable SET barColumn = barColumn + 1 If so, this will be infinitely quicker than having to perform 1 UPDATE query per record. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 8:47 PM To: CF-Talk Subject: Time Required for Updating DB Hi I am having trouble updating a fairly small size database with approx 2 records. Size in MB is approx 18 MB. Type Access 2000. I am updating one particular column, in all the rows with CF Query and Loop tags. First the program generates : Bad Allocation Error complaining of Virtual memory shortage. I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor. When I increased the Virtual memory size the update seems to be going on for ever!!! Its exactly 5 hours plus now its running. How much time does similar updates take?? Any ideas ?? I have not done this before. Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Time Required for Updating DB
Many Thanks Mosh, Thanks for the time taken to look into my problem and for the codes. Will try . Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:03 PM Subject: RE: Time Required for Updating DB Thanks Mosh Yup. 8^) I am trying to update price field in Table named Product with values from field newprice in Table named New. The primary key in both the tables is dealerpart no (Text) which is unique. Note: All the records need to be updated CFQUERY name=UpdatePrice Datasource=XYZ Select New.newprice,New.dealerpartno,New.publisher, Product.publisher,Product.dealerpartno,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Srimanta: There are a few problems here. The first is with your SELECT query: Select New.newprice, New.dealerpartno, New.publisher, Product.publisher, Product.dealerpartno, Product.price From New, Product This query (aside from producing two dealerpartno columns) does not specify how to join the two tables. It therefore creates (if I remember the terminology correctly) a Cartesian Product of the two tables. This is, essentially, a result set of every single possible combination of the records from each table. For example, if your 2 tables had the following data: New.newPrice Product.price = a 1 b 2 the result set would be: newPrice price = a 1 a 2 b 1 b 2 So, since both of your tables have 20,000 records, your SELECT query is returning a result set with 20,000 x 20,000 records (400,000,000 records). Looping 400 million times is probably what's taking so long 8^). Instead, your query should look something like: SELECT New.newprice, New.dealerpartno AS newDealerPartNo, New.publisher AS newPublisher, Product.publisher AS oldPublisher, Product.dealerpartno AS oldDealerPartNo, Product.price FROM New, Product WHERE New.dealerPartNo = Product.dealerPartNo This query will produce a result set with only 20,000 records (assuming there's a 1-to-1 match of the part numbers in the 2 tables). All that said, I don't think you need the join in the SELECT query. It might be enough to change your code to the following: CFQUERY NAME=UpdatePrice DATASOURCE=XYZ SELECT newprice, dealerpartno FROM New /CFQUERY CFTRANSACTION CFLOOP QUERY=UpdatePrice UPDATE Product SET price= #newprice# WHERE dealerpartno = #dealerpartno# /CFLOOP /CFTRANSACTION -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Time Required for Updating DB
Mosh, Tried the codes. Still no luck. The query runs for about 8 to 10 minutes and then the screen shows hundreds of lines of the SQL and no data is updated. Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:03 PM Subject: RE: Time Required for Updating DB Thanks Mosh Yup. 8^) I am trying to update price field in Table named Product with values from field newprice in Table named New. The primary key in both the tables is dealerpart no (Text) which is unique. Note: All the records need to be updated CFQUERY name=UpdatePrice Datasource=XYZ Select New.newprice,New.dealerpartno,New.publisher, Product.publisher,Product.dealerpartno,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Srimanta: There are a few problems here. The first is with your SELECT query: Select New.newprice, New.dealerpartno, New.publisher, Product.publisher, Product.dealerpartno, Product.price From New, Product This query (aside from producing two dealerpartno columns) does not specify how to join the two tables. It therefore creates (if I remember the terminology correctly) a Cartesian Product of the two tables. This is, essentially, a result set of every single possible combination of the records from each table. For example, if your 2 tables had the following data: New.newPrice Product.price = a 1 b 2 the result set would be: newPrice price = a 1 a 2 b 1 b 2 So, since both of your tables have 20,000 records, your SELECT query is returning a result set with 20,000 x 20,000 records (400,000,000 records). Looping 400 million times is probably what's taking so long 8^). Instead, your query should look something like: SELECT New.newprice, New.dealerpartno AS newDealerPartNo, New.publisher AS newPublisher, Product.publisher AS oldPublisher, Product.dealerpartno AS oldDealerPartNo, Product.price FROM New, Product WHERE New.dealerPartNo = Product.dealerPartNo This query will produce a result set with only 20,000 records (assuming there's a 1-to-1 match of the part numbers in the 2 tables). All that said, I don't think you need the join in the SELECT query. It might be enough to change your code to the following: CFQUERY NAME=UpdatePrice DATASOURCE=XYZ SELECT newprice, dealerpartno FROM New /CFQUERY CFTRANSACTION CFLOOP QUERY=UpdatePrice UPDATE Product SET price= #newprice# WHERE dealerpartno = #dealerpartno# /CFLOOP /CFTRANSACTION -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Time Required for Updating DB
Its OK
No attitude problems with me.
Srimanta
- Original Message -
From: Ryan Sabir [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:41 PM
Subject: RE: Time Required for Updating DB
The code is missing CFQUERY etc... tags around the SQL code...
Maybe if you tried to understand what the code was doing instead of
blindly pasting it in you would see these problems first.
No hard feelings, its just that we'd all like to see you become a
better CF coder so we can help you with more interesting problems!
bye!
---
Ryan Sabir
Newgency Pty Ltd
2a Broughton St
Paddington 2021
Sydney, Australia
Ph (02) 9331 2133
Fax (02) 9331 5199
Mobile: 0411 512 454
http://www.newgency.com/index.cfm?referer=rysig
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 October 2002 5:40 PM
To: CF-Talk
Subject: Re: Time Required for Updating DB
Mosh,
Tried the codes. Still no luck.
The query runs for about 8 to 10 minutes and then the
screen shows hundreds of lines of the SQL and no data is updated.
Srimanta
- Original Message -
From: Mosh Teitelbaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:03 PM
Subject: RE: Time Required for Updating DB
Thanks Mosh
Yup. 8^)
I am trying to update price field in Table named
Product with values
from
field newprice in Table named New. The primary key in
both the tables is
dealerpart no (Text) which is unique.
Note: All the records need to be updated
CFQUERY name=UpdatePrice Datasource=XYZ
Select New.newprice,New.dealerpartno,New.publisher,
Product.publisher,Product.dealerpartno,Product.price
From New,Product
/CFQUERY
cfloop query=UpdatePrice
Update Product
SET Product.price= #UpdatePrice.newprice#
WHERE Product.dealerpartno = #UpdatePrice.dealerpartno#
/cfloop
Note: There are 2 records in both the tables.
Srimanta:
There are a few problems here. The first is with your
SELECT query:
Select
New.newprice,
New.dealerpartno,
New.publisher,
Product.publisher,
Product.dealerpartno,
Product.price
From
New,
Product
This query (aside from producing two dealerpartno
columns) does not
specify how to join the two tables. It therefore creates
(if I remember
the
terminology correctly) a Cartesian Product of the two
tables. This is,
essentially, a result set of every single possible
combination of the
records from each table. For example, if your 2 tables
had the following
data:
New.newPrice Product.price
=
a 1
b 2
the result set would be:
newPrice price
=
a 1
a 2
b 1
b 2
So, since both of your tables have 20,000 records, your
SELECT query is
returning a result set with 20,000 x 20,000 records
(400,000,000 records).
Looping 400 million times is probably what's taking so long 8^).
Instead, your query should look something like:
SELECT
New.newprice,
New.dealerpartno AS newDealerPartNo,
New.publisher AS newPublisher,
Product.publisher AS oldPublisher,
Product.dealerpartno AS oldDealerPartNo,
Product.price
FROM
New,
Product
WHERE
New.dealerPartNo = Product.dealerPartNo
This query will produce a result set with only 20,000
records (assuming
there's a 1-to-1 match of the part numbers in the 2 tables).
All that said, I don't think you need the join in the
SELECT query. It
might be enough to change your code to the following:
CFQUERY NAME=UpdatePrice DATASOURCE=XYZ
SELECT
newprice,
dealerpartno
FROM
New
/CFQUERY
CFTRANSACTION
CFLOOP QUERY=UpdatePrice
UPDATE Product
SET price= #newprice#
WHERE dealerpartno = #dealerpartno#
/CFLOOP
/CFTRANSACTION
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
OT: Primary Keys Duplicate Values
Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Primary Keys Duplicate Values
Thanks Field 1 represents model number of products which should be unique. However due to some error in data entry some of the records are duplicate. I can safely delete those records. Srimanta - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:52 PM Subject: RE: Primary Keys Duplicate Values Yep, your problem is that you have dupes in the column you want to tag as a PK. is Field 1 the only field which is uses dupe values? are the records technically unique or can you safely delete them? -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 10:43 To: CF-Talk Subject: OT: Primary Keys Duplicate Values Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Primary Keys Duplicate Values
Thanks. Yes I understand. What I could do is to combine both modelno and the name of the manufacturer and use them in updates. That should prevent updating the wrong records should the model number not be unique. The problem with using an additional field (perhaps with auto number) is that the table to be updated and the table from which the new values (price etc) will be sourced may not have the same auto number id. Also my table(Table1) will have product data from multiple vendors. Different vendors will have tables where Id values might clash. Srimanta - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:34 AM Subject: RE: Primary Keys Duplicate Values I highly recommend that you don't make Model number your primary key. Add a new field, numeric, and make your primary key a meaningless number that will never change. I've used several products that lock model number and for newer companies where their numbering system evolves, this has been an incredible and preventable pain in the back side. What does everyone else recommend? Andy -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:48 PM To: CF-Talk Subject: Re: Primary Keys Duplicate Values Thanks Field 1 represents model number of products which should be unique. However due to some error in data entry some of the records are duplicate. I can safely delete those records. Srimanta - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:52 PM Subject: RE: Primary Keys Duplicate Values Yep, your problem is that you have dupes in the column you want to tag as a PK. is Field 1 the only field which is uses dupe values? are the records technically unique or can you safely delete them? -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 10:43 To: CF-Talk Subject: OT: Primary Keys Duplicate Values Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Time Required for Updating DB
Hi I am having trouble updating a fairly small size database with approx 2 records. Size in MB is approx 18 MB. Type Access 2000. I am updating one particular column, in all the rows with CF Query and Loop tags. First the program generates : Bad Allocation Error complaining of Virtual memory shortage. I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor. When I increased the Virtual memory size the update seems to be going on for ever!!! Its exactly 5 hours plus now its running. How much time does similar updates take?? Any ideas ?? I have not done this before. Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Update Problem in CF
Hi, I have two tables in a DB containing information about the same products. Table 1 is comprehensive and has complete details about the products. Table 2 has fewer no of fields. The fields common in both Table 1 and Table 2 are productid, modelno, price, details . Table1.price contains the old price. Table2. price is the latest price. I want to update Table1.price with the values in Table2.price and use modelno as the unique value for this update. Can someone please help. My SQL knowlede is very basic. Also what if Table two consists of new products not included in Table 1.? What syntax Should I use? Thanks JB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Application Cf Include
Hi, Is there a way to exlude a file (on a particular cfm template) which is included in the Application.cfm by cfinclude tag. In other words, I have an Application.cfm which includes a header.cfm file by CFINCLUDEtag. Within the same application framework I have a file Special.cfm. I do not want to load the Header.cfm file on this page. But as the application.cfm file includes the header file it is always included in all the other files. I know I can use the cfinclude tag on each and every page individually to include the header page. But as the intranet site has more than 500 templates it seems to be a lot of work just to exclude one page. Any ideas ? Thanks Srimanta - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:51 AM Subject: Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Micro$oft has to stop this s*it... It's getting silly as can be... In the last week we have had to install about 4-6 OS issued patches it seems and now this... These big long winded follow 652 step type ones are at the top of the annoyance list.. It's almost like they are daring us all to flee their stranglehold... Just imagine if this were your car and every day almost you had to take it to the dealer to be serviced... What would you do with that car? Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Zac Spitzer [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 16:42:25 +0200 Subject: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Microsoft Security Bulletin MS02-056 http://www.microsoft.com/technet/treeview/default.asp?url=/technet/s ecurity/bulletin/MS02-056.asp have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000
Classic! sr.. - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 04, 2002 11:37 AM Subject: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 If Microsoft made an airplane would you fly in it? Then why run your business on it? -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 7:52 AM To: CF-Talk Subject: Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Micro$oft has to stop this s*it... It's getting silly as can be... In the last week we have had to install about 4-6 OS issued patches it seems and now this... These big long winded follow 652 step type ones are at the top of the annoyance list.. It's almost like they are daring us all to flee their stranglehold... Just imagine if this were your car and every day almost you had to take it to the dealer to be serviced... What would you do with that car? Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Zac Spitzer [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 16:42:25 +0200 Subject: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Microsoft Security Bulletin MS02-056 http://www.microsoft.com/technet/treeview/default.asp?url=/technet/s ecurity/bulletin/MS02-056.asp have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CF Mail Problem..
Hi Sabir
Many Thanks Mate..
It Works
S..
- Original Message -
From: Ryan Sabir [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 6:25 PM
Subject: RE: CF Mail Problem..
Thats how CFMAIL is supposed to work when you pass a query to it.
What you should do is use a CFLOOP query=queryname inside your
CFMAIL content section to output the data you need in the table.
bye!
---
Ryan Sabir
Newgency Pty Ltd
2a Broughton St
Paddington 2021
Sydney, Australia
Ph (02) 9331 2133
Fax (02) 9331 5199
Mobile: 0411 512 454
http://www.newgency.com/index.cfm?referer=rysig
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 1 October 2002 2:51 PM
To: CF-Talk
Subject: CF Mail Problem..
Hello Forum,
Need Help.
I am trying to send data generated by a query using CFMAIL tag to a
recepient whose email is obtained from a Form.
However Instead of including and sending only one email
containing all the
rows returned by the query to the email address obtained
from the Form in
the previous page CFMAIL is sending multiple emails to the
same email
address
--one email for each record generate from the query. Thus each email
contains only one seperate record.
I cant understand why?
The recepient email address comes from the Form. The
contents of the email
is generated by the db query.
Any help will be much appreciated.
This is my code:
CFQUERY name= Get_Products DataSource=XYZ
Select * FROM Products WHERE product id=#Form.productid#
/CFQUERY
cfmail query=Get_Products
to=#Form.Email_Address#
from=myemail.com
subject=Product
type=HTML
!--- The variables #productid# and #Email_Address# come
from the Previous
Page (Form.cfm).
Table
TR
TD Productid: Get_Products.productid BR /TD
TDDetails: Get_Products.details BR /TD
TDModel : Get_Products.modelno BR /TD
/TR
/Table
/cfmail
The purpose is to send more details about the product
selected by the user
in the Form.cfm Page.
Thanks
Srimanta
- Original Message -
From: jon hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 4:13 PM
Subject: Re: Using Java nulls in CF?
For anyone wondering...with smaller files it really
doesn't matter,
but with a 2.3MB IIS logfile, the Java ReadLine method is
about 30-40
percent faster than the old standby looping over the file
as a string
using chr(10) as a delimiter.
--
jon
mailto:[EMAIL PROTECTED]
Monday, September 30, 2002, 11:43:44 PM, you wrote:
jh Actually I didn't even think of using isDefined(), and I think
jh you answered my question without knowing it :).
jh All I really wanted to do was use java's readLine()
method, but
jh readLine returns a null when the last line has been
read. So I stuck
jh isDefined() in there an voila! It worked.
jh cfscript
jh fr = createObject(java, java.io.FileReader);
jh br = createObject(java, java.io.BufferedReader);
jh fr.init(filename);
jh br.init(fr);
jh line = br.readLine();
jh while (isDefined(line)) {
jh writeOutput(line 'br');
jh line = br.readLine();
jh }
jh fr.close();
jh br.close();
jh /cfscript
jh Now I'm going to see if this is any faster than
looping over line
jh breaks in a string. I hope so after all I tried to
get this to work :)
__
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: CF Mail Problem..
Thanks The code is working.
However there is still one problem.
The email sent is in html format and includes images within the html tables.
How do I ensure that the images are sent to email addresses along with the
html tables.
At the moment the images are not visible. I am using Outlook express.
Any ideas?
Thanks again
Srimanta
- Original Message -
From: Joel Nath [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 7:11 PM
Subject: RE: CF Mail Problem..
Hi Srimanta,
try something like...
CFQUERY name= Get_Products DataSource=XYZ
Select * FROM Products WHERE product id=#Form.productid#
/CFQUERY
cfmail to=#Form.Email_Address#
from=myemail.com
subject=Product
type=HTML
Table
cfloop query=Get_Products
TR
TD Productid: #Get_Products.productid# BR /TD
TDDetails: #Get_Products.details# BR /TD
TDModel : #Get_Products.modelno# BR /TD
/TR
/cfloop
/Table
/cfmail
hth
joel
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 1 October 2002 2:51
To: CF-Talk
Subject: CF Mail Problem..
Hello Forum,
Need Help.
I am trying to send data generated by a query using CFMAIL tag to a
recepient whose email is obtained from a Form.
However Instead of including and sending only one email containing all
the
rows returned by the query to the email address obtained from the Form in
the previous page CFMAIL is sending multiple emails to the same email
address
--one email for each record generate from the query. Thus each email
contains only one seperate record.
I cant understand why?
The recepient email address comes from the Form. The contents of the email
is generated by the db query.
Any help will be much appreciated.
This is my code:
CFQUERY name= Get_Products DataSource=XYZ
Select * FROM Products WHERE product id=#Form.productid#
/CFQUERY
cfmail query=Get_Products
to=#Form.Email_Address#
from=myemail.com
subject=Product
type=HTML
!--- The variables #productid# and #Email_Address# come from the Previous
Page (Form.cfm).
Table
TR
TD Productid: Get_Products.productid BR /TD
TDDetails: Get_Products.details BR /TD
TDModel : Get_Products.modelno BR /TD
/TR
/Table
/cfmail
The purpose is to send more details about the product selected by the user
in the Form.cfm Page.
Thanks
Srimanta
- Original Message -
From: jon hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 4:13 PM
Subject: Re: Using Java nulls in CF?
For anyone wondering...with smaller files it really doesn't matter,
but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40
percent faster than the old standby looping over the file as a string
using chr(10) as a delimiter.
--
jon
mailto:[EMAIL PROTECTED]
Monday, September 30, 2002, 11:43:44 PM, you wrote:
jh Actually I didn't even think of using isDefined(), and I think
jh you answered my question without knowing it :).
jh All I really wanted to do was use java's readLine() method, but
jh readLine returns a null when the last line has been read. So I stuck
jh isDefined() in there an voila! It worked.
jh cfscript
jh fr = createObject(java, java.io.FileReader);
jh br = createObject(java, java.io.BufferedReader);
jh fr.init(filename);
jh br.init(fr);
jh line = br.readLine();
jh while (isDefined(line)) {
jh writeOutput(line 'br');
jh line = br.readLine();
jh }
jh fr.close();
jh br.close();
jh /cfscript
jh Now I'm going to see if this is any faster than looping over line
jh breaks in a string. I hope so after all I tried to get this to work
:)
__
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
CF Mail Problem..
Hello Forum,
Need Help.
I am trying to send data generated by a query using CFMAIL tag to a
recepient whose email is obtained from a Form.
However Instead of including and sending only one email containing all the
rows returned by the query to the email address obtained from the Form in
the previous page CFMAIL is sending multiple emails to the same email
address
--one email for each record generate from the query. Thus each email
contains only one seperate record.
I cant understand why?
The recepient email address comes from the Form. The contents of the email
is generated by the db query.
Any help will be much appreciated.
This is my code:
CFQUERY name= Get_Products DataSource=XYZ
Select * FROM Products WHERE product id=#Form.productid#
/CFQUERY
cfmail query=Get_Products
to=#Form.Email_Address#
from=myemail.com
subject=Product
type=HTML
!--- The variables #productid# and #Email_Address# come from the Previous
Page (Form.cfm).
Table
TR
TD Productid: Get_Products.productid BR /TD
TDDetails: Get_Products.details BR /TD
TDModel : Get_Products.modelno BR /TD
/TR
/Table
/cfmail
The purpose is to send more details about the product selected by the user
in the Form.cfm Page.
Thanks
Srimanta
- Original Message -
From: jon hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 4:13 PM
Subject: Re: Using Java nulls in CF?
For anyone wondering...with smaller files it really doesn't matter,
but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40
percent faster than the old standby looping over the file as a string
using chr(10) as a delimiter.
--
jon
mailto:[EMAIL PROTECTED]
Monday, September 30, 2002, 11:43:44 PM, you wrote:
jh Actually I didn't even think of using isDefined(), and I think
jh you answered my question without knowing it :).
jh All I really wanted to do was use java's readLine() method, but
jh readLine returns a null when the last line has been read. So I stuck
jh isDefined() in there an voila! It worked.
jh cfscript
jh fr = createObject(java, java.io.FileReader);
jh br = createObject(java, java.io.BufferedReader);
jh fr.init(filename);
jh br.init(fr);
jh line = br.readLine();
jh while (isDefined(line)) {
jh writeOutput(line 'br');
jh line = br.readLine();
jh }
jh fr.close();
jh br.close();
jh /cfscript
jh Now I'm going to see if this is any faster than looping over line
jh breaks in a string. I hope so after all I tried to get this to work :)
__
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
