Re: Upgrade from Win2K to Windows 2008
Are you running ColdFusion 8 on a Windows 2008 Server w/IIS7 in 64 bit? Is that even possible? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upgrade from Win2K to Windows 2008
I've been on the phone (getting the run around) with Adobe all day. They do Officially support the Win2008/CF8 configuration. I havenât been able to verify it's truly 64bit though. In their 8.01 update installation instructions (released only yesterday) it states: The 64 bit installer for windows is CF801_Win64.exe. Unfortunately, I havenât been able to locate that file. I think you need the enterprise version to download it. Unfortunately ,I've only got the standard edition. But I'll keep hammering Adobe until they cough it up! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFHTTP Connection Failure
Hi, I have written a rather complex CFHTTP method POST agent and constantly am receiving the Connection Failure output. My CF file with the cfhttp tag resides on the local host and the page being "POST(ed)" is remote. When display the #CFHTTP.ResponseHeader# the following error is displayed : Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. The error occurred while processing an element with a general identifier of (#CFHTTP.ResponseHeader#), occupying document position (26:1) to (26:23). I then made a simple CFHTTP method = get that requested a blank page on the local computer/local drive and directory. I receive the SAME error. The page being requested just outputs HELLO WORLD..and I still receive the Connection Failure error. I can't figure this out. I have done several other CFHTTP tags before with no problems. Any help would be much appreciated. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP
Hi, I have written a rather complex CFHTTP method POST agent and constantly am receiving the Connection Failure output. My CF file with the cfhttp tag resides on the local host and the page being "POST(ed)" is remote. When display the #CFHTTP.ResponseHeader# the following error is displayed : Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. The error occurred while processing an element with a general identifier of (#CFHTTP.ResponseHeader#), occupying document position (26:1) to (26:23). I then made a simple CFHTTP method = get that requested a blank page on the local computer/local drive and directory. I receive the SAME error. The page being requested just outputs HELLO WORLD..and I still receive the Connection Failure error. I can't figure this out. I have done several other CFHTTP tags before with no problems. Any help would be much appreciated. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Variable Names
Hi, In this example I have two pages...with a form post inbetween. The first page has a lot of text boxes called ID1 to ID16 (so, 16 in total ;) ).these boxes are in a database loop (thus the number to differentiate them). Also over time the number may change from 16 to 18 etc..so there may be more text boxes. I also pass this total number (16) to the second page in a hidden field. On the second page I want to evaluate the value for each one..but as the total number is not a constant I need to do a loop. The following code is what I have come up with : cfoutput cfloop from="1" to="#Form.TotalEvents#" index="i" #I# cfset varname ="Form.ID#i#" cfif #varname# eq "Custom"#varname# = Custom/cfifbr /cfloop /cfoutput .end code. What this is SUPPOSED to be doing is checking if the passed VALUE for Form.ID1 (through 16) equals "Custom", and if so it does something, else something else... but what it is doing is a literal comparison, so there are NEVER any true results to the if statement, when infact with my current code 11 out of 12 should return true. Can someone help me with this...it may be trivial to some of you..but I need to get around this ASAP. Thanks heaps!!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
String manipulation
Hi, I am trying to write a web-agent. So far I have automated the agent to go to a URL and do a HTTP get on a text file, which is thus stored in cfhttp.filecontent. The text file contains a list, seperated on a line eg : string1 string2 string3 ... string40 string2000 etc. I am wanting to take 30 lines at a time, no more no less..and read them in and process them seperately..then read the NEXT 30 lines etc, etc... NB..I don't want to lose the formating (ie..want to keep them with a char return/linefeed between them..as the nextprocessing steps requires them to be kept on seperate lines... ...The next step will take these 30 lines in to a HTTP post..they will be fed in to a multiline text box (hence the need to keep them on seperate lines). Hope this makes sense. It would be great if you could help me out..give me some sample code..names of functions taht I will need to do this..or all of the above..thanks :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: String manipulation
Thanks for that, I know most of the string functions...but how do I do a mid (string,start,end) which starts at the beginning of a line, and gets a copy of the complete line...and then repeat this for every line in the text file?? I guess i don't know how I can determine thevales for the start, end params. Any ideas? From: "Joseph Thompson" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: String manipulation Date: Tue, 12 Dec 2000 17:05:39 -0800 It would be great if you could help me out..give me some sample code..names of functions taht I will need to do this..or all of the above..thanks :-) These are what I call the "string operator" functions. You will need most of these. http://cfhub.com/language/INDEX.CFM?Cat=String%20Operators Also, pull the whole file with CFHTTP, and save it. then just use CFFILE for the rest. Of particular interest are the Find() and mid() functions. This is a script that pulls/parses data: http://cfhub.com/advanced/cfhttp/post.cfm and I have many more : ) Parsing is kind of a hobby of mine... If you like, email me off list... [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String manipulation
Thanks again, That looks closer to what I want.. ...so when in the loop how do I parse the current line.. eg..check the current line for certain characters, and if it passes the check I copy the string to a new entry in an array. From: "Steve Bernard" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: String manipulation Date: Wed, 13 Dec 2000 00:56:36 -0500 If you're trying to parse a text file line by line, it's typically done by looping over the file, as a list, using an appropriate EOL character(s) as the delimiter. In this case I'll use ASCII character 13, the carriage return. Try something like this (if it's what you need): CFSET int_count = 0 CFLOOP List="#FileContents#" Delimiters="#Chr(13)#" Index="idx" CFSET int_count = (int_count + 1) CFOUTPUT !--- 'idx' will be a line of the file --- !--- Ex. Line 1: This is the first line. Line 2: This is the second line. --- Line #int_count#: #idx#br /CFOUTPUT /CFLOOP Steve -Original Message- From: Martin S [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 11:04 PM To: CF-Talk Subject: Re: String manipulation Thanks for that, I know most of the string functions...but how do I do a mid (string,start,end) which starts at the beginning of a line, and gets a copy of the complete line...and then repeat this for every line in the text file?? I guess i don't know how I can determine thevales for the start, end params. Any ideas? From: "Joseph Thompson" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: String manipulation Date: Tue, 12 Dec 2000 17:05:39 -0800 It would be great if you could help me out..give me some sample code..names of functions taht I will need to do this..or all of the above..thanks :-) These are what I call the "string operator" functions. You will need most of these. http://cfhub.com/language/INDEX.CFM?Cat=String%20Operators Also, pull the whole file with CFHTTP, and save it. then just use CFFILE for the rest. Of particular interest are the Find() and mid() functions. This is a script that pulls/parses data: http://cfhub.com/advanced/cfhttp/post.cfm and I have many more : ) Parsing is kind of a hobby of mine... If you like, email me off list... [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
unknown parser error
I am having this error, I can't see what the problem is. It works on my computer, and haven't had this problem before. I can't see a problem in the code, and is I said it works on my PC, and I have set it up here, the same as it is on cfm-resources!! Please help!! :-) ERROR : Below as seen on www.unrealdomainnames.com Error Diagnostic Information Just in time compilation error unknown parser error The last successfully parsed CFML construct was the CFML template beginning occupying document position (1:1) to (1:1). The specific sequence of files included or processed is: C:\Inetpub\cfm-resources.com\web\u\UnrealDomainNamesForSale\Main.cfm Date/Time: 11/20/00 05:41:24 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 139.134.27.67 HTTP Referer: http://www.unrealdomainnames.com/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF HOST for XXX content
The site will be a free site, so all are welcome to test it :-) i fyou want I can let you know when it goes to air, so to speak...yell out if you want me to notify you, and how to conact you : email preferably..more testers and evaluators the better. just drop an email to me at [EMAIL PROTECTED] As for hosters, I need to know more about your security features, firewall, security for our CFML code and database content..so ONLY we can see it, and know that it won't be ripped off - assuming it will be a successful site...esp..as data is a avaluable commodity...anyway all you CF Hosting companies that allow XXX content send me specs, plans for hosting a site if you can guarantee that our CFML/DB files will be for our (the developers) eyes only. Minimum req we can think of at the moment : SMPTP/POP email - 10 - unlimited...unlimited better, but 10 is OK. Automation - allows auto jobs to take place. CF4.5 - speaks for itself Member Areas - pop-up password control for membership directories - may be needed in the future. SQL7 or some other such non-Access, high-performance DB. Unlimited upload/doanload bandwidth. 100+ megs of storage...unlimited ios better, although we don't see that we will need much more than 100-200mb, but to have reserves is best. Potential need for real video...real video is not needed in the near future. Access to the usual administration tools found on hosting sites. Any other benefits/perks so to speak..list them. Fast server (non dedicated at the moment), and high bandwidth connections...as our customers won't want to wait around all day. The usual minimum requirements as well. Let me know what you can offer in this and send me an email to [EMAIL PROTECTED] - a $$ approx. would be good, and a list of all these things mentioned above that you can, and can't do for the price..as well as any extras that are standard, and any extras that aren't standard...monthly prices are what we are looking for,and prefer no minimum contract..so we can bail when we want if we aren't satisfide. Hope to hear from you soon, so we can decide. Martin. From: "Martin S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CF HOST for XXX content Date: Sun, 19 Nov 2000 02:11:55 GMT Anybody know of CF HOSTING SITES that allow XXX content? If so a list of a them would be great so I can compare them...also any personal recommendations would be great. More the meria!! From: "Brian L. Wolfsohn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: What's running on my machine Date: Sat, 18 Nov 2000 18:44:27 -0500 IS it possible to have a .cfm template return the names of all applications created with cfapplication currently running on a given machine ?? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF HOST for XXX content (cont)
Ohh yeah, and with 10+ already registered domain names pointing to ithe site. and any site promotion that you can do for the price (search engine stuff - close to top listing, and other means). Cheers. From: "Martin S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CF HOST for XXX content Date: Mon, 20 Nov 2000 01:09:56 GMT The site will be a free site, so all are welcome to test it :-) i fyou want I can let you know when it goes to air, so to speak...yell out if you want me to notify you, and how to conact you : email preferably..more testers and evaluators the better. just drop an email to me at [EMAIL PROTECTED] As for hosters, I need to know more about your security features, firewall, security for our CFML code and database content..so ONLY we can see it, and know that it won't be ripped off - assuming it will be a successful site...esp..as data is a avaluable commodity...anyway all you CF Hosting companies that allow XXX content send me specs, plans for hosting a site if you can guarantee that our CFML/DB files will be for our (the developers) eyes only. Minimum req we can think of at the moment : SMPTP/POP email - 10 - unlimited...unlimited better, but 10 is OK. Automation - allows auto jobs to take place. CF4.5 - speaks for itself Member Areas - pop-up password control for membership directories - may be needed in the future. SQL7 or some other such non-Access, high-performance DB. Unlimited upload/doanload bandwidth. 100+ megs of storage...unlimited ios better, although we don't see that we will need much more than 100-200mb, but to have reserves is best. Potential need for real video...real video is not needed in the near future. Access to the usual administration tools found on hosting sites. Any other benefits/perks so to speak..list them. Fast server (non dedicated at the moment), and high bandwidth connections...as our customers won't want to wait around all day. The usual minimum requirements as well. Let me know what you can offer in this and send me an email to [EMAIL PROTECTED] - a $$ approx. would be good, and a list of all these things mentioned above that you can, and can't do for the price..as well as any extras that are standard, and any extras that aren't standard...monthly prices are what we are looking for,and prefer no minimum contract..so we can bail when we want if we aren't satisfide. Hope to hear from you soon, so we can decide. Martin. From: "Martin S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CF HOST for XXX content Date: Sun, 19 Nov 2000 02:11:55 GMT Anybody know of CF HOSTING SITES that allow XXX content? If so a list of a them would be great so I can compare them...also any personal recommendations would be great. More the meria!! From: "Brian L. Wolfsohn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: What's running on my machine Date: Sat, 18 Nov 2000 18:44:27 -0500 IS it possible to have a .cfm template return the names of all applications created with cfapplication currently running on a given machine ?? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at
CF HOST for XXX content
Anybody know of CF HOSTING SITES that allow XXX content? If so a list of a them would be great so I can compare them...also any personal recommendations would be great. More the meria!! From: "Brian L. Wolfsohn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: What's running on my machine Date: Sat, 18 Nov 2000 18:44:27 -0500 IS it possible to have a .cfm template return the names of all applications created with cfapplication currently running on a given machine ?? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF UNICODE - UTF-5
Does anyone know if there is any way in coldfusion to convert from Japanese characters to UTF-5? Or if there is in wbe-site / software that can do such conversions? Any help would be appreciated majorly. Martin. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cfm-resources, security
Hi guys, What woul you say about the security of hosting a site for free with cfm-resources.com? The site will contain the very basic membership details in a DB (username, poassword, email) and that is probably all. Anyway if I looked to add more to the DB in the future, would you recommend m,oving away from cfm-resources, or is cfm-resources as secure as any pay-per site hosting company? Any thoughts, opinions would be appreciated. I am just concerned about the ez of hacking that may be opened up with going with a free host. Also if anybody knows anything about the security of www.freeservers.com - the name speaks for itself. Cheers, Martin. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cfm-resources, security
Hi guys, What woul you say about the security of hosting a site for free with cfm-resources.com? The site will contain the very basic membership details in a DB (username, poassword, email) and that is probably all. Anyway if I looked to add more to the DB in the future, would you recommend m,oving away from cfm-resources, or is cfm-resources as secure as any pay-per site hosting company? Any thoughts, opinions would be appreciated. I am just concerned about the ez of hacking that may be opened up with going with a free host. Also if anybody knows anything about the security of www.freeservers.com - the name speaks for itself. Cheers, Martin. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
message not posting
My message below doesn't seem to have been posted : Hi guys, What woul you say about the security of hosting a site for free with cfm-resources.com? The site will contain the very basic membership details in a DB (username, poassword, email) and that is probably all. Anyway if I looked to add more to the DB in the future, would you recommend m,oving away from cfm-resources, or is cfm-resources as secure as any pay-per site hosting company? Any thoughts, opinions would be appreciated. I am just concerned about the ez of hacking that may be opened up with going with a free host. Also if anybody knows anything about the security of www.freeservers.com - the name speaks for itself. Cheers, Martin. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
FREE CF HOSTING - EXIST??
G'day guys/gals (and everybody else), Can you point me in the direction of any FREE (not just trial, but for ever) CF Hosting sites...as well a quick overview of what they allow, and don't allow, other restrictions, and if they place banner ads etc on your page...and any other details..don't have to tell me the price, and I am hoping the are free!! Cheers, From down under. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
ODBC Error Code = S0002 (Base table not found)
Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Thanks, Martin. From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 21:15:15 -0500 If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message ----- From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
Re: ODBC Error Code = S0002 (Base table not found)
I have.. The thing is I am doing the Cold Fusion remotely on a different computer on the network. I have set up the remote computer (where the Code and DB is stored) datasource settings in Both NT and ColdFusion Admin..as well a the local computer (my pc) datasource settings in both NT and ColdFusion Admin. I am not sure if this is over-kill or required but as I said I am new to using a DB other than Acss (which I haven't had many problems with before) and working remotely, so to speak. Thanks, Martin. From: [EMAIL PROTECTED] (Brian bouldernet) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:25:14 -0700 Hey... to make it simple go through Cold Fusion ODBC. do this by pointing your browser to something like http://yourserver.com/cfide/Administrator/index.cfm Create the ODBC that way... - Original Message - From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 7:15 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: ...
Re: ODBC Error NO MORE
ALAS, Your a legend, it works now!! Thanks..I can progress to another problem no doubt :-) Cheers mate. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 19:19:36 -0800 cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]