Managment
Does anyone know of a component or dll built for cf that would allow one to monitor services on network servers? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:OpenRowset Help
I know that, I am running that code in a stored procedure.What I want to know is how do I put correct information in the code to accept a domain id and pass. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cf stored proc
I am an update query jn a stored proc but am receiving an error before it even reaches the proc. cfprocparam type=In cfsqltype=CF_SQL_CHAR dbvarname=@con_eml_adr_te value=#con_eml_adr_te# null=No con_eml_adr_te is an email address like [EMAIL PROTECTED] I receive an error saying that the con_eml_adr_te is not supplied. I know that it is because if I output it on the page it is there. I put evaluate around the value and it says there is an error near the @ symbol. This works fine on my insert but fails on the update. Please Help Joshua Tipton ~| 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
RE: Medical Financial Enterprise Applications CF Security
http://www.mydatavault.net/ CF in medical field On Mon, 16 Dec 2002, Oliver Cookson wrote: snip Can anyone provide specific links. press releases, information regarding the security plus's / minuses and again - the success rate of Cold Fusions implementation on large scale, secure, mission-critical applications in the medical and/or financial industries? Have a look at www.cffaq.com written by Ben Forta. Answers a lot of questions. Thanks ~| 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
Java script ot help
I have a page that passes the projected to another page to delete the subproject. When it opens the window and deletes the project it then refreshes the parent window. I am trying to use this function to expand the project by using the click() method. Below is the code and the button is called OpenButton1 plus the projected. Please help. Below is the code that I was trying to use without success. Joshua Tipton window.opener.document.OpenButton1#projectid#.click(); ~| 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: Running ASP on a server used for CF
Make sure you have sql authentication turned on on your sql server. -Original Message- From: Haggerty, Mike [mailto:MHaggerty;mbda.gov] Sent: Monday, November 04, 2002 4:15 PM To: CF-Talk Subject: RE: Running ASP on a server used for CF Here's what Microsoft says about the issue: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q186726; -Original Message- From: Clark, Aimee [mailto:aclark;stinsonmoheck.com] Sent: Monday, November 04, 2002 4:07 PM To: CF-Talk Subject: Running ASP on a server used for CF I have a situation in which I will begin coding some pages in ASP vs CF and I plan to do so on the same IIS server that my CF is running on. Because of the way that the server has been configured, I am curious to know if there is anything I need to be aware of if I plan to do this. So far, I have run into a problem when trying to run an ASP page and it generates a SQL error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. /isweb/pdissues/addIt.asp, line 11 Now, I have gone back and setup an ODBC connection with SQL authentication and no luck. Also on the IIS server the NT authentication is how we have it setup because we use an intranet on this server and we use NT authentication in a lot of the code we generate. So, if anyone has any insight into what I should be aware of, I would really appreciate it. I'm just trying to understand why I am receiving this error and if it's the result of trying to code ASP on a server with CF. Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~| 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
SQL HELP
For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| 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: SQL HELP
Still returns zero rows. Josh -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:38 AM To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| 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: SQL HELP
Both char(10) I can change them to int is you think it would make a difference. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:44 AM To: CF-Talk Subject: RE: SQL HELP shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| 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
RE: SQL HELP
The column is char 10 when I change it to int it truncates my numbers so I do not want that. Josh -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:59 AM To: CF-Talk Subject: RE: SQL HELP yes it may - unless you put ltrim(rtrim()) around the field values - change to an int and see what hapens -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:52 To: CF-Talk Subject: RE: SQL HELP Both char(10) I can change them to int is you think it would make a difference. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:44 AM To: CF-Talk Subject: RE: SQL HELP shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| 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: SQL HELP FIXED
I put this where statment in and it fixed the problem. The emp_id_nr in tblemployee was null for empnr starting with six zeros. Josh DELETE FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee where emp_nr not like '00%')) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:53 AM To: CF-Talk Subject: Re: SQL HELP Joshua Tipton wrote: For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. I doubt that rewriting as a join is going to solve anything. That would be a bug of a size that would be known, and it is not unlikely your database does that internally anyway. Maybe better to start looking if SYS_EMP_ID_NR and emp_id_nr don't have any NULL's, have the same datatype, are padded the same way or something. SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) Rewriting that requires an OUTER JOIN, which might be less than efficient. But if you want to try: SELECT job.* FROMtemptblJOBEVL job LEFT JOIN tblemployee emp ON job.SYS_EMP_ID_NR = emp.emp_id_nr WHERE emp.emp_id_nr IS NULL I prefer the NOT EXISTS syntax, I think it is easier to read: SELECT job.* FROMtemptblJOBEVL job WHERE NOT EXISTS ( SELECT 1 FROMtblemployee emp WHERE job.SYS_EMP_ID_NR = emp.emp_id_nr ) All should return the same results, but have fun :) 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: sql for creating access memo field?
desc is a reserved word [desc] is okay. Joshua Tipton -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:35 PM To: CF-Talk Subject: sql for creating access memo field? Can anyone tell me the sql for creating a memo field in a table (Access database)? This obviously does not work: CFQUERY NAME=create DATASOURCE=#ds# CREATE TABLE temp (tapeid number PRIMARY KEY, Title char(255), Desc memo) /cfquery Thanks, Les ~| 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.
OT SQL DTS
I would like to create an id that can only login in to enterprise manager and run dts pacakges is this possible? SQL 7.0. Thanks, Joshua Tipton ~| 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
RE: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 200 0
Red hat 8.0 free support = 0 XP Upgrade 160.00 support = Yes within 30 days of purchase -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 12:05 PM To: CF-Talk Subject: RE: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 200 0 XP upgrade = $160.00 Red Hat 8.0 = Free That is such a poor argument, cost should not come into it; features, functionality, stability and performance should come first - but then I suppose you will argue that red is blue to make your case against the great Jedi Gates. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 16:59 To: CF-Talk Subject: OT: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 No, probably not. On the other hand, I wouldn't feel too comfortable flying the build-your-own-airplane kit from that Linus guy, either. Build-your-own-airplane? That's an odd analogy. Have access to the engine and all the working parts of the airplane I think is better analogy. Nor would I want to fly Sun or Oracle, but that's OK, since I wouldn't be able to afford the ticket. Sun and Oracle make rather solid products. I would feel much more comfortable flying in a Sun airplane then a Microsoft airplane. Plus, since Microsoft makes operating systems, keyboards, mice, game stations, office software, and games - they are more likely to enter the airplane arena. Who could afford the ticket? Try being a common developer (CTO). :) I'd hardly argue that Microsoft products are perfect, or even best-of-breed in most cases. However, they often provide a happy medium of comparative value. XP upgrade = $160.00 Red Hat 8.0 = Free Yeah, I can totally see the return on investment. I suspect that most people on this list have little choice about what products their companies or clients use. No doubt there. If that were the case, we probably would be in such financial trouble. It was just a joke anyway. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 6:19 AM To: CF-Talk Subject: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 If Microsoft made an airplane would you fly in it? No, probably not. On the other hand, I wouldn't feel too comfortable flying the build-your-own-airplane kit from that Linus guy, either. Nor would I want to fly Sun or Oracle, but that's OK, since I wouldn't be able to afford the ticket. Sad to say, I'd probably end up flying the damn Mac - at least the furnishings are nice. To flip this on its head, I probably wouldn't use a GM or Ford computer or OS, either - it would require huge amounts of gasoline, I'm sure, and would have the best technology of 1987. My point here is that your comment, while it may be glib and entertaining, is a facile and useless comparison. Then why run your business on it? I'd hardly argue that Microsoft products are perfect, or even best-of-breed in most cases. However, they often provide a happy medium of comparative value. In any case, though, I suspect that most people on this list have little choice about what products their companies or clients use. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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: more cfstoredproc issues ...
I do not know if this may be the underlying cause of the error but I do know that if sql is your database you cannot use timestamp as the datatype when you are passing in a date time field. It has to be CF_SQL_DATE. There was a disscusion about this on here last week but I think the person having the problem was using CFMX and M$SQL. Hope this helps you out and that I didnt misunderstand that whole think last week. Josh -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 7:31 AM To: CF-Talk Subject: RE: more cfstoredproc issues ... ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** YOu can comment out the call to the stored procedure and then output all the variables you are passing, then use a CFABORT to stop the page this way you'll be sure the correct variables are being passed. Or for testing purposes hard-code a value in the LibraryID cfprocparam tag, if it does get passed in correctly then you will know that the problem is the stored procedure and not your CF. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 02:34 To: CF-Talk Subject: more cfstoredproc issues ... Argh! I have a stored procedure with parameters as: CREATE PROCEDURE tap_adLibUpdate @LibraryID int, @Ident int, @UpdatedDate datetime, @PageFileName varchar(15) = NULL, @ArchivePath varchar(15) = NULL, @Scheduled bit = 0, @RestoreID int = NULL, @UpdateError varchar(8000) = NULL AS and I'm using this code in CF: cfstoredproc procedure=tap_adLibUpdate datasource=#request.tap.dsn# username=#request.tap.dsnusr# password=#request.tap.dsnpwd# cfprocparam type=in dbvarname=LibraryID value=#variables.PageID# cfsqltype=cf_sql_integer cfprocparam type=in dbvarname=Ident value=#Request.User.ID# cfsqltype=cf_sql_integer cfprocparam type=in dbvarname=UpdatedDate value=#CreateODBCDate(Now())# cfsqltype=cf_sql_timestamp !--- indicates the file name for a top level container -- file extension may change although file name is consistent --- cfprocparam type=In dbvarname=PageFileName value=#variables.tempfilename# cfsqltype=cf_sql_varchar null=#yesnoformat(not rspage.istoplevelcontainer)# !--- archive path indicates where restoring content is being restored from -- cfprocparam type=in dbvarname=ArchivePath value=#variables.archivepath# cfsqltype=cf_sql_varchar null=#yesnoformat(not request.tap.archivecontent)# cfprocparam type=In dbvarname=Scheduled value=0 cfsqltype=cf_sql_bit cfprocparam type=in dbvarname=restoreid value=#variables.restoreid# cfsqltype=cf_sql_integer null=#yesnoformat(IsDate(attributes.RestoreFromDate))# cfprocparam type=In dbvarname=UpdateError value=#variables.errormessage# cfsqltype=cf_sql_varchar cfprocresult name=rsupdate resultset=1 /cfstoredproc and I'm getting this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'tap_adLibUpdate' expects parameter '@LibraryID', which was not supplied. I know that the LibraryID parameter is defined in the cfprocparam tags. I know that none of it was misspelled. I know that the value of variables.PageID is an integer. What I don't know is why I'm getting an error message that tells me exactly what the problem is not. Anybody have any ideas? Isaac Dealey Certified Advanced ColdFusion 5 Developer new epoch www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL command - data encryption
hash -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:53 PM To: CF-Talk Subject: SQL command - data encryption Hello - I was just looking for confirmation that a command in SQL does not exist that will encrypt data while inserting or updating into one field. I could not find anything in SQL book online. For example: UPDATE my_tableA SET encrypt(password) FROM my_tableB Thanks, Casey Cook __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mass Database update
run it all in a dts package truncate the table and then use bcp to import the csv file. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:37 AM To: CF-Talk Subject: Mass Database update We have a client that wants to drop a database table and replace it with a new one every once and a while. Is there any dummy proof ways of doing this? Have them upload a CSV, use CFFILE to loop over the information and import it? The data will start as an Excel table. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can't use UNION
What database platform and what version of cf? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:55 PM To: CF-Talk Subject: OT: Can't use UNION I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post it like notes.
There is a cf_postit tag on dev exchange -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:43 PM To: CF-Talk Subject: RE: Post it like notes. if you are looking at the dhtml version, check out dynamicdrive.com they have some great stuff there that might solve your needs. matt -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:24 PM To: CF-Talk Subject: Post it like notes. I am looking for an applet that I can pass multiple records of data, and then there is a next and back button that would be like a small slide show of the data (Which is test) . They would look like small post-its that you pass through. Anyone have any ideas? I guess I could code it up with DHTML and if I don't find anything good I will probably have to resort to that. Neil __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
vtm files
What are vtm files and what do I do with them? Josh __ 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
Output Help
Okay I fell stupid asking this because I have accomplished this many times I just cant rememeber tonight. cfquery name=qry_STATES datasource=CaptekLab SELECT PK_tblSTATEID, State FROM dbo.tblSTATE /cfquery table cfloop query=qry_states cfquery name=qry_labs datasource=CaptekLab SELECT FK_tblSTATEID, Lab_Name, Lab_City, Lap_Phone FROM tblLABS wherefk_tblSTATEID = '#qry_states.pk_tblSTATEID#' /cfquery cfoutput query=qry_labs tr td#qry_states.state#/td td#Lab_name#/td /tr /cfoutput /cfloop /table I want the state name output once and then a list of all the labs for that state IE Alaska Lab1 Lab2 Lab3 Alabama Lab1 Lab2 Lab3 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Output Help
Output one record then bombed with this error The Error Occurred in C:\Inetpub\wwwroot\captek\apps\LabList\showlablist.cfm: line 46 44 : cfoutput query=qr_states group=CaptekLab.state 45 : #qr_states.state#br 46 : cfoutput#qr_states.lab_name#/cfoutput THIS LINE WAS BOLD 47 : /cfoutput 48 : /body -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:17 PM To: CF-Talk Subject: Re: Output Help Try this... I didn't do the caps thing like you are doing but you should get the jist! cfquery name=qr_states datasource=CaptekLab SELECT s.state, l.lab_name FROM tblstate s, tbllabs l WHERE s.pk_tblSTATEID = l.fk_tblSTATEID GROUP BY s.state, l.lab_name /cfquery cfoutput query=qr_states group=CaptekLab.state #qr_states.state#br cfoutput#qr_states.lab_name#/cfoutput /cfoutput Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:10 PM Subject: Output Help Okay I fell stupid asking this because I have accomplished this many times I just cant rememeber tonight. cfquery name=qry_STATES datasource=CaptekLab SELECT PK_tblSTATEID, State FROM dbo.tblSTATE /cfquery table cfloop query=qry_states cfquery name=qry_labs datasource=CaptekLab SELECT FK_tblSTATEID, Lab_Name, Lab_City, Lap_Phone FROM tblLABS wherefk_tblSTATEID = '#qry_states.pk_tblSTATEID#' /cfquery cfoutput query=qry_labs tr td#qry_states.state#/td td#Lab_name#/td /tr /cfoutput /cfloop /table I want the state name output once and then a list of all the labs for that state IE Alaska Lab1 Lab2 Lab3 Alabama Lab1 Lab2 Lab3 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hardware question
Search ebay there is so many .coms that are going under it is hard to build a good server cheaper than what you can get one of the pre built dell or Compaq servers. I just bought a dell 2500 dual p3 1.4, 1gig ram, 5 36 gig scsi drives, 2 network cards, triple redundant power supplies, and a 40/80 gig dlt and paid 4000.00 for it. Server still has 2 years worth or warranty. Josh -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 12:00 PM To: CF-Talk Subject: Re: Hardware question Bud, I suppose this would depend upon if this is a production enviornment or not. One of the many reasons I go with scsi is the fact they have a higher reliability rating than what ide drives have. Another one is the fact that scsi makes better use of command queing, which is to reschedule commands to minimize seek times and maximize throughput. With everything there will be a cost factor involved and only you can warrant the spending of the extra $$. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 3:57 AM Subject: Hardware question If I build a CF Server, say a Dual 1.4Gz P4 with 1 or 2 GB RAM, would I get much a performance hit if I went with a Raid 1 ATA/100 80 GB Dual HDD setup as opposed to SCSI? Curious. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ 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
Export To excel
I am running cf 5 and when I use the following cf content around my code all that is returned is a page formatted for excel. Why does it not ask me to download the file or open the file in excel on my machine? Josh cfcontent type=application/msexcel __ 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
skip rows
On my page layout I would like every other row in the table to be a blank row. Does anyone have any idea how to do this. I am working with mod 2 trying to figure it out. Joshua Tipton __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ot button question
Does anyone know how to create a button that looks like the xp start button with the curves besides using a graphic? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfx_putimage
Has anyone ever used this and if so please contact me off list. I need some instructional help. Thanks, Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
Could be long and painful. I have built and transferred many servers using this and have had zero problems. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:07 PM To: CF-Talk Subject: RE: Migrating sqlservers whoa, interesting idea. I was thinking more allong the lines of copying the db via enterprise manager. Is this a bad idea? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:06 PM To: CF-Talk Subject: RE: Migrating sqlservers First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ 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: WDDX related
The first line of your xml page or whatever you are passing has its designation ie ? Xml blah blah take that line out. Joshua Tipton -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 6:12 PM To: CF-Talk Subject: WDDX related Anyone know what this is all about: WDDX packet parse error at line 1, column -1.. Invalid date string 2-11-30T0:0:0-5:0. The Error Occurred in D:\Dev\Apache\htdocs\_library\cfcs\basic\system_utils.cfc: line 3 1 : cfcomponent 2 : cffunction name=pullPacket access=public output=no 3 : cfwddx action=WDDX2CFML input=#client.user# output=rawPacket 4 : cfreturn rawPacket/ 5 : /cffunction I'm guessing that WDDX has a date/time var associated with it, but ... what's going on here? This code has been working perfect for me for quite some time now and ... finally, 2 months later it decides to give me an issue? I don't understand CFMX sometimes. I'll be coding along just fine and then blam, 5 days later... code that I've already established as finished is now breaking when I haven't touched anything for a good week in it... and, I'm working in an entirely different folder. Thanks, ~Todd Todd Rafferty ([EMAIL PROTECTED]) http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ Moderator @ FlashCFM.com - http://www.flashCFM.com/ Back-end Moderator @ Ultrashock.com - http://www.ultrashock.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
If it only happens every now and again sounds like you have some problems with your SQL Server. You probably need to either, run a trace on the database for the entire day, then run index wizard using the trace file that you created to create some good indexes on your database. Joshua Tipton -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing question
Dts should pull it in no prob -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:42 PM To: CF-Talk Subject: parsing question Hi I hope someone can help me. I have a txt file (copy of a small portion of it below) that I need to be able to output into a database. I'm reading it via cffile but am unsure how to get it into a useable format ie delimiters etc The letters before the pipe are column headings (that's prob obvious) If anyone could help I would be grateful. UR|BC51 AA| AI| TI|MARG - A MAGAZINE OF THE ARTS. Appreciation of the Creative TI|Arts under Maharaja Ranjit Singh. PU|Oxford University Press PP|Sydney DP|n.d. NT|Colour and b/w plates, including some folding, 93pp, 4to, NT|light soiling boards, a good copy. NT|Articles on the arts during the reign of Maharaja Ranjit NT|Singh. ED| BD| PR|35.00 KE|Art KE|India KE|Periodical KE|South Asia XA|4 XB|1 XC|BO XD|S UR|BC117 AA|`ABD AL-LATIF AL-BAGHDADI. AI| TI|The Eastern Key. Kitab Al-Ifadah Wa'l-I`Tibar. PU|Allen and Unwin. PP| DP|1965. NT|Trans. 293pp, index, biblio., Arabic and English text, covers NT|trifle flecked and worn. NT| ED| BD| PR|35.00 KE|Biography KE|Middle East KE|Philosophy KE|Science XA|4 XB|1 XC|BO XD|S UR|BC1147 AA|BARTLETT, ANDERSON G. ET. AL. AI| TI|Pertamina. Indonesian National Oil. PU|Amerasian. PP|Djakarta. DP|n.d. (c.1972). NT|Endpaper maps, ill, xi + 420pp, appendices, selected NT|biographies, biblio, index, d/j little worn, nice copy. NT|History of Pertamina, including chapters on 1965 coup, the NT|New Order, and negotiations with multinational companies. ED| BD| PR|40.00 KE|Economics KE|History KE|Politics KE|South East Asia XA|4 XB|1 XC|BO XD|S __ 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: ODBC Error Code = 08001
Could be a network problem. The web server is able to get to the sql server but the query processor is either not available or kicking connection. Possibly a bad packet. The first thing I would do would be to run a trace on that db all day then run the index tunning wizard. Then I would start checking my sql dump logs and the regular sql logs just to see if sql is screaming something. -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 8:44 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Could it be a network problem? I have another website connecting to the same server with no problems. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:23 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re: Need to optimise query performance
Run a trace on that db saving the trace data to a file while you run your app then run the index tunning wizard -Original Message- To: CF-Talk [EMAIL PROTECTED] From: Jochem van Dieten [EMAIL PROTECTED] Subject: Re: Need to optimise query performance Date: Wed, 26 Jun 2002 13:44:39 +0200 Vishal Narayan wrote: 3. Performance tuning at DB level and database optimisation: I've already tried the following : - primary keys for all tables in use - indexes on all columns used for joins Is there anything else I can do towards performance tuning ? Could I use views to reduce the load on my SQL 2000 DB ? Delete the candidatemaster.cat_id1, candidatemaster.cat_id2 and candidatemaster.cat_id3 columns and use a separate table to connect the candidatemaster table to the category table. That should do away with the need for outer joins and other unwelcome constructions. Jochem __ 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: Getting to an Access DB on a remote machine
I may be wrong and have been befoer but I was always told that netbios is a non-routable protocal -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 3:19 PM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine In order for this to work NetBIOS must be allowed over the network. If you are going over the internet, having NetBIOS ports exposed to the world is a very bad idea. If the endpoint is fixed, you could open up NetBIOS for that single address, however. IMHO, a better option is to pull the DB local and build a web-based data entry tool for the client to use over the network. If the network goes down between the server and the client, only the data entry dies and not the entire application. Data integrity is also greatly enhanced (well, for Access). Regards, Kevin [EMAIL PROTECTED] 06/18/02 12:08PM In theory, you would setup a mapped network drive to the remote machine by using either the DNS name or IP address of the remote machine followed by the name of the shared drive. But if you don't have a T-1 on both ends, the connection speed may be too slow to maintain or even connect. So, for example, if the DNS name of the remote machine was www.fusioneers.com, and the shared drive was public, then you'd setup a network drive with the following path: \\www.fusioneers.com\public From there, you would select it as though the .MDB file was on your local machine since you would have a mapped drive on your local machine. But in practice, I've never seen it work. I tried it with a DSL connection on my end (restricted to 128k upstream) with multiple T-1's on the other end and still couldn't get at it. But you may be able to if you've got a super fast connection. OK so maybe I'm better at networking than CF these days. ;) ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:25 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine How would I do that? I have gone into data sources and looked for where I can set it up by giving it an ip address or whatever, and I can't seem to find it. By remote I don't mean even on the same network, maybe not even in the same country. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:13 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine You can create a DSN on the CF machine that points the access file on the remote machine. Shawn Regan -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 10:02 PM To: CF-Talk Subject: Getting to an Access DB on a remote machine Hey, I was wondering if anyone knew how to get CF to talk to an access DB on a remote machine? Here's my thing. Client buys products from vender. Vender has product list in an access db. Client wants to be able to automatically update it's available product line without waiting for updates. Now I am thinking there should be an easy way to register the Access db as an odbc data source, then on clients machine use that. But I can't seem to find a straight ODBC driver. Seems to be all product specific. We need this to be able to go to MX, so no dns-less connections or whatever. I am sorry if this is something I should know how to do. I don't often work with windows based servers, and almost never with Access when I do. TIA Tim __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting to an Access DB on a remote machine
Thanks for the clarification. I can see clearly now that the rain is gone. Josh -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 3:28 PM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine NetBEUI is non-routable. NetBIOS is essentially NetBEUI at an API level that is routed over another protocol (TCP/IP, IPX, etc). Kevin [EMAIL PROTECTED] 06/18/02 12:26PM I may be wrong and have been befoer but I was always told that netbios is a non-routable protocal -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 3:19 PM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine In order for this to work NetBIOS must be allowed over the network. If you are going over the internet, having NetBIOS ports exposed to the world is a very bad idea. If the endpoint is fixed, you could open up NetBIOS for that single address, however. IMHO, a better option is to pull the DB local and build a web-based data entry tool for the client to use over the network. If the network goes down between the server and the client, only the data entry dies and not the entire application. Data integrity is also greatly enhanced (well, for Access). Regards, Kevin [EMAIL PROTECTED] 06/18/02 12:08PM In theory, you would setup a mapped network drive to the remote machine by using either the DNS name or IP address of the remote machine followed by the name of the shared drive. But if you don't have a T-1 on both ends, the connection speed may be too slow to maintain or even connect. So, for example, if the DNS name of the remote machine was www.fusioneers.com, and the shared drive was public, then you'd setup a network drive with the following path: \\www.fusioneers.com\public From there, you would select it as though the .MDB file was on your local machine since you would have a mapped drive on your local machine. But in practice, I've never seen it work. I tried it with a DSL connection on my end (restricted to 128k upstream) with multiple T-1's on the other end and still couldn't get at it. But you may be able to if you've got a super fast connection. OK so maybe I'm better at networking than CF these days. ;) ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:25 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine How would I do that? I have gone into data sources and looked for where I can set it up by giving it an ip address or whatever, and I can't seem to find it. By remote I don't mean even on the same network, maybe not even in the same country. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:13 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine You can create a DSN on the CF machine that points the access file on the remote machine. Shawn Regan -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 10:02 PM To: CF-Talk Subject: Getting to an Access DB on a remote machine Hey, I was wondering if anyone knew how to get CF to talk to an access DB on a remote machine? Here's my thing. Client buys products from vender. Vender has product list in an access db. Client wants to be able to automatically update it's available product line without waiting for updates. Now I am thinking there should be an easy way to register the Access db as an odbc data source, then on clients machine use that. But I can't seem to find a straight ODBC driver. Seems to be all product specific. We need this to be able to go to MX, so no dns-less connections or whatever. I am sorry if this is something I should know how to do. I don't often work with windows based servers, and almost never with Access when I do. TIA Tim __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Accessing Microsoft Access and SQL db's on CD
I do not know if someone already said this or not but when you open an access db it creates an ldb file that might be kinda hard on a cd. Josh -Original Message- From: Digital Internet Limited [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 02, 2000 8:32 AM To: CF-Talk Subject: Re: Accessing Microsoft Access and SQL db's on CD Personally I use a laptop for client demonstrations SB - Original Message - From: Jason Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 7:35 PM Subject: Re: Accessing Microsoft Access and SQL db's on CD Hello everyone, I need to copy a few of my coldfusion sites onto CD for clients. Most of them running MS access or sql databases. I will be using a combination of director and flash to do the user interface - but do not wisht o convert data and modify all the queries to work with some of the Director database solutions out there. Has anyone any links or products that allow the creation of a database to reside on a CD as a mini ODBC type driver where all the queries can be executed from the db on the cd? I would love to be able to make the queries go to the net for latest information - but too many people will have slow or unreliable questions.. So I need to as effortlessly as possible recreate a whole coldfusion/ database scenario on a CD. Any help or direction is appreciated. Thanks, Jason __ 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: Pez convention moves after teen is cited
Costas, I do not want to be critical but you sure do like to lash out at others. Yes this list is for CF Development help, but even thing like this to break up the monotony of a day is a good thing. I am in no way lashing out at you it is just something that I notice. You lashed at me about the outlook question and I have seen you lash out at others. This is a list to help not slam let's try to keep it that way. Joshua Tipton -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 4:02 PM To: CF-Talk Subject: RE: Pez convention moves after teen is cited What exactly does this have to do with Cold Fusion Development? -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:03 PM To: CF-Talk Subject: Pez convention moves after teen is cited By Heather Ratcliffe Of The Post-Dispatch * A Frontenac officer issued a summons to the youth for not having a merchant's license. That led the convention's organizer to move the candy dispenser collectors' convention to Town and Country. Pez candy dispenser collectors moved their annual convention this weekend from Frontenac to Town and Country after an undercover police officer busted a teen who sold a $3 item without a merchant's license. A Frontenac police detective wandered into a room at the Frontenac Hilton on Thursday and bought a Star Wars Pez candy dispenser from 18-year-old Seth Weinberg of Columbia, Mo. About an hour later, the officer returned to issue Weinberg a court summons. Dozens of other dealers were not cited. I didn't invite this guy into my room to buy Pez. He just came in, Weinberg said. City officials said anyone selling merchandise in Frontenac must apply for a itinerant merchant license 30 days before the sale. The process gives police an opportunity to check the background of a vendor before the public buys wares. It doesn't matter what they are selling - diamond rings or Pez dispensers, said City Attorney Chet Pleban. We want to make sure everyone follows the law, and we know who comes into our town. John Devlin, who founded the convention 10 years ago, said he never needed a license when he hosted the event in the St. Louis area in the past. Devlin, of south St. Louis County, said the hotel event coordinator never mentioned it. He said he heard about the ordinance about three weeks before the convention. By then, he said, he didn't have time to apply. Instead, Devlin decided to move the event to the St. Louis Marriott West hotel in Town and Country after the incident Thursday. Town and Country does not put the same restrictions on vendors. The Pez show, open to the public from 10:30 to 2 p.m. today, will be squeezed into the Marriott West ballroom, which is one-third the size of the planned space. More than 200 people from across the country registered for the event. Organizers expected several hundred more to stop in. Weinberg must return to Frontenac July 17 to appear in court on his violation. I know the police are doing their job, he said. But I'm sure there has got to be something better they can be doing than busting people selling Pez. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT SQL SERVER Backup
To backup all databases use a database maintenance plan to backup them up to the local server then have it run a script on completion to copy the files to the other server then when that job is finished have it run the restore of the databases. Joshua Tipton -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 15, 2002 7:01 PM To: CF-Talk Subject: RE: OT SQL SERVER Backup Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? ... I have SQL server 2K and thiry + databases ... I know how to backup each one, but was wondering if there is a bulk backup of the entire server. There are a couple of options that might work for you. If this is a one-time thing, and you can stop the source database server, you can simply copy the database and log files to the new server, and use sp_attach_db to attach each to the new server. Alternatively, you can use T-SQL to automate the backup and restore process; on the source database server, run the BACKUP DATABASE command through any database. OSQL is a handy command-line client for doing this sort of stuff. Since you want to backup the entire server, you'll probably want to write a T-SQL batch to query the master database to find out about each database, then loop over that information. I'll bet you can find a useful script for that here: http://www.swynk.com/sqlscripts/backuprest7.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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_Forms_in_HTML_E-Mail No Answers yet
That form has to work on the server. I think what you need to do is have a basic form with the questions on it with a form tag as follows: cfform action=http://yoursite/directorystructure/sendmail.cfm; method=POST enablecab=no That way when submit is hit outlook will call on the cf server process the form and send out the results. I do this all the time on little surveys and have never had a problem. Your problem is that outlook has no Idea what cfmail is and does not process it. If you have any questions contact me off list. Joshua Tipton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 6:03 PM To: CF-Talk Subject: CF_Forms_in_HTML_E-Mail No Answers yet Hello, No one seems to be able to answer this one ... Sending an HTML e-mail using cfmail ... In the HTML E-mail is a basic form ... When I hit submit from within Outlook, the form won't process. Why? CODE: CFMAIL to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=HTML FORM E- MAIL type=HTML form action=http://www.domainname.com/proccess.cfm; method=post table align=left border=0 width=50% cellpadding=4 cellspacing=0 tr td align=left Question 1: How is the evaluation of our product going?/td tr /tr td align=center select name=q1 size=1 option value=1 SELECTEDSelect an Answer/option option value=2Ready to Place an Order/option option value=3Need More Time/option option value=4Need Some Help/option option value=5No Purchases Planned/option option value=6Never Received Sample/option /select /td tr/tr td align=left Question 2: Are there any issues or conerns you need help with?/td tr /tr td align=center select name=q1 size=1 option value=1 SELECTEDSelect an Answer/option option value=2No Problems/option option value=3Need a Application Enginner/option option value=4Products Aren't Working/option option value=5Took to Long to Get Sample/option option value=6Something Else/option /select /td tr/tr td align=left Question 3: Why is Steve so successful?/td tr/tr td align=center select name=q1 size=1 option value=1 SELECTEDSelect an Answer/option option value=2Good Looks/option option value=3Brains/option option value=4Charm and Wit/option option value=5Product Knowledge/option option value=6All of the Above/option /select /td tr/tr td align=center input type=submit name=submit value=Submit Information /td /tr /table /form /CFMAIL D- __ 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
OT Javascript Help
script for window event=onresize reload(); /script This is a shot in the dark on my part. I would like for the page to reload if the user resizes the screen in any way. Please help. Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT Javascript Help
Having to use unfortunate frames for one small part and it messes everything up when you resize the screen. Thanks for your help it worked. Joshua Tipton -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 11:04 PM To: CF-Talk Subject: Re: OT Javascript Help Not sure about other browsers, but in IE you can use body onresize=location.reload(); or if you're already past the body tag I believe it's window.onresize = location.reload; note that there are no () parenthesis in the 2nd case ... Out of curiosity ... Why are you wanting to reload the document when the window resizes? Do you have objects on the page that are positioned absolutely using CSS? In any event ... a widely supported (os/browsers) solution may be tough to come by ... Isaac www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backups II, the Sequel
You can get the SQL agent if you want to do an ONLINE backup but you do not have to. The online backup is prefomred 3 times a day just in case we have a failure in the middle of the day we will atleast have data up to a certain point. Your deciding factor is what amount of data are you willing to lose. Most people say none and that is the ideal world but there is always about a 5-8 hour lapse that we are willing to lose. I built this backup strategy and we follow it to a T with only one disaster in our pocket. We were actually lucky because I was able to ghost the data stripe set and we lost no data. Had a controller failure that would not take a reinstall and the only way to get anything to work was a compaq erase.shiver up spine But if it ever happened to where we could not get the data off we would have lost only about 5 hours worth of data. Josh -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:28 PM To: CF-Talk Subject: RE: Backups II, the Sequel I guess this begs the question: Clearly Veritas Pro can handle backing up my local server, mdbs and all. And I can get my SQL 2000 box to put a backup in an accessible directory, too. Do I then get the SQL agent, on top of that? Sorry to put these questions here but this is all a little new to me... -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 1:22 PM To: CF-Talk Subject: RE: Backups II, the Sequel On a daily basis we have what we call an online back where we allow sql to backup to the local drive then we backup those files. We then on sunday stop the sql service and backup the entire server. On critical servers we do the same with the exception of an online backup in which we use the veritas sql agent which will go into a db and back it up. Josh -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:01 PM To: CF-Talk Subject: OT: Backups II, the Sequel OK, now that I've figured out we need better backup software - what's a good program to: 1. Backup the local server 2. AND backup SQL data on another server Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access to SQL discrepancy in transfer of data
cfquery name=GetKeyUser datasource=lsar_dev select fullname, role fromdbo.tbl_users where role = (select 'key_' + '' + role as keyrole from dbo.tbl_users where username = '#session.username#') -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:37 PM To: CF-Talk Subject: Access to SQL discrepancy in transfer of data What a surprise, NOT!! I have a QUERY in a QUERY that works fine in MS-Access 97, but bombs in SQL SERVER 2000. Here is the query: cfquery name=GetKeyUser datasource=lsar_dev select fullname, role fromdbo.tbl_users where role = (select 'key_' role as keyrole from dbo.tbl_users where username = '#session.username#') /cfquery The error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. SQL CHANGED MY DATA TYPES FROM TEXT IN ACCESS TO NVARCHAR IN SQL. WHAT DATATYPE SHOULD THE FIELD ROLE BE? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access to SQL discrepancy in transfer of data (SOLVED)
Just got back from lunch. I receive a lot of help from this list and I am just glad that I could return one. Josh -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 2:07 PM To: CF-Talk Subject: RE: Access to SQL discrepancy in transfer of data (SOLVED) Thanks Joshua, that worked like a charm. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:45 PM To: CF-Talk Subject: RE: Access to SQL discrepancy in transfer of data cfquery name=GetKeyUser datasource=lsar_dev select fullname, role fromdbo.tbl_users where role = (select 'key_' + '' + role as keyrole from dbo.tbl_users where username = '#session.username#') -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:37 PM To: CF-Talk Subject: Access to SQL discrepancy in transfer of data What a surprise, NOT!! I have a QUERY in a QUERY that works fine in MS-Access 97, but bombs in SQL SERVER 2000. Here is the query: cfquery name=GetKeyUser datasource=lsar_dev select fullname, role fromdbo.tbl_users where role = (select 'key_' role as keyrole from dbo.tbl_users where username = '#session.username#') /cfquery The error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. SQL CHANGED MY DATA TYPES FROM TEXT IN ACCESS TO NVARCHAR IN SQL. WHAT DATATYPE SHOULD THE FIELD ROLE BE? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS Havoc!!
How long ago did you change this sometimes it will take up to 24 hours to propogate around the world. Josh -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 3:30 PM To: CF-Talk Subject: RE: DNS Havoc!! I'm getting the nw IP from both 207.x.x.x and 68.x.x.x -mk -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:47 PM To: CF-Talk Subject: SOT: DNS Havoc!! Hey guys i just switched to a new host for the website www.entelligence.com But for some reason it still pings to the old host IP address Can you guys Ping the site and tell me (directly to my email) what address you get? The new host IP is 66.28.113.146 The old host IP is 209.113.73.92 The wierd thing is the other coputers in my office are pointing to the new site! I have set up my DNS information correctly too, but it's still pointing to the old site. ahhh!!! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: registry error
If its 2000 I would boot into safe mode so hopefully if something has a hold on that key it will let go. Josh -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 3:45 PM To: CF-Talk Subject: Re: registry error it's not in the odbc datasources control panel. Steven D. Dworman Certified Macromedia Developer Web Consultant Systems Administrator phone: 248.647.8841 cell : 248.767.9925 Comspec International Empower-XL Software for Higher Education http://www.ComspecInternational.com - Original Message - From: Phoeun Pha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 2:18 PM Subject: RE: registry error try deleting it from the ODBC datasources control panel instead of using the Coldfusion admin that is, if you're using windows :) -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:51 PM To: CF-Talk Subject: registry error I've never had this happen. Here goes... I went in to administrator to delete an ODBC source. Sounds simple I know, but I got this error: Unable to delete the registry entry in branch HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\***datasource here*** A problem was encountered trying to access the system registry. Error number 5 occurred - Access denied to registry key (probably due to security constraints). Obviously I checked permissions, and of course I have a user with administrator permissions logged in. I am able to delete other sources, and can create new ones. Also I tried to delete the key itself and got an error saying unable to delete. Any help is appreciated. Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WOT: Dual Display
I think that the cards have to be the same. Josh -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:18 PM To: CF-Talk Subject: Re: WOT: Dual Display I have my dual monitors running of my single card.. but when a monitor went down I was having trouble with my Hydra manager setting up - and I could not get a secondary or even a clone. I am sure yours will not be this easy.. but I rebooted.. and suddenly the monitor came alive. maybe yours will be as easy? jay miller James Smith wrote: I have a Dell computer with two ATI cards in (32mb AGP and 2Mb PCI) but not for love nor money can I get Windows 2000 to enable multiple monitors, both cards are in the Microsoft HCL and both have the correct drivers installed. Both work as the primary but neither will work as a secondary. Hope someone has had a similar problem and solved it. -- Jay __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
iif driving me nuts
Please help me with this or can you guys and gals tell me a better way to code this. Of course the phrases will be changed but this will give you the basic concept. Josh #iif((qryquicklinks.recordcount gte 8), DE(onClick='alert(Sorry, you suck)';), DE(onClick='alert(You Deleted Me)';))# __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB Table Naming Conventions
proc_ -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:32 AM To: CF-Talk Subject: RE: DB Table Naming Conventions Really? Wow ... I didn't know that. How do you prefix or designate Stored Proceedures? Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:23 AM To: CF-Talk Subject: RE: DB Table Naming Conventions MS says that only system stored procedures should start with sp becasue when sql recieves a stored proc with sp_ it looks in the master system stored procedures first then looks in the current database. I doubt the speed difference is that much but just a tidbit of my two cents. Josh !--- Cut out of Books Online --- Many of your administrative activities in MicrosoftR SQL ServerT are performed through a special kind of procedure known as a system stored procedure. System stored procedures are created and stored in the master database and have the sp_ prefix. System stored procedures can be executed from any database without having to qualify the stored procedure name fully using the database name master. It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for stored procedures beginning with sp_ in this order: Look for the stored procedure in the master database first. Look for the stored procedure based on any qualifiers provided (database name or owner). Look for the stored procedure using dbo as the owner, if one is not specified. Therefore, although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:10 AM To: CF-Talk Subject: RE: DB Table Naming Conventions We usually do something like so: Stored Proc:sp_whatever Views: vw_whatever Tablename: tblUsers, tblPermissions, etc. Fields: Always prefixed with table-related text as such: userID (PK/ID) ufirstname ulastname uaddress1 uaddress2 ucity ustate uzip etc. That just makes it easier for me to see what field is related to what table - especially when you have similar data in multiple fields (which we try to avoid by abstracting the database as much as possible - but sometimes is necessary). There may be a better way or a more suitable way for your programming style. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:20 AM To: CF-Talk Subject: Re: DB Table Naming Conventions -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm just curious, What naming conventions for DB tables do you use? this is a biggy :-) a lot of php developers that work with mysql, a non relational db use pk names of ID I always name the pk of table (table_name)_id... I also tend to prefix ~ column names with an abbreviation of the table name, it makes life easier as there is more information there and when you start joining tables, there is less conflict if u use common naming conventions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0HWKMACgkQm98oI6K7h0gxUQCgjUvOt0+YVHgz/Qyh8RlAawAp CrwAoOwShhA1t7xZpiKsaYQ3Cdz8Supo =YXc3 -END PGP SIGNATURE- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: iif driving me nuts
I fill like a nimrod I am going home I am tired. Josh -Original Message- From: Patric Stumpe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:42 AM To: CF-Talk Subject: Re: iif driving me nuts Hi Joshua, you could also use a simple (perhaps faster cfif-statement like this: onClick='alert(cfif qryquicklinks GTE 8Sorry, you suckcfelseYou Deleted Me/cfif)'; Does this help? Patric JT Please help me with this or can you guys and gals tell me a better way to JT code this. Of course the phrases will be changed but this will give you the JT basic concept. JT Josh JT #iif((qryquicklinks.recordcount gte 8), DE(onClick='alert(Sorry, you JT suck)';), DE(onClick='alert(You Deleted Me)';))# JT __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client variable storage
Either that or you can set the user ID that that datasource uses to a different default database instead of master. In ODBC if you leave default database blank than it will default to the default database that the user id has rights to. Josh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:55 AM To: CF-Talk Subject: RE: Client variable storage Have you set the default database of the datasource to the right value? -Original Message- From: JS [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 16:30 To: CF-Talk Subject: Client variable storage I set up a new SQL7 database. Registered it as an ODBC datasource in the CF Administrator. Added as a client variable store. Selected the new datasource as the default datastore. No matter what I do my applications are using the 'master' database as client storage. Even if I use the clientstorage parameter in the cfapplication tag to specify the new datasource. If I specify a datasource that does not exist as a client storage the template errors stating that the datasource is not set to store client variables. What is causing this? JS __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backups II, the Sequel
On a daily basis we have what we call an online back where we allow sql to backup to the local drive then we backup those files. We then on sunday stop the sql service and backup the entire server. On critical servers we do the same with the exception of an online backup in which we use the veritas sql agent which will go into a db and back it up. Josh -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:01 PM To: CF-Talk Subject: OT: Backups II, the Sequel OK, now that I've figured out we need better backup software - what's a good program to: 1. Backup the local server 2. AND backup SQL data on another server Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web directory reporting tool
or tree -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:15 PM To: CF-Talk Subject: Re: web directory reporting tool Not sure of exactly what you need, but you can get a text file listing using windows built in tools. Open a dos command prompt (start-run-cmd) Use the following command: dir path /b /s filename.txt where *path* is the starting point that you want for the files (for example, c:\temp) and *filename.txt* is the txt filename that you want the data stored in This will give you a file list of all of the files in the specified directory and all subdirectories (full path info - c:\temp\folder\filename.ext) . You can then import this file into excel and parse it. Erica Carl cfcvano@hotmTo: CF-Talk [EMAIL PROTECTED] ail.com cc: Subject: web directory reporting tool 06/12/2002 02:20 PM Please respond to cf-talk Anyone know of any tools that can list (csv, or graphically) directories/files, and all sub-directories/files from the web root in IIS? Thanks! Carl __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB Table Naming Conventions
MS says that only system stored procedures should start with sp becasue when sql recieves a stored proc with sp_ it looks in the master system stored procedures first then looks in the current database. I doubt the speed difference is that much but just a tidbit of my two cents. Josh !--- Cut out of Books Online --- Many of your administrative activities in Microsoft® SQL Server™ are performed through a special kind of procedure known as a system stored procedure. System stored procedures are created and stored in the master database and have the sp_ prefix. System stored procedures can be executed from any database without having to qualify the stored procedure name fully using the database name master. It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for stored procedures beginning with sp_ in this order: Look for the stored procedure in the master database first. Look for the stored procedure based on any qualifiers provided (database name or owner). Look for the stored procedure using dbo as the owner, if one is not specified. Therefore, although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:10 AM To: CF-Talk Subject: RE: DB Table Naming Conventions We usually do something like so: Stored Proc:sp_whatever Views: vw_whatever Tablename: tblUsers, tblPermissions, etc. Fields: Always prefixed with table-related text as such: userID (PK/ID) ufirstname ulastname uaddress1 uaddress2 ucity ustate uzip etc. That just makes it easier for me to see what field is related to what table - especially when you have similar data in multiple fields (which we try to avoid by abstracting the database as much as possible - but sometimes is necessary). There may be a better way or a more suitable way for your programming style. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:20 AM To: CF-Talk Subject: Re: DB Table Naming Conventions -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm just curious, What naming conventions for DB tables do you use? this is a biggy :-) a lot of php developers that work with mysql, a non relational db use pk names of ID I always name the pk of table (table_name)_id... I also tend to prefix ~ column names with an abbreviation of the table name, it makes life easier as there is more information there and when you start joining tables, there is less conflict if u use common naming conventions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0HWKMACgkQm98oI6K7h0gxUQCgjUvOt0+YVHgz/Qyh8RlAawAp CrwAoOwShhA1t7xZpiKsaYQ3Cdz8Supo =YXc3 -END PGP SIGNATURE- __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outlook Calendar
Actually I found a tag look for cf_outlook in MM Exchange pulls the data CLIENT side from OUTLOOK on the CLIENT machine. Josh -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 11:17 AM To: CF-Talk Subject: RE: Outlook Calendar True, but if he just wants to pull information from Outlook, is it even in an exchange box? You're right, LDAP is a great solution, assuming the calendars are stored on an Exchange server. If they are just client only calendars, which I doubt, then his question is worder wrong. He should have asked: I would like a custom tag or some code to import some ones mail server here calendar from his or her mailbox on a(n) Mail Server Here Server... Cfcomet also has a great reference section on integrating with Exchange too... -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 7:41 PM To: CF-Talk Subject: RE: Outlook Calendar lol. indeed, cfcomet is a great resource in working with various third party products. the key to this is ldap. gl, alexander -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 8:45 PM To: CF-Talk Subject: RE: Outlook Calendar I would like a bucket of chicken with potato salad served to me on a silver platter by a topless waitress. We all don't get exactly what we want ;-) Go to www.cfcomet.com. They show a few examples on dealing with Outlook. You may have to combine the sample code on the web site with the msdn reference library and you shouldn't have too much difficulty. Alas, you can't though download someones calendar from their computer without an activeX control though. You need an exchange server with their calendar information stored there, or conversely the client has to upload their calendar somehow, like through an ActiveX control or a Java Applet. Imagine the damage one could do if a web server could access a client's outlook mailbox. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 4:36 PM To: CF-Talk Subject: Outlook Calendar I would like a custom tag or some code to import some ones outlook calendar from his or her machine and show it on the screen for any particular day. Josh __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outlook Calendar
http://devex.macromedia.com/developer/gallery/info.cfm?ID=8DAD7A4D-5B05-11D5 -83F600508B94F380 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 2:59 PM To: CF-Talk Subject: RE: Outlook Calendar Could you send me the tag? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 10:39 AM To: CF-Talk Subject: RE: Outlook Calendar Actually I found a tag look for cf_outlook in MM Exchange pulls the data CLIENT side from OUTLOOK on the CLIENT machine. Josh -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 11:17 AM To: CF-Talk Subject: RE: Outlook Calendar True, but if he just wants to pull information from Outlook, is it even in an exchange box? You're right, LDAP is a great solution, assuming the calendars are stored on an Exchange server. If they are just client only calendars, which I doubt, then his question is worder wrong. He should have asked: I would like a custom tag or some code to import some ones mail server here calendar from his or her mailbox on a(n) Mail Server Here Server... Cfcomet also has a great reference section on integrating with Exchange too... -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 7:41 PM To: CF-Talk Subject: RE: Outlook Calendar lol. indeed, cfcomet is a great resource in working with various third party products. the key to this is ldap. gl, alexander -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 8:45 PM To: CF-Talk Subject: RE: Outlook Calendar I would like a bucket of chicken with potato salad served to me on a silver platter by a topless waitress. We all don't get exactly what we want ;-) Go to www.cfcomet.com. They show a few examples on dealing with Outlook. You may have to combine the sample code on the web site with the msdn reference library and you shouldn't have too much difficulty. Alas, you can't though download someones calendar from their computer without an activeX control though. You need an exchange server with their calendar information stored there, or conversely the client has to upload their calendar somehow, like through an ActiveX control or a Java Applet. Imagine the damage one could do if a web server could access a client's outlook mailbox. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 4:36 PM To: CF-Talk Subject: Outlook Calendar I would like a custom tag or some code to import some ones outlook calendar from his or her machine and show it on the screen for any particular day. Josh __ 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
Outlook Calendar
I would like a custom tag or some code to import some ones outlook calendar from his or her machine and show it on the screen for any particular day. Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WAY WAY OT ASP QUESTION
Using the FSO I would like to get the last modified date of a file. Can anyone help me? Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB Compatibility Sybase SQL Anywhere
Use cfcontent if you can output it to excel then import into access. -Original Message- From: Allen Hudson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:16 PM To: CF-Talk Subject: DB Compatibility Sybase SQL Anywhere A colleague has a situation that I am sure has crossed the brow of someone else before. She has a Coldfusion development Web Application tied to a Sybase SQL Anywhere database (reason being that is what our government webhosting department supports). This is the first time that she or I have worked with this type of database. This database comes with a utility (I am told) that will convert most other db formats to Sybase format to be able to be used. She cannot find anything as yet that would allow the data in the Sybase db to be exported or transported to an alternative format like Access 2000. Just so you know, the majority of clients that we deal with, use Access since their data requirements are not extensive. The question: how would one go about getting the data in the Sybase db into an alternative format (specifically Access 2000) or any other for that matter? I am also posing this question in the general sense as well to be prepared for future web app requirements. Thank you for your help Al Hudson __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: recommendations for AV software (Win2K Advanced Server)
I run sql 7x on my xp pro machine. Josh -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 5:20 AM To: CF-Talk Subject: SOT: recommendations for AV software (Win2K Advanced Server) Short of a re-install, my Norton AV software has ceased to function. Any recommendations for a replacement? I'm running both Win2K Advanced Server and WinXP Professional (the latter looking good but sucking when it comes to serving websites - even developing them. Did you know that SQL Server 7.x does NOT run on XP Pro?). Thanks in advance! PT == Peter Tilbrook Macromedia ColdFusion Applications Developer 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Phone: (02) 6284 2727 Mobile: 0401 973 415 Email: [EMAIL PROTECTED] __ 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: datetime formatting
dim mydate, mytime, timedate, final set mydate = date set mytime = time set timedate = mydate mytime set final = formatdatetime(timedate, 0) Not sure if this will work pulled it out of my head and pulled the other from a vbscript help file. Josh FormatDateTime Function Returns an expression formatted as a date or time. FormatDateTime(Date[, NamedFormat]) Arguments Date Required. Date expression to be formatted. NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used. Settings The NamedFormat argument has the following settings: Constant Value Description vbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed. vbLongDate 1 Display a date using the long date format specified in your computer's regional settings. vbShortDate 2 Display a date using the short date format specified in your computer's regional settings. vbLongTime 3 Display a time using the time format specified in your computer's regional settings. vbShortTime 4 Display a time using the 24-hour format (hh:mm). Remarks The following example uses the FormatDateTime function to format the expression as a long date and assign it to MyDateTime: Function GetCurrentDate ' FormatDateTime formats Date in long date. GetCurrentDate = FormatDateTime(Date, 1) End Function -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sum Help
select sum(column) as sumofcolumn from table -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:48 PM To: CF-Talk Subject: Sum Help Ok.. I;ve got myself confused here... I have a table that has some numbers lets say 5 records (50, 45, 33, 23, 12) now I want to be able to select * from that table (not a problem). But I need to sum those numbers so that I can output sum(50+45+33+23+12)... How can I do this??? Is there an easy way am I forgetting something??? KP __ 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: scrolling tables
Set a z-index in the style property on the table, tr, or td and then that part will scroll. Joshua Tipton -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:59 PM To: CF-Talk Subject: RE: scrolling tables I've seen this done with iframe but I'm not sure if its the best solution. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 May 2002 12:23 PM To: CF-Talk Subject: OT: scrolling tables oi CF-Talk,!! somewherepossibly on the msdn site I've seen an example where table headers are stationary, but the cells are scrollable. anybody else seen this.or know where some Xamples are? thanks -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: scrolling tables
Sorry man I told you the wrong thing. It is this style=OVERFLOW-Y: auto; -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 9:47 AM To: CF-Talk Subject: Re: scrolling tables like this style=z-index : auto; or have I got completely the wrong idea? Simon - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:05 PM Subject: RE: scrolling tables Set a z-index in the style property on the table, tr, or td and then that part will scroll. Joshua Tipton -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:59 PM To: CF-Talk Subject: RE: scrolling tables I've seen this done with iframe but I'm not sure if its the best solution. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 May 2002 12:23 PM To: CF-Talk Subject: OT: scrolling tables oi CF-Talk,!! somewherepossibly on the msdn site I've seen an example where table headers are stationary, but the cells are scrollable. anybody else seen this.or know where some Xamples are? thanks -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: scrolling tables
This should work. Joshua Tipton Table tr tdHeaders for table/td /tr tr td style=OVERFLOW-Y: auto; table tr tdYourStuff/td /tr /table /td /tr /table -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:04 AM To: CF-Talk Subject: Re: OT: scrolling tables oi Critz!! ok..using the example with the overflow...any idea how to line up the table?? the scrollbar throws off the alignment -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 10:53:07 PM, you wrote: C oi CF-Talk,!! C somewherepossibly on the msdn site I've seen an example where table C headers are stationary, but the cells are scrollable. C anybody else seen this.or know where some Xamples are? C thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: scrolling tables
Yeah I am working on 3 projects at once and meant like this but I was working on a z index problem. Table tr tdHeaders for table /tr tr td style=OVERFLOW-Y: auto; table tr tdYourStuff/td /tr /table /td /tr /table Joshua Tipton -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:15 AM To: CF-Talk Subject: RE: scrolling tables I just tried out the z-index suggestion. Put it in the table, tr, and td tag (one at a time) - no scolling occured. but, I have to wonder what a z-index would have to do with scrolling. Scrolling is a horizontal movement, whereas z-index is a depth value... so I'm a bit confused if there IS a relationship here. Shawn Grover -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 7:47 AM To: CF-Talk Subject: Re: scrolling tables like this style=z-index : auto; or have I got completely the wrong idea? Simon - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:05 PM Subject: RE: scrolling tables Set a z-index in the style property on the table, tr, or td and then that part will scroll. Joshua Tipton -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:59 PM To: CF-Talk Subject: RE: scrolling tables I've seen this done with iframe but I'm not sure if its the best solution. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 May 2002 12:23 PM To: CF-Talk Subject: OT: scrolling tables oi CF-Talk,!! somewherepossibly on the msdn site I've seen an example where table headers are stationary, but the cells are scrollable. anybody else seen this.or know where some Xamples are? thanks -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion __ 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: scrolling tables
Sorry man you need to put a div in like below. I had to go back and look at some previous code. Joshua Tipton Table tr tdHeaders for table/td /tr tr td DIV style=OVERFLOW-Y: auto; WIDTH: 100%; HEIGHT: 100% table tr tdYourStuff/td /tr /table /div /td /tr /table -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:18 AM To: CF-Talk Subject: RE: scrolling tables Sorry Joshua, my previous posts were before I saw this message. but the overflow-y option isn't working either. Is there some condition that needs to be met before scolling will be kicked in (maybe the height/width of the cell in question)? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 9:03 AM To: CF-Talk Subject: RE: scrolling tables Sorry man I told you the wrong thing. It is this style=OVERFLOW-Y: auto; -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 9:47 AM To: CF-Talk Subject: Re: scrolling tables like this style=z-index : auto; or have I got completely the wrong idea? Simon - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:05 PM Subject: RE: scrolling tables Set a z-index in the style property on the table, tr, or td and then that part will scroll. Joshua Tipton -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:59 PM To: CF-Talk Subject: RE: scrolling tables I've seen this done with iframe but I'm not sure if its the best solution. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 May 2002 12:23 PM To: CF-Talk Subject: OT: scrolling tables oi CF-Talk,!! somewherepossibly on the msdn site I've seen an example where table headers are stationary, but the cells are scrollable. anybody else seen this.or know where some Xamples are? thanks -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick question on custom tags
Put it in your custom tags directory on your server or use cfmodule. -Original Message- From: Brian Eckerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:05 AM To: CF-Talk Subject: Quick question on custom tags Is it possible to call a custom tag that resides in a folder other than the current folder. I am using cf_cf_formurl2attributes but I would like to have one copy residing in a commonfiles folder at root. This would take something like ../cf_cf_formurl2attributes right? It doesn't seem to work. Any help is appreciated. __ 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: dynamic image
Put the image in the background of a table. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 12:38 PM To: CF-Talk Subject: dynamic image I want to create an image and make the text on the image dynamic, but I am not sure where to start.. Anybody have a suggestion? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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
OPTION QUERY HINT OT SQL PROBLEM
Does anyone know the correct synatx to the option query hint keep plan BOL God bless it is sometimes sparce in its explanations. TIA, Josh SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into ##DA69EE60673311D6B9B3000AD1311671 FROM vw_CTMCORPAPPFULLVIEWprod option query_hint, keep plan where (requestor like 'OVD%') and year = 2001 GROUP BY reg_NO, y_id, M_id __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
1 as column name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:29 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? just in the returned query -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: Re: OT (SQL): Add column to query? Do you want it in the table, or just in the returned query? Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:12AM I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Temporary Tables
Eventually as in the current connection or eventually as in sometime this week? Temp table straight out of books online You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions. Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name). SQL statements reference the temporary table using the value specified for table_name in the CREATE TABLE statement: CREATE TABLE #MyTempTable (cola INT PRIMARY KEY) INSERT INTO #MyTempTable VALUES (1) If a local temporary table is created in a stored procedure or application that can be executed at the same time by several users, SQL Server has to be able to distinguish the tables created by the different users. SQL Server does this by internally appending a numeric suffix to each local temporary table name. The full name of a temporary table as stored in the sysobjects table in tempdb consists of table name specified in the CREATE TABLE statement and the system-generated numeric suffix. To allow for the suffix, table_name specified for a local temporary name cannot exceed 116 characters. Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped using DROP TABLE: A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table cannot be referenced by the process which called the stored procedure that created the table. All other local temporary tables are dropped automatically at the end of the current session. Global temporary tables are automatically dropped when the session that created the table ends and all other tasks have stopped referencing them. The association between a task and a table is maintained only for the life of a single Transact-SQL statement. This means that a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended. A local temporary table created within a stored procedure or trigger is distinct from a temporary table with the same name created before the stored procedure or trigger is called. If a query references a temporary table, and two temporary tables with the same name exist at that time, it is not defined which table the query is resolved against. Nested stored procedures can also create temporary tables with the same name as a temporary table created by the stored procedure that called it. All references to the table name in the nested stored procedure are resolved to the table created in the nested procedure, for example: CREATE PROCEDURE Test2 AS CREATE TABLE #t(x INT PRIMARY KEY) INSERT INTO #t VALUES (2) SELECT Test2Col = x FROM #t GO CREATE PROCEDURE Test1 AS CREATE TABLE #t(x INT PRIMARY KEY) INSERT INTO #t VALUES (1) SELECT Test1Col = x FROM #t EXEC Test2 GO CREATE TABLE #t(x INT PRIMARY KEY) INSERT INTO #t VALUES (99) GO EXEC Test1 GO Here is the result set: (1 row(s) affected) Test1Col --- 1 (1 row(s) affected) Test2Col --- 2 When you create local or global temporary tables, the CREATE TABLE syntax supports constraint definitions with the exception of FOREIGN KEY constraints. If a FOREIGN KEY constraint is specified in a temporary table, the statement returns a warning message indicating that the constraint was skipped, and the table is still created without the FOREIGN KEY constraints. Temporary tables cannot be referenced in FOREIGN KEY constraints. Consider using table variables instead of temporary tables. Temporary tables are useful in cases when indexes need to be created explicitly on them, or when the table values need to be visible across multiple stored procedures or functions. In general, table variables contribute to more efficient query processing. For more information, see table. Josh -Original Message- From: jgeorges [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 18, 2002 7:13 PM To: CF-Talk Subject: Temporary Tables I am building records from several datasources. I would like to save the data in a temporary table which I will eventually query and pass the query results to CFX_Excel to create an xls file. I am using Cold Fusion 5. My datasources are SQL Server databases. What are my options for saving the data that I can eventually query using CFQUERY? TIA, Sam Visit iWon.com - the Internet's largest guaranteed cash giveaway! __ 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
WAY OT DTS PACKAGE
Does anyone know via DTS how to open a zip file so that I can attach to a dbf file that is in the zip file? Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A Tip (maybe new, maybe not)
Might be dangerous Question Is there any way to disconnect from a database programmatically? Answer This is possible, but not recommended, especially if it is a multi-user database. To do so, however, clear the cached connection information with the following code: cfset temp = cfusion_dbconnections_flush() This code flushes all connection information from the cache, but it does not disconnect any actively running requests. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:25 PM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. If you send a bogus query (one with an error), CF or Access will 'unlock' the file for you... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dropdown Box
look up IIF -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:00 AM To: CF-Talk Subject: Dropdown Box Hello All, When recalling a stored value that was submitted by a dropdown box, is there a way to have the dropdown box show the chosen value when returning to that form? Any suggestions? Thanks, Ben __ 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: [admin] List status
Does mysql have full text searching capabilities like MS SQL if not then they would be almost pointless to use MY SQL to search through the list archives. Josh -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:50 AM To: CF-Talk Subject: RE: [admin] List status Michael are we talking getting an actually box at your place (or where ever to do this) or you can you piggy back on an already live sql enterprise box (thats not even close to being utilized)? I am not sure how legal this might be or even if my boss would go for it, but at $500 for sql 2000 enterprise (state prices!!!) maybe something else could be done... [EMAIL PROTECTED] 05/15/02 08:59AM I know that MySQL cannot really stand up to MS SQL but when you are talking about the amount that MS SQL costs versus using MySQL, I would us MySQL unless someone just wanted to pay for MS SQL. -- Clint Tredway -- Through Him, anything is possible. Can you say crap. :) I am not a big fan of MySQL. I have to do some work in it and it pales in comparison. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 5:19 PM To: CF-Talk Subject: Re: [admin] List status Can you say MySQL? g - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 6:10 PM Subject: RE: [admin] List status Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [admin] List status
Duh Verity I forgot about that. But still wouldnt the back end of sql be alot faster than cf verity? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:03 AM To: CF-Talk Subject: RE: [admin] List status Does mysql have full text searching capabilities like MS SQL if not then they would be almost pointless to use MY SQL to search through the list archives. Josh -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:50 AM To: CF-Talk Subject: RE: [admin] List status Michael are we talking getting an actually box at your place (or where ever to do this) or you can you piggy back on an already live sql enterprise box (thats not even close to being utilized)? I am not sure how legal this might be or even if my boss would go for it, but at $500 for sql 2000 enterprise (state prices!!!) maybe something else could be done... [EMAIL PROTECTED] 05/15/02 08:59AM I know that MySQL cannot really stand up to MS SQL but when you are talking about the amount that MS SQL costs versus using MySQL, I would us MySQL unless someone just wanted to pay for MS SQL. -- Clint Tredway -- Through Him, anything is possible. Can you say crap. :) I am not a big fan of MySQL. I have to do some work in it and it pales in comparison. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 5:19 PM To: CF-Talk Subject: Re: [admin] List status Can you say MySQL? g - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 6:10 PM Subject: RE: [admin] List status Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. __ 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
Studio Problem
In Studio 5 when I try to query the help it always comes up with No matches Found no matter what I put in. I have put in cfquery and nothing comes up. Is there anything I can do to fix this or is a reinstall coming my way? Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio Problem
Thanks you guys rock. Josh -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:31 AM To: CF-Talk Subject: RE: Studio Problem Joshua: I've seen this before and I've fixed it by deleting (or renaming) the Searchable Help folder in [root drive]:\Program Files\Macromedia\ColdFusion Studio 5\Verity\collections. The next time you go to use the Help search, Studio will ask if you want to rebuild the indexes. Try that rather than a reinstall. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:25 AM To: CF-Talk Subject: Studio Problem In Studio 5 when I try to query the help it always comes up with No matches Found no matter what I put in. I have put in cfquery and nothing comes up. Is there anything I can do to fix this or is a reinstall coming my way? Joshua Tipton __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity (was: [admin] List status)
That it was I thought but me not ever using verity before I was not sure. Josh -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:32 AM To: CF-Talk Subject: Re: Verity (was: [admin] List status) Duh Verity I forgot about that. But still wouldnt the back end of sql be alot faster than cf verity? No, there's no reason for it to be that way. The K2 server is pretty fast. In addition, you can offload K2 search functionality onto a separate machine from your web and database servers. no caching. can't join back to the indexed table. can't combine with other WHERE clause stuff. sql server text indexing beats the pants socks off of verity. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing sql server dts package from cf
I use this code all of the time. I have changed some of the documentation on this code so that you will know what is going on. CFOBJECT TYPE=COM NAME=objDTS CLASS=DTS.Package ACTION=CREATE There are 3 primary locations DTS packages are generally loaded from: From SQL Server, from Storage File, or from repository. There are 3 different primary methods that can be executed, one for each of these DTS locations. LoadFromSQLServer Syntax: ObjectName.LoadFromSQLServer(ServerName, ServerUserName, ServerPassword, Flags, PackagePassword, PackageGuid, PackageVersionGuid, PackageName, pVarPersistStgOfHost) NOTE: If you want to retrieve the PackageGuid, PackageVersionGuid, PackageName from the database, run the sp_enum_dtspackages system stored procedure. It returns the following variables: name, id, versionid, description, createdate, owner, size, packagedata, isowner LoadFromStorageFile Syntax: ObjectName.LoadFromStorageFile(UNCFile, Password, PackageID, VersionID, Name, pVarPersistStgOfHost) LoadFromRepository Syntax: ObjectName.LoadFromRepository(RepositoryServerName, RepositoryDatabaseName, RepositoryUserName, RepositoryUserPassword, PackageID, VersionID, PackageName, Flags, pVarPersistStgOfHost) This is sample code to execute a (SQLServer) DTS from ColdFusion (objDTS is the Object I created, server is shorwith, username is sa with no password, test is the name of the DTS): CFTRY CFOBJECT TYPE=COM NAME=objDTS CLASS=DTS.Package ACTION=CREATE CFCATCH TYPE = Object CFSET error_message = The DTS Package Object Could Not Be Created. /CFCATCH /CFTRY CFTRY CFSET r = objDTS.LoadfromSQLServer(SHORWITH,sa,,0test,) CFCATCH CFSET error_message = The DTS Package Could Not Be Loaded From the SQL Server at this time. /CFCATCH /CFTRY CFIF IsDefined(error_message) CFOUTPUT#error_message#/CFOUTPUT /CFIF CFSET p = objDTS.Execute() -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:07 AM To: CF-Talk Subject: RE: executing sql server dts package from cf Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows. CFSET sArg = /S servername /U username /P password /N packagename CFEXECUTE name=c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe arguments=#sArg# outputfile=c:\MyExportLog.txt timeout=1800/ HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with 1st hit to MSSQL 7.0
Just a thought but check the power management on your machine running sql make sure that the hdds are not going to sleep -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 9:08 AM To: CF-Talk Subject: RE: Problem with 1st hit to MSSQL 7.0 I had this problem before, try putting on the service pack for SQL again. I use client variables and when I have this problem I get that hit right away when I hit my application. It's very annoying. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:55 PM To: CF-Talk Subject: Problem with 1st hit to MSSQL 7.0 Hi all, The first query to my MS SQL server 7.0 always takes a long time, like 14000ms. After the first hit to the DB it runs fine, until about 20 mins of idle time. Then the next hit to the DB takes about 14000ms again. So its like the first hit to the DB every session takes an extremely long time. The query could be as simple as: SELECT * FROM Users WHERE UserID = 25 There are maybe 40 records in the user table and maybe a dozen fields. Im thinking there is a configuration/performance setting im missing, or something. Ive tryed checking and unchecking the Maintain database connections in the CF administrator, but it doesnt effect my problem. Any ideas? Thanks, Jeff __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql query
I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql query
Thanks everyone. -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:28 AM To: CF-Talk Subject: RE: sql query The example below seems easier, but you could also: cfset ssn_formatted = Left(ssn, 3)-Mid(ssn, 4, 2)-Right(ssn, 3) v/r, Jeff -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:20 AM To: CF-Talk Subject: Re: sql query All you need is the Insert() function, something like: SSN = Insert(-, SSN, 3); SSN = Insert(-, SSN, 6); Joshua Tipton [EMAIL PROTECTED] 05/01/02 09:14AM I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql Stored Proc
The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp corp char(4) = null, reg_no char(4) =null, dis_no char(4) =null, date1 varchar(4), date2 varchar(4) = null, rpttype char(10) AS /*SELECT corp, reg_no, dis_no, date1,date2, rpttype*/ declare col varchar(30) if(rpttype) = 'Missing' begin set col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (corp is not null and reg_no is null and dis_no is null and date1 is not null and date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (col) and year = date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(date1,1) select * from #blahtable drop table #blahtable END __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
I recieve an error incorrect synatx near the keyword and. declare @col as varchar(500) if(@rpttype) = 'Missing' begin set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL) end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod where @col and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:00 PM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
Can anyone else give me any insight on this? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:08 PM To: CF-Talk Subject: RE: sql Stored Proc I recieve an error incorrect synatx near the keyword and. declare @col as varchar(500) if(@rpttype) = 'Missing' begin set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL) end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod where @col and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:00 PM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ 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
Weird error
Anyone ever seen this error unknown exception condition PCodeDocumentNodeImp::prepareForExecution The error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (270:2) to (270:47) in the template file E:\SER\TSG\APPS\OVERDUEDISPO\OVDCORP\CTMREPORTS\DEFAULT1.CFM. __ 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
SQL Query
I need this query to pull the reg_no, dis_no, m_id, and the y_id from tbl_CTMCORPMONTHYEARRDD where it cannot be found in pagan table. I wrote this query and cannot get it to work please help. Josh SELECT tbl_CTMCORPMONTHYEARRDD.reg_no, tbl_CTMCORPMONTHYEARRDD.dis_no, tbl_CTMCORPMONTHYEARRDD.m_id, tbl_CTMCORPMONTHYEARRDD.y_id FROM tbl_CTMCORPMONTHYEARRDD INNER JOIN pagan ON tbl_CTMCORPMONTHYEARRDD.m_id pagan.m_id AND tbl_CTMCORPMONTHYEARRDD.y_id pagan.y_id AND tbl_CTMCORPMONTHYEARRDD.reg_no = pagan.reg_no AND tbl_CTMCORPMONTHYEARRDD.dis_no = pagan.DIS_NO __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get list of tables from a SQL Server DB
sp_helpdb and the db name -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 12:55 AM To: CF-Talk Subject: Re: Get list of tables from a SQL Server DB Is there any way I can get the list of tables in a SQL 2000 DB programmatically ? I guess what I need is a limited form of sp_help, as long as it just gives me all the user-created tables, system tables not grab the cf_sql pack from my shop's site. http://www.tei.or.th/eic/ under the free menu link. it includes that functionality among others. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Join/ QUERY HEADACHE problem
I have two tables that I am trying to join and it is killing me. 1st Table has the following columns Fields in 04_TSG_DISPOS.tbl_monthyearcorp COLUMN NAME DATA TYPE LENGTH NULLS ALLOWED monthid int identity 4 No month char 10 Yes year numeric 20 Yes m_id int 4 Yes y_id int 4 Yes The second table has the following columns that I need to join Fields in 04_TSG_DISPOS.CTMCORPAPP COLUMN NAME DATA TYPE LENGTH NULLS ALLOWED REGION nvarchar 4 Yes DISTRICT nvarchar 4 Yes SLIC nvarchar 16 Yes Desc nvarchar 60 Yes Cost float 8 Yes memomonth char 2 No memoyear char 2 No The query that I need is as follows select tbl_monthyearcorp.[month], tbl_monthyearcorp.[year], ctmcorpapp.region, isnull(SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END),0) AS INTCOST, isnull(SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END),0) AS exTCOST FROM tbl_monthyearcorp right OUTER JOIN CTMCORPAPP ON tbl_monthyearcorp.m_id = CTMCORPAPP.memomonth AND tbl_monthyearcorp.y_id = CTMCORPAPP.memoyear where region = '04' and [desc] like '%Miss%' group by region, [year], [month] I have tried right outer joins and it is not getting what I want. What I am wanting is that all months and years will display even if there is no datain the ctmcorpapp. so the output should show Region Month Year INTCOST EXTCOST 4 January 2001 0 or Null 0 or Null 4 February 2001 12 15 All the way down through all of the months. I think it has something to do with the case statement and I am hoping that someone can please help me with this I am dying on this one. If you need to call me to ask me anyquestions or would like me to call you I can just email me off list. Joshua Tipton __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Join/ QUERY HEADACHE problem
Can anyone help me with this??? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:28 AM To: CF-Talk Subject: SQL Join/ QUERY HEADACHE problem I have two tables that I am trying to join and it is killing me. 1st Table has the following columns Fields in 04_TSG_DISPOS.tbl_monthyearcorp COLUMN NAME DATA TYPE LENGTH NULLS ALLOWED monthid int identity 4 No month char 10 Yes year numeric 20 Yes m_id int 4 Yes y_id int 4 Yes The second table has the following columns that I need to join Fields in 04_TSG_DISPOS.CTMCORPAPP COLUMN NAME DATA TYPE LENGTH NULLS ALLOWED REGION nvarchar 4 Yes DISTRICT nvarchar 4 Yes SLIC nvarchar 16 Yes Desc nvarchar 60 Yes Cost float 8 Yes memomonth char 2 No memoyear char 2 No The query that I need is as follows select tbl_monthyearcorp.[month], tbl_monthyearcorp.[year], ctmcorpapp.region, isnull(SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END),0) AS INTCOST, isnull(SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END),0) AS exTCOST FROM tbl_monthyearcorp right OUTER JOIN CTMCORPAPP ON tbl_monthyearcorp.m_id = CTMCORPAPP.memomonth AND tbl_monthyearcorp.y_id = CTMCORPAPP.memoyear where region = '04' and [desc] like '%Miss%' group by region, [year], [month] I have tried right outer joins and it is not getting what I want. What I am wanting is that all months and years will display even if there is no datain the ctmcorpapp. so the output should show Region Month Year INTCOST EXTCOST 4 January 2001 0 or Null 0 or Null 4 February 2001 12 15 All the way down through all of the months. I think it has something to do with the case statement and I am hoping that someone can please help me with this I am dying on this one. If you need to call me to ask me anyquestions or would like me to call you I can just email me off list. Joshua Tipton __ 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
Oracle Gurus
I already have the create table and create sequence part complete I just actually need help with the insert part. I have never worked with a sequence. I have this much can anyone tell me if I am heading in the right direction and if so feel free to throw in any thing to help put me in the correct direction. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq.nextval%type; v_Name varchar2(30); v_DeptSize number(5); BEGIN END -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus I would be at anyone's mercy if they could do this for me. 1.Create a sequence DeptCodeSeq to generate dept codes in the range 1000, 1020, 1040, . .., 9080 Create table called Departments that has the following columns in it. DeptCode Name DeptSize NUMBER(4) VARCHAR2(30) NUMBER(5) Create a PL/SQL anonymous block called POPDEPTS.sql (Populate Department ) using FOR .. LOOP that uses the DeptCodeSeq to generate the department code and the name Where the name is constructed as DEPT-1020 DEPT-1040, and so on. That is the name of the department is the concatenation of DEPT- and the department code generated by the sequence. As each row is inserted print out the department t code and department name delimited by ';' on a separate line. ( use the DBMS_OUTPUT.PUT_LINE ). When testing your code you may need to constantly drop your sequence and create it until your PL/SQL block works correctly. DECLARE ... .. BEGIN Your code goes here ( you need FOR .. LOOP statement ) END; 2.Create a PL/SQL block to delete from Departments the departments that have their name ending in 40 and 80 digits. __ 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
JavaScript/CFinclude
I have one page that is a form that will be included in a java script popup. I was thinking about setting the page to a variable then outputting the page into the java script popup. Can anyone help me with this one? What I want to do: cfset content=cfinclude template=content.cfm Java Script Pop Up: script language=JavaScript window.onload=function(){ new popUp(155, 400, 696, 250, Div_ID1, cfoutput#content#/cfoutput, CC, FF, bold 10pt sans-serif, Add Users to cfoutput#appname.applname#/cfoutput, 66, white, #dd, gray, black, false, true, true, true, false); } /script __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle Sequence
Please help me, I have gotten this far and I am not having any luck. I need to output the numbers from the sequence into a database. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq; v_Name varchar2(30); v_DeptSize number(5); BEGIN for i in v_deptcode.nextval loop insert into Departments (DeptCode, Name, DeptSize) values (i, v_name, v_deptsize); end loop; drop sequence DeptCodeSeq __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle Gurus
I would be at anyone's mercy if they could do this for me. 1.Create a sequence DeptCodeSeq to generate dept codes in the range 1000, 1020, 1040, . .., 9080 Create table called Departments that has the following columns in it. DeptCode Name DeptSize NUMBER(4) VARCHAR2(30) NUMBER(5) Create a PL/SQL anonymous block called POPDEPTS.sql (Populate Department ) using FOR .. LOOP that uses the DeptCodeSeq to generate the department code and the name Where the name is constructed as DEPT-1020 DEPT-1040, and so on. That is the name of the department is the concatenation of DEPT- and the department code generated by the sequence. As each row is inserted print out the department t code and department name delimited by ';' on a separate line. ( use the DBMS_OUTPUT.PUT_LINE ). When testing your code you may need to constantly drop your sequence and create it until your PL/SQL block works correctly. DECLARE . BEGIN Your code goes here ( you need FOR .. LOOP statement ) END; 2.Create a PL/SQL block to delete from Departments the departments that have their name ending in 40 and 80 digits. __ 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: Oracle Gurus
I already have the create table and create sequence part complete I just actually need help with the insert part. I have never worked with a sequence. I have this much can anyone tell me if I am heading in the right direction and if so feel free to throw in any thing to help put me in the correct direction. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq.nextval%type; v_Name varchar2(30); v_DeptSize number(5); BEGIN END -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus I would be at anyone's mercy if they could do this for me. 1.Create a sequence DeptCodeSeq to generate dept codes in the range 1000, 1020, 1040, . .., 9080 Create table called Departments that has the following columns in it. DeptCode Name DeptSize NUMBER(4) VARCHAR2(30) NUMBER(5) Create a PL/SQL anonymous block called POPDEPTS.sql (Populate Department ) using FOR .. LOOP that uses the DeptCodeSeq to generate the department code and the name Where the name is constructed as DEPT-1020 DEPT-1040, and so on. That is the name of the department is the concatenation of DEPT- and the department code generated by the sequence. As each row is inserted print out the department t code and department name delimited by ';' on a separate line. ( use the DBMS_OUTPUT.PUT_LINE ). When testing your code you may need to constantly drop your sequence and create it until your PL/SQL block works correctly. DECLARE ... BEGIN Your code goes here ( you need FOR .. LOOP statement ) END; 2.Create a PL/SQL block to delete from Departments the departments that have their name ending in 40 and 80 digits. __ 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