RE: QofQ insert
Thanks for the replies. Yes, I was just tring not to do a possible 1k db calls. Just tring to cut down on the network traffic. I will do a few test runs and see if there is enough of a performance improvement to not do the loop. Thanks Rodney -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 4:38 PM To: CF-Talk Subject: RE: QofQ insert I do not believe what you are looking for is possible. Depending on your DBMS you have a couple different options. Instead of creating a query object, perhaps you could re-factor your code to insert into a table variable in a cfquery tag and then to the insert from there. Another solution would be to serialize the query object into XML, and pass it into a proc or SQL statement where the XML could be parsed on the SQL server into a result set and do your insert from their. That would be pretty dependant on SQL Server 2000, or 2005 though. Why are you opposed to looping over the result set? If you are trying to avoid a performance problem, the methods above wouldn't be much better since they all involve looping at some level. You could at least try to minimalize locks open on the table by doing the insert all at once as opposed to one at a time. You could move the cfloop inside the cfquery and produce sql like such: Insert into table (col1, col2) (select 'foo1', 'bar1' Union all select 'foo2', 'bar2' Union all select 'foo3', 'bar3' Union all select 'foo'4, 'bar4') ~Brad -Original Message- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
QofQ insert
Hi all I have created a query, I can use dbtype="query". I can do the loop: INSERT INTO table1(column1, column2, column3) Values (Table2Query.column1,...) I am trying not to loop over my query for this insert. in SQL you can do: INSERT INTO Table1 SELECT column1, column2, column3 FROM Table2 and insert records from table2 into table1 How can I do this with ? INSER INTO table1 SELECT column1, column2, column3 FROM Table2Query table1 needs the datasource table2 is QoQ Is this possible? Thanks Rodney ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Maintance plan
Hi, Posted in the SQL mailing list but haven't heard anything, so figured I would try here. Hope some one can help with exporting a maintance plan from a MS SQL 2005 database. The servers are isolated. I need to be able to get a file on a CD to move the plans from one server to the other. I have found: Open SQL Server Management Studio Select File | Connect Object Explorer Change the Server Type to Integration Services and connect to the server Expand Servername (Integration Services) | Stored Packages | MSDB | Maintenance Plans Right Click on the Maintenance Plan and select Export But this only seems to let you export from/to servers you can contect at the same time thru SSMS. I don't see a way to save/export to a file. Is there a way to export the plan(s) to a file? Thanks Rodney ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: braindead duh!! moment with db
Don't know why you are getting the ds or Is. But a few things I would do are: Alias one of the designerIDs or remove it from the SELECT. Scope the vars #getItems.itemid##getItems.designerid#, something might be in designerid from another scope. Do a of the query and see what is in the recordset. See if you have ds in the recordset before you are outputting the data. If you have ds in the recordset from the then I would go back and run the query in the database and look at what is in the tables. -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 3:10 PM To: CF-Talk Subject: RE: braindead duh!! moment with db Yes, it was abbreviated. And, yes I'm tired. I should have stated designerID not designerName? here's a snippet (MUCH IS CUT OUT) SELECT items.itemID, items.categoryID, items.itemTypeID, items.designerID, items.designerItemCode, items.itemName, items.itemDescShort, items.itemPrice, designers.designerID, designers.designerName, designers.designerNameWWW, designers.isActive, designers.hasDescriptionPage FROM items, designers WHERE items.designerID=designers.designerID -- #itemID# -- #designerID# I ought to get a list of numbers -- 77 -- 20 -- 78 -- 20 Etc.. Instead I get -- 77 -- d -- 77 -- d -- 78 -- d -- 78 -- d -- 78 -- d If I ran the query width itemTypes (changed the tables and fields) and put in itemTypeID instead of designerID I get a list with an i instead of a d. Go figure!? I swear these queries worked before! :-) ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DoD CAC authentication
Mike Very basic: When you go into IIS(what we use) and make the selection to accept/require certificates. You will then get the CGI.Cert_subject variable filled in ([empty string] when not accepting client certs). We broke this out into for variables we use: Cert_name, Cert_number, Cert_type,Cert_CACType mailto:[EMAIL PROTECTED] Sent: Monday, July 30, 2007 2:05 PM To: CF-Talk Subject: DoD CAC authentication I'm thinking of using CAC to provide a means of authenitcating users to a role controlled application. I've found little to cover this on the web over basic IIS "accept client certs" and wonder if anyone in community has worked on something similar. Best, Michael Miller ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using .jar file with
Thanks for your help. But still getting the error. This is the line were its erroring: The png file is being created. (the empty one, not with image). The svg is in the same directory as were the png file is being created. I have opened the svg file in Visio and it works there. I have resaved from Visio, to see if it might be an issue with my code writing the svg file. It's a very small file 8kb, just a few symbols and lines. Going to try to post on batiks site. Thanks Rodney -Original Message- From: Janet MacKay [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 7:33 PM To: CF-Talk Subject: Re: Using .jar file with >Unfortunetly I am still doing something wrong. > >I get this error when I run the code: >500 org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation >org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation I couldn't get it to work with just those two jars. I ended up adding the _directory_ paths to the CF admin classpath: E:\batik\batik-1.7\,E:\batik\batik-1.7\lib, Restarted and voila the code worked. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using .jar file with
Thanks everyone for your replies. Unfortunetly I am still doing something wrong. I get this error when I run the code: 500 org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation Which is also what I get when I MakeImage, Which I thought should show the methods? If I understood this page: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/w whelp.htm?context=ColdFusion_Documentation&file=1566.htm Note: The cfdump tag displays an object's public methods and data. So maybe I did not do the CLASS PATH corrrectly in CF admin? I entered: E:\batik\batik-1.7\batik.jar E:\batik\batik-1.7\batik-rasterizer.jar Or should I go the next level down and map: E:\batik\batik-1.7\lib (+\file.jar) And WOW you guys work late. Thanks Rodney -Original Message- From: Janet MacKay [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 10:32 PM To: CF-Talk Subject: Re: Using .jar file with > > Rodney, Don't use expandPath() if you're going to supply an absolute path. That might have been what was messing you up. This worked for me ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using .jar file with
Don't seem to like that either. Get the same error message. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 4:11 PM To: CF-Talk Subject: RE: Using .jar file with > Try "e:/temp/tempimage.png". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using .jar file with
Thanks that helped, book marked that web page. Sorry, this is the first time I have tried to use jar files. Only other is for . The error messages being generated don't help much. Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this exception was that: . For this line of code: If I remove "e:\temp\" , it works, but does that mean I can't tell it to place the image in any other dir, besides the current one? When I do remove the dir and get past that error I get: 500 org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation For: Full code on the page(mostly adapted from http://barneyb.com/barneyblog): Going to google and see if I can work this out. Thanks for your help Rodney ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using .jar file with
Thanks that helped, book marked that web page. Sorry, this is the first time I have tried to use jar files. Only other is for . The error messages being generated don't help much. Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this exception was that: . For this line of code: If I remove "e:\temp\" , it works, but does that mean I can't tell it to place the image in any other dir, besides the current one? When I do remove the dir and get past that error I get: 500 org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation org/apache/batik/dom/svg/ExtensibleSVGDOMImplementation For: Full code on the page(mostly adapted from http://barneyb.com/barneyblog): Going to google and see if I can work this out. Thanks for your help Rodney -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 1:28 PM To: CF-Talk Subject: Re: Using .jar file with As noted, this still won't work You are still trying to call a jar directly. A jar *contains* class files you need to use the api http://www.stylusstudio.com/api/batik/overview-summary.htm I.e calling them via com.batik.whatever "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message- From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions To: CF-Talk Sent: Tue May 08 21:17:12 2007 Subject: RE: Using .jar file with No. I am trying to convert svg files to images. I found batik and am trying to get it to work, I found: http://barneyb.com/barneyblog/index.php?s=batik&searchsubmit=Go Following those instructions don't seem to work either, with that code I get: Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this exception was that: . I can get the examples on Batik's website to run from the cmd window, with my svg files. I have tried: Thanks Rodney -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 12:17 PM To: CF-Talk Subject: Re: Using .jar file with A jar isn't a class file itself. Do you know what class you want to instantiate? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions To: CF-Talk Sent: Tue May 08 20:15:41 2007 Subject: Using .jar file with Hi I am trying to get a .jar file to work with I placed the file in a dir: d:\java\myjar.jar. I put the dir in the class path in the Coldfusion administrator. Stopped/started the service. Tried: when I run the page I get the error: Object Instantiation Exception. Class not found: myjar.jar Verified my spelling of the dir in the class path. In Coldfusion administrator I looked at System Information and can see d:\java\myjar.jar in the Java class path listing. In the cmd window I can go to the dir and run java -jar myjar.jar and it runs. What am I missing to get this to work? Thanks Rodney ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/mes
RE: Using .jar file with
No. I am trying to convert svg files to images. I found batik and am trying to get it to work, I found: http://barneyb.com/barneyblog/index.php?s=batik&searchsubmit=Go Following those instructions don't seem to work either, with that code I get: Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this exception was that: . I can get the examples on Batik's website to run from the cmd window, with my svg files. I have tried: Thanks Rodney -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 12:17 PM To: CF-Talk Subject: Re: Using .jar file with A jar isn't a class file itself. Do you know what class you want to instantiate? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions To: CF-Talk Sent: Tue May 08 20:15:41 2007 Subject: Using .jar file with Hi I am trying to get a .jar file to work with I placed the file in a dir: d:\java\myjar.jar. I put the dir in the class path in the Coldfusion administrator. Stopped/started the service. Tried: when I run the page I get the error: Object Instantiation Exception. Class not found: myjar.jar Verified my spelling of the dir in the class path. In Coldfusion administrator I looked at System Information and can see d:\java\myjar.jar in the Java class path listing. In the cmd window I can go to the dir and run java -jar myjar.jar and it runs. What am I missing to get this to work? Thanks Rodney ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using .jar file with
Hi I am trying to get a .jar file to work with I placed the file in a dir: d:\java\myjar.jar. I put the dir in the class path in the Coldfusion administrator. Stopped/started the service. Tried: when I run the page I get the error: Object Instantiation Exception. Class not found: myjar.jar Verified my spelling of the dir in the class path. In Coldfusion administrator I looked at System Information and can see d:\java\myjar.jar in the Java class path listing. In the cmd window I can go to the dir and run java -jar myjar.jar and it runs. What am I missing to get this to work? Thanks Rodney ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Moving a
Sorry this might be OT. I have a header on a large table that scrolls down. The top of the header starts at about 106px. I want the header to move down, once the top of the window gets to it and then stay about 10px below the top of the window until the user scrolls back up, then for it to stop at its origanal postion(106px). I found some javascript that I got to work. What I did was have a hidden that matched the header. When the top of the window got to the header the was unhidden and followed the user down. When the user got back up to the header, the hide again. The is always 10px from the top of the window, but is hidden until the top gets to about 105px, then is shown, so to the user it just looks like the header starts to move. BUT this does not work if I use, either of these: http://www.w3.org/TR/html4/strict.dtd";> Dreamweaver 8, seems to default to this one: http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> But does work with: So must be a feature that is being left behind. I have tried using Position: Fixed in my css, but IE has issues with this. Found more javascript that will in general get Postion: Fixed to work with it. But if I do this and start my over the header, it will then stay 106px from the top of the window. How can I get the to either not move until the top of the window gets to the header and then stay at 10px from window top. Or hide the like I was doing and have it only show up when the top of the window is at or below 105px? Thanks and sorry for the long winded msg. Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: An issue with CFC output
Thanks I thought that the default was false. if output="false" is not in the function tag the extra charaters show up. I just had: -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 12:52 PM To: CF-Talk Subject: RE: An issue with CFC output Without seeing more of your CFC code, I would hazard a guess that you need to add output="false" to your function declarations. Otherwise white space generated in the function can be passed onto the calling page. HTH If not, give us a better example of your CFC and relevant function. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
An issue with CFC output
Hi all Hope I can explain this. Has anyone encountered an issue with outputing a returned string from a CFC method? I have a CFC that has a function that returns a string. The function use to just be on a .cfm page that I . We have just recently upgraded to CFMX 7, so I wanted to get my functions into CFCs. using If I do this: #newstring# All is good But if I do #Myobject.myfunction(oldstring)# I get extra non printable chars in front of the output. After expermenting for awhile, I can see that the extra chars are being placed in front of the returned string at the time of output. Not by the function itself. If I do: I get no extra chars. The extra chars are added at the function dump to output #Myobject.myfunction(oldstring)#. Were this is an issue is in queries: SET field1 = #Myobject.myfunction(oldstring1)#, feidl2 = #Myobject.myfunction(oldstring2)#, . I would have to do a bunch of cfsets before the query. Do able but annoying to have the extra lines of code or place the output into a rereplace expression. Thanks for any help Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: using a datasource thru mapped drive
Not sure if I completely understand. But: We connect to a remote MySQL database(remote as in, in another building and different network). Have you tried to set up an ODBC connection thru Administravtive Tools/Data Sources(ODBC)? We set up a System DSN in there using an account that has the necessary permissions on the MySQL box. This DSN will then show up in the ColdFusion Admin when you select ODBC Socket as your driver. This has also worked with making connections with .xls files and others. Just had to make sure the server making the ODBC socket had the necessary drivers. -Original Message- From: Brian Coleman [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 8:33 AM To: CF-Talk Subject: Re: using a datasource thru mapped drive "you need to run coldfusion under a user that has access to the network resource your conencting to." If you mean the CF services, I am running them with a user that has access. I'm actually running them with a user that probably has over kill permissions as far as the network goes, just to try to get it to work. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: StructFindKey Path and evaluate
We are using MS SQL 2000. I do some of the math in the db. I am very weak with rollup, so maybe you can see what I am missing. Example: Project: Task1 --Task1.1 --Task1.2 -- Has hours --Task1.2.1 --Task1.2.2 -- Has hours --Task1.2.3 --Task1.3 Task2 Task3---Has hours The rollup can get me the totals for a Project, CostArea and each individual task, but not the roll ups for tasks like Task1.2 or Task1. Here's a query I am playing with:(limiting to one project for faster testing :o). SELECT P.PROJ_NAME, TF.TEXT_VALUE AS CostArea, T.TASK_UID, T.TASK_NAME, GA.res_name, SUM(GA.Cost) AS cost, SUM(GA.HOURS) AS hours FROM TBLAllProjects P INNER JOIN ProjectServer_2003.dbo.MSP_TASKS T ON P.PROJ_ID = T.PROJ_ID LEFT OUTER JOIN TBLGovActuals GA ON P.PROJ_ID = GA.proj_id AND T.TASK_UID = GA.TASK_UID LEFT OUTER JOIN ProjectServer_2003.dbo.MSP_TEXT_FIELDS TF ON T.TASK_UID = TF.TEXT_REF_UID WHERE (TF.TEXT_FIELD_ID = 188744479) AND (TF.TEXT_VALUE IS NOT NULL) AND (T.TASK_UID > 0) AND (P.PROJ_ID = 840) GROUP BY P.PROJ_NAME, TF.TEXT_VALUE, T.TASK_UID, T.TASK_NAME, GA.res_name, T.TASK_NAME WITH ROLLUP The only fields that tell you were a Task is, are: Task_lvl(1,2,3, etc) and Task_number(1, 1.1, 1.2, 1.1.1, ext). The Query doesn't know that 1.1, 1.1.1 and 1.2 get rolled up into 1. So I don't see were it's possible to do the roll ups for the top lvl tasks. Thanks Rodney -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 5:22 AM To: CF-Talk Subject: Re: StructFindKey Path and evaluate Yes, I was thinking that a cube of this would probably provide most of the desired info in a query (although I haven't looked closely enough to be sure). Does your DB do cube and rollup? On 4/20/06, Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E LCMC > HQISEC/Signal Solutions wrote: > > If there is a better way to do this, please let me know. I don't really > > like the way I am doing it, but unfortunetly I havent come up with > > anything better and I do seem to do things the hard way. > > Getting the DB to do the maths ? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: StructFindKey Path and evaluate
>Ya know if that tree was flattened into a few database tables, it'd all be >much easier :-) >-- >Tom Chiverton >Advanced ColdFusion Programmer The information comes from 4 tables. There's many more fields in each table, but here is the short break down. Project_table Proj_id Proj_name WorkPlan_id Task_table Task_id Task_name Proj_id Cost_id Task_lvl(works with the Task_number, 1(is lvl 1), 1.1(lvl 2), 1.1.1(lvl 3) and so forth) Task_number(this is the closes to linking parent/children, the numbers are 1, 1.1 1.2, 1.1.1, 1.1.2) So a task with number 1.1 is a child to 1 Cost_table Cost_id Cost_area Hours_table Task_id Task_name Person_name Hours Cost_per_hour Worker_type What is wanted is, put a workplan_id in and get all projects/tasks/person(cost/hours). Hope I can explain this, :o) All Projects and tasks need to be displayed(whether hours are logged against it or not). The display is hierarical(much more graphical, lol): Project_name --1 Task_name --1.1 Task_name 1.1.1 Task_name 1.1.2 Task_name Person_name: Hours/cost Person_name: Hours/cost --2 Task_name Person_name: Hours/cost When a user mouses over the project_name or task_name, they get a popup display with roll ups for that lvl(ie. Mouse over 1.1 would include 1.1,1.1.1, 1.1.2). Mouse over the project_name gives the over all totals for the whole project. These are boken out into: Total: hours/Costs; Totals by Worker_type1: hours/costs; Totals by Worker_type2: hours/costs;(etc..) Totals by cost_area1: hours/costs; Totals by cost_area2: hours/costs;(etc..) I do two queries that populate/create the structure. The first links: Project, Task and Cost Tables and creates the main structure. The second gets the information from the hours table and adds it to the structure(per examples in previous emails). While adding the worker information, the totals are also calculated and placed in the structure. Then loop thru the structure to create the displays. The other ways I could come up with had me looping thru queries multipule times while creating the display, which was slower. If there is a better way to do this, please let me know. I don't really like the way I am doing it, but unfortunetly I havent come up with anything better and I do seem to do things the hard way. Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238129 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Evaluate vs ?
Ok, guess I am missing something here: If #variable# is not set CF errors, If #variable# is set puts value into foo. #foo#---foo would output to be "fee fi fo fum #variable# this is dynamic content" is what was wanted?? -not necessarily outputted, but to still contains the #variable# unresolved? This will set that up: But even using evaluate, this errors with (Invalid CFML construct found): #evaluate(foo)# And just to test, this errors if #variable# is not set Can you show were this would work and be used, with evaluate? Have me curious now. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 12:24 PM To: CF-Talk Subject: Re: Evaluate vs ? This does the same thing as his: My guess is he was saying for the value of "variable" to not be put into foo until the time that it was outputed instead of when set. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Evaluate vs ?
Here is part of the code I use to create emails that are sent out monthly. I have removed a lot of code, queries and more of the msg being build, but this should give you an idea. By no means is this the best example . But it does work: -Part of the msg being build- Adds to msg- CFMAIL here - The listed below individuals have logged the indicated hours to I3MP for the Month of: #mon# #dyear#. Please confirm accuracy and provide response NLT 10 days from receipt. Negative response indicates agreement with the hours reported in this email. DO NOT REPLY TO THIS EMAIL. #msg# -Original Message- From: Charles Sheehan-Miles <[EMAIL PROTECTED]> To: CF-Talk Date: Tue, 18 Apr 2006 13:42:01 -0400 Subject: Re: Evaluate vs ? > Sometimes I send out emails through my system which dynamically > generate the content from variables: > > example: > > Last year you gave $#lsnumberformat(lastyear, "9.99")# to support our > work. This year we hope you'll give $#lsnumberformat(lastyear*2, > "9.99")#. > > My mailer routine uses evaluate against the string to parse out those > values, then it is sent out via cfmail inside a loop. If Evaluate() > isn't recommended, is there a better way to do this? Typically this > type of mailing might go out to 10 or 12 thousand emails at once. > > > On 4/18/06 1:29 PM, "Nick de Voil" <[EMAIL PROTECTED]> wrote: > > >> Is there a time when evaluate should be used? > > > > If you want to dynamically build an unpredictable string which > contains > > logic, rather than just variable names, then afaik you can only > invoke the > > logic using Evaluate(). But then again, that's not something that > people > > need to do very often. > > > > Nick > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238035 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Evaluate vs ?
Unless I missed something, there is no need to treat as a structure or use DE() or Evaluate(). #foo# This would work just fine. -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 12:04 PM To: CF-Talk Subject: Re: Evaluate vs ? that's not really true claude, take the following. You would need to use DE() and Evaluate() to output the content of foo properly with any variables displayed, there is no way to treat that as a struct. Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238032 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: StructFindKey Path and evaluate
Yes, StruckFindKey returns a value, but in my case the value is a structure. Example: [MyStruct] [ProjectA] --[Task1] [Task1.1] [Task1.2] [Task1.3] --totalhours --totalcost --costarea --[Task2] [Task2.1] [ProjectB] --[Task1] All tasks(at all lvls)are structures with the keys totalhours,totalcost and costarea. I then have a person that has logged hours to a task. I have to find the task and add the persons information to it. So I am not going to the very bottom of the structure, the value at MyStruct.ProjectA.Task1.Task1.3, would be a structure not a simple value. I then add the persons hours/cost to the totals and add another lvl to the structure for each person . [Task1.3] --totalhours --totalcost --costarea --[person1name] Person1cost Person1hours --[person2name] Person2cost Person2hours So, I guess the simple answer to your question is yes, I am getting the path to another key(s), just below the one I found. Rodney -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Saturday, April 15, 2006 3:45 PM To: CF-Talk Subject: Re: StructFindKey Path and evaluate Most likely I missed something, because doesn't structFindKey return a value as well as the path to the key? Unless you're talking about getting the "path" to another key, not the one you just found.? XPath only works with XML documents, neh? Hmm... must need more coffee... missing something obvious, feels I... :d ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: StructFindKey Path and evaluate
Isaac, Thanks for the
StructFindKey Path and evaluate
Hi all I have a structure I am using StructFindKey with. Which returns an array/Structure. One of keys returned is Path, which is a dot separated list of the path thru the structure to the key your looking for. Something like: MyStruc.item1.item2.item3.item4 (find key Item4), returns item1.item2.item3.item4 I tried: NewPath = 'MyStruc' & Path (with and without using evaluate) couldn't get it to work. I did get this to work: did a replace to make path = ['item1']['item2']['item3'['item4'] NewPath = 'MyStruc' & path #Evaluate(NewPath & '.lastitem')# Is there anyway to get this to work with out using Evaluate? Hope I explained this well enough? Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Schueduled Task in CF MX7
Thanks for the information. I don't know what happened, but the scheduled tasks are now working (fingers crossed, they stay that way). They were not running earlier, when I was tring to get them to run. I was sidetracked by some meetings and other tasks for a few hours and decided to try and work on them again, when I ran them they worked. Maybe it just took awhile for everything to connect. Thanks all Rodney -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 9:06 AM To: CF-Talk Subject: RE: Schueduled Task in CF MX7 > I tried this and received the error "input not an X.509 > certificate", I verified with the admin , that the cert is X.509. > > We have "Java 2 Runtime Enviroment, Standard Edition Version 1.4.2". > > The technote, mentioned to down load JDK 1.4.2_03 or later. > > I found: >J2SE v 1.4.2_10 SDK with NetBeans IDE 4.1 Software > Bundle for download on the sun site. According to the system requirements docs on the Adobe site, the latest supported version of the JVM for ColdFusion is 1.4.2_09. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Schueduled Task in CF MX7
Thanks everyone so far for the help The link below seems to have gotten me part way there. The Certificate was imported, ok (seemed to be any way). I had a page running a CFHTTP test, was just doing a to the page of #cfhttp#. Before the import the dump was empty, now its coming back with filecontent, headers etc. So CFHTTP now seems to be working. But the schueduled tasks still are not. On the server were CF is running, I can copy and paste the urls from the CF admin into another IE window and run them. So the Urls and pages themselves seem to be fine. I must still be missing something for CF. Rodney -Original Message- From: CF [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 11:00 PM To: CF-Talk Subject: Re: Schueduled Task in CF MX7 Hi Bruce, With CF7 importing should work "out of the box". Here's a posting where Stace explains this in detail for CFHTTP (and thus for scheduled tasks). She wrote it to this list in 2002. Worked like a charm for me last month. Thanks Stace! :-)) http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/Threadid:13865# 72003 Chris On Mon, 3 Apr 2006 14:59:19 -0700 "Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions" <[EMAIL PROTECTED]> wrote: > Thanks for the help > > I tried this and received the error "input not an X.509 certificate", > I verified with the admin , that the cert is X.509. > > We have "Java 2 Runtime Enviroment, Standard Edition Version 1.4.2". > > The technote, mentioned to down load JDK 1.4.2_03 or later. > > I found: >J2SE v 1.4.2_10 SDK with NetBeans IDE 4.1 Software Bundle > for download on the sun site. > > Is this what I need to download? > > -Original Message- > From: Stacy Young [mailto:[EMAIL PROTECTED] > Sent: Monday, April 03, 2006 2:02 PM > To: CF-Talk > Subject: RE: Schueduled Task in CF MX7 > > > You may have to import ssl certs into the jvm keystore. This should > get you started, talks about LDAP but issue is related: > > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19139 > > Stace > > -Original Message- > From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions > [mailto:[EMAIL PROTECTED] > Sent: Monday, April 03, 2006 4:27 PM > To: CF-Talk > Subject: Schueduled Task in CF MX7 > > Hi > > Hoping some one will help me out with a problem we are having. > > We have finally upgraded to MX7 from CF5. > > We have gotten everything to work but Scheduled Tasks. > > I can get them to run by turnning off SSL. > > How can we get the scheduled tasks to run and still run HTTPS? > > Thanks > Rodney > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Schueduled Task in CF MX7
Does any one have a working link to download the Java updates? Every download link I tried on Sun's site does not seem to work. Thanks -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 2:02 PM To: CF-Talk Subject: RE: Schueduled Task in CF MX7 Hi Hoping some one will help me out with a problem we are having. We have finally upgraded to MX7 from CF5. We have gotten everything to work but Scheduled Tasks. I can get them to run by turnning off SSL. How can we get the scheduled tasks to run and still run HTTPS? Thanks Rodney Change the user the CF service runs under? One must remember that the default system user often has limitations when dealing with scheduled tasks and cfhttp and other "browser" type tasks. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236852 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Schueduled Task in CF MX7
Thanks for the help I tried this and received the error "input not an X.509 certificate", I verified with the admin , that the cert is X.509. We have "Java 2 Runtime Enviroment, Standard Edition Version 1.4.2". The technote, mentioned to down load JDK 1.4.2_03 or later. I found: J2SE v 1.4.2_10 SDK with NetBeans IDE 4.1 Software Bundle for download on the sun site. Is this what I need to download? -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 2:02 PM To: CF-Talk Subject: RE: Schueduled Task in CF MX7 You may have to import ssl certs into the jvm keystore. This should get you started, talks about LDAP but issue is related: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19139 Stace -Original Message- From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 4:27 PM To: CF-Talk Subject: Schueduled Task in CF MX7 Hi Hoping some one will help me out with a problem we are having. We have finally upgraded to MX7 from CF5. We have gotten everything to work but Scheduled Tasks. I can get them to run by turnning off SSL. How can we get the scheduled tasks to run and still run HTTPS? Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236851 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Schueduled Task in CF MX7
Hi Hoping some one will help me out with a problem we are having. We have finally upgraded to MX7 from CF5. We have gotten everything to work but Scheduled Tasks. I can get them to run by turnning off SSL. How can we get the scheduled tasks to run and still run HTTPS? Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
MySQL Blob issues
Hello all, I need to build a CF (using CF5) front end to a MySQL database. I am having issues trying to get the data from the Blob datatype fields. There are images, files(mostly MSword) and large blocks of text in the fields. My searches have not found much, mostly devleopers/coders disucsing the pros and cons of putting images/files in a database. I have found a few with PhP code for getting the images , but so far no way to do it with Coldfusion. Downloaded and installed Connector/ODBC 3.51.12 from mysql.com to make the OBDC connection. The database is MySQL 5. Any help on getting any of the three diffrent types of blobs, using Coldfusion would be appricated. Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Session time out[ENCRYPTED]
Hi all I know I have seen threads about giving the user a warning that their session is about to timeout and possibly giving them the option to reset the timer, but I am not having any luck finding the threads in the archives. any help would be appreciated. Thanks Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Session time out
Hi all I know I have seen threads about giving the user a warning that their session is about to timeout and possibly giving them the option to reset the timer, but I am not having any luck finding the threads in the archives. any help would be appreciated. Thanks Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: A lesson in security by obscurity...
up to 12 signed the quess book will try others tomorrow. Is kind of fun -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:10 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... Darn it! I'm not getting any work done now! I'm up to level 13. I hate being compulsive -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com > -Original Message- > From: Marlon Moyer > Sent: Wednesday, April 21, 2004 4:34 PM > To: CF-Talk > Subject: RE: A lesson in security by obscurity... > > You guys are making it a lot harder than it is. It's probably the > simplest security measure up to that point. Well maybe not easier than > 1. > > > -- > Marlon Moyer, Sr. Internet Developer > American Contractors Insurance Group > phone: 972.687.9445 > fax: 972.687.0607 > mailto:[EMAIL PROTECTED] > www.acig.com > > > > -Original Message- > > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, April 21, 2004 4:31 PM > > To: CF-Talk > > Subject: RE: A lesson in security by obscurity... > > > > I did the same. 9 seems like a lot of quess work. Up to that point > it > > was a test of working around _javascript_ security and from what I can > > tell, to get to 9 you have to guess the name of the next page. If > > anyone takes the time to get there please share :-) > > > > > > > > A couple free tools helps you scan the server, spider the site and go > to > > town. :-) > > > > > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfloop
FYI, running CF5 on WIN2K box with 1 Gig RAM -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 8:58 AM To: CF-Talk Subject: Re: cfloop looks consistent. I ran Ray's loop and it stopped (no error) at 36799. This was on MX. On CF 5, I do get an error: Attribute TO in tag CFLOOP has an invalid value Cannot convert 10,000,000 to number. Further testing indicates that the error above (again, on CF5) does not occur if I remove the commas from the 10,000,000. However, it's been about 3 minutes and the page is still trying to load. ...5 minutes... I'll report back : ) Charlie - Original Message - From: "Ray Champagne" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 16, 2004 8:42 AM Subject: Re: cfloop > Well, I just did a quick one (index loop) that tried to loop 10 million > times, and it looks like it consistently stops at 36,799 and goes no > further. That help? > > > #i# > > > Ray > > At 11:34 AM 4/16/2004, Tony Weeg wrote: > >hey there. > > > >whats the max number of iterations I can expect cfloop to handle before it > >craps out? > > > >1 million, 2 million? > >any number that anyone knows of? > > > >thanks! > > > >...tony > > > >tony weeg > >senior web applications architect > >navtrak, inc. > >www.navtrak.net > >[EMAIL PROTECTED] > >410.548.2337 > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfloop
Got curious so ran the loop with a little mod, added a just to watch. Lap #x# currently up to 2,563,324 and still going. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 8:58 AM To: CF-Talk Subject: Re: cfloop looks consistent. I ran Ray's loop and it stopped (no error) at 36799. This was on MX. On CF 5, I do get an error: Attribute TO in tag CFLOOP has an invalid value Cannot convert 10,000,000 to number. Further testing indicates that the error above (again, on CF5) does not occur if I remove the commas from the 10,000,000. However, it's been about 3 minutes and the page is still trying to load. ...5 minutes... I'll report back : ) Charlie - Original Message - From: "Ray Champagne" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 16, 2004 8:42 AM Subject: Re: cfloop > Well, I just did a quick one (index loop) that tried to loop 10 million > times, and it looks like it consistently stops at 36,799 and goes no > further. That help? > > > #i# > > > Ray > > At 11:34 AM 4/16/2004, Tony Weeg wrote: > >hey there. > > > >whats the max number of iterations I can expect cfloop to handle before it > >craps out? > > > >1 million, 2 million? > >any number that anyone knows of? > > > >thanks! > > > >...tony > > > >tony weeg > >senior web applications architect > >navtrak, inc. > >www.navtrak.net > >[EMAIL PROTECTED] > >410.548.2337 > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: expanding
> HI all > > I am just starting to use CSS. > > I want to replace a table I am using to display information with a CSS. > > The biggest issue I am having so far is that I cant get the s with > the data in them to all change size to match each other. > > > ie: > > If all s only have a single line of text, they are all the same size, > but if one wraps and has two or more lines, only that expands. > How can I get them all to expand or contract to be the same height no > mater what amount of text is in each ? > I limit the over all lenght with the outside . > > example: > > > text here > text here > text here, more text that will cause this div to > wrap and be taller then the others. > text here > > > > > Thanks > Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL QUESTION
This seems to be similar to something I just did. With help from this list I ended up creating a Stored Procedure, placing the information in multiple temp tables then joining the temp tables. Something like: SELECT OPPORTUNITY_ID AS C1, TEXT_TYPE_ID AS C2, OPPORTUNITY_TEXT_DATA AS C3 into Temp1 FROM OPPORTUNITY_TEXT WHERE (TEXT_TYPE_ID = 12 ) SELECT OPPORTUNITY_ID AS C1, TEXT_TYPE_ID AS C2, OPPORTUNITY_TEXT_DATA AS C3 into Temp2 FROM OPPORTUNITY_TEXT WHERE (TEXT_TYPE_ID = 13 ) SELECT TEMP1.C1, TEMP1.C2, TEMP1.C3 TEMP2.C3 AS C4 FROM temp1 INNER JOIN temp2 on temp1.OPPORTUNITY_ID = temp2.OPPORTUNITY_ID WHERE OPPORTUNITY_ID = 1 Hope this helps Rodney -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 12:10 PM To: CF-Talk Subject: SOT: SQL QUESTION SQL SERVER 2000 CFMX 6.1 I have three tables called: OPPORTUNITY, OPPORTUNITY_TEXT, TEXT_TYPE OPPORTUNITY_TEXT has two columns making the PK: TEXT_TYPE_ID and OPPORTUNITY_ID. In addition there is a column called OPPORTUNITY_TEXT_DATA which holds the actual text I am after [varchar(6000)]. What I am trying to do is pull back two specific records if they exist but as one record. Let me elaborate Currently, I can say the following: SELECT OPPORTUNITY_ID AS C1, TEXT_TYPE_ID AS C2, OPPORTUNITY_TEXT_DATA AS C3 FROM OPPORTUNITY_TEXT WHERE OPPORTUNITY_ID = 1 AND (TEXT_TYPE_ID = 12 OR TEXT_TYPE_ID = 13) Which returns two records as expected. - C1 | C2 | C3 --|---|-- 1 | 12 | A - 1 | 13 | B - What I would like to do is join on itself and alias the columns so I can get the output to be something like so that I can avoid all the conditional logic in my page that would be needed to output the correct value in the correct form field: Alias1 | Alias2 |--- A | B Does that make sense? Am I missing the boat or something here. Open for suggestions and assistance. Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Jochem with minor changes, I got the query to work. Thanks everyone for the suggections and help Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 4:21 PM To: CF-Talk Subject: Re: SQL Help Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > Getting this error msg: with USING > Server: Msg 155, Level 15, State 1, Procedure sp_ProjectStatusReport, Line > 58 > 'Proj_id' is not a recognized OPTIMIZER LOCK HINTS option. > > With this query, using MS SQL 2000 > > SELECT PROJ_NAME, OC_NAME, PROJ_ID > FROM #type_data INNER JOIN > #status_data USING(Proj_id) > WHERE #type_data LIKE '%Contr%' > and #status_data LIKE '%Engineering%' Then USING isn't supported by MS SQL Server indeed and we have to write the full join condition: SELECT T1.proj_id FROM Table T1 INNER JOIN Table T2 ON T1.proj_id = T2.proj_id INNER JOIN Table T3 ON T2.proj_id = T3.proj_id WHERE T1.Name LIKE '%Open%' AND T2.Name LIKE '%Engineering%' AND T3.Name LIKE '%Govt%' Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE MOVE
Same here. at least with CF5, from the Help : BM_1410542 Attribute BM_1410544Description BM_1410546source BM_1410548Required. The full pathname of the file to move. BM_1410550destination BM_1410552Required. The full pathname of the directory or full pathname of the file to which the file will be moved. If you do not specify the filename, a trailing slash must be included in the target when moving a file. Use the backward slash (\) on Windows; use the forward slash (/) on UNIX. BM_1410554attributes BM_1608027Optional. A comma-delimited list of file attributes to be set on the file being moved. The following file attributes are supported: * readOnly * temporary * archive * hidden * system * normal BM_1608034If attributes is not used, the file's attributes are maintained. If normal is specified with any other attributes, normal is overridden by whatever other attribute is specified. BM_1410556Individual attributes must be specified explicitly. For example, if you specify only the readOnly attribute, all other existing attributes are overwritten. -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 6:43 PM To: CF-Talk Subject: Re: CFFILE MOVE HMmmm i thought the nameconflict attribute only applied when you are donig an UPLOAD. - Original Message - From: Saturday. S. Kidd To: CF-Talk Sent: Wednesday, March 10, 2004 5:58 PM Subject: RE: CFFILE MOVE Add the parameter nameconflict="error", or instead "makeunique", "skip" or "overwrite" Eg: file="/thisdirectory/blah.jpg" destination="/thatdirectory/blah.jpg"> hth -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: 10 March 2004 23:44 To: CF-Talk Subject: CFFILE MOVE Hey guys when i use CFFILE to move a file into a directory, and a file with the same name exists in that directory, what happens? does iot overite it with the new file? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Have had some time to experment. must be doing something wrong, testing with two of the temp tables. Getting this error msg: with USING Server: Msg 155, Level 15, State 1, Procedure sp_ProjectStatusReport, Line 58 'Proj_id' is not a recognized OPTIMIZER LOCK HINTS option. With this query, using MS SQL 2000 SELECT PROJ_NAME, OC_NAME, PROJ_ID FROM #type_data INNER JOIN #status_data USING(Proj_id) WHERE #type_data LIKE '%Contr%' and #status_data LIKE '%Engineering%' Tried to do a UNION and got this error: Server: Msg 8163, Level 16, State 4, Procedure sp_ProjectStatusReport, Line 56 The text, ntext, or image data type cannot be selected as DISTINCT. with this query SELECT PROJ_NAME, OC_NAME, PROJ_ID FROM #type_data UNION SELECT PROJ_NAME, OC_NAME, PROJ_ID FROM #status_data These are the queries I'm using to creat the temp tables SELECT P.PROJ_NAME, C.OC_NAME, P.PROJ_ID into #type_data FROM MSP_PROJECTS P INNER JOIN MSP_CODE_FIELDS f ON P.PROJ_ID = f.PROJ_ID INNER JOIN MSP_OUTLINE_CODES C ON f.CODE_UID = C.CODE_UID WHERE (C.OC_FIELD_ID = 188744590) AND (C.PROJ_ID = 474) AND (C.OC_PARENT = 16 OR C.OC_PARENT = 14) AND (f.CODE_REF_UID = 0) ORDER BY P.PROJ_ID SELECT P.PROJ_NAME, C.OC_NAME, P.PROJ_ID into #status_data FROM MSP_PROJECTS P INNER JOIN MSP_CODE_FIELDS f ON P.PROJ_ID = f.PROJ_ID INNER JOIN MSP_OUTLINE_CODES C ON f.CODE_UID = C.CODE_UID WHERE (C.OC_FIELD_ID = 188744590) AND (C.PROJ_ID = 474) AND (C.OC_PARENT = 16 OR C.OC_PARENT = 14) AND (f.CODE_REF_UID = 0) ORDER BY P.PROJ_ID The two temp tables are being created, I can pull from them individualy and with other types of joins(that still have the same issues as before). The other option was to try to create the tables using varchar or nvarchar. Something like: create table #Status_data ( Proj_ID int, OC_NAME nvarchar(500), PROJ_NAME nvarchar(500)) declare type_csr cursor for SELECT P.PROJ_NAME as Proj_name, OC_NAME as OC_name, P.PROJ_ID FROM MSP_PROJECTS P INNER JOIN MSP_CODE_FIELDS f ON P.PROJ_ID = f.PROJ_ID INNER JOIN MSP_OUTLINE_CODES C ON f.CODE_UID = C.CODE_UID WHERE (C.OC_FIELD_ID = 188744590) AND (C.PROJ_ID = 474) AND (C.OC_PARENT = 16 OR C.OC_PARENT = 14) AND (f.CODE_REF_UID = 0) ORDER BY P.PROJ_ID open type_csr fetch next from type_csr into @Proj_name, @OC_Name,@proj_id while @@fetch_status = 0 begin INSERT INTO #type_data values(@Proj_id, @OC_Name, @Proj_name) fetch next from type_csr into @Proj_name, @OC_Name,@proj_id end close type_csr deallocate type_csr But SQL wont allow me to change from text to varchar/nvarchar. Cant use any string functions on text data type either. Left(PROJ_NAME, 500). Both OC_NAME and PROJ_NAME are text data type. I am doing all of this in the Query Analyzer, trying to create a stored procedure. Any ideas Thanks Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 9:03 AM To: CF-Talk Subject: RE: SQL Help Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > your suggested query below returns 0 records, becuase the field will > never contain all three at the same time in the same record. That is not the test being done. > UID Name Description Parent Proj_ID > 1 Status current status of project 0 0 > 2 Initializing Project is starting 1 100 > 3 Engineering Project in Eng phase 1 100 > 4 Type Who is doing Proj 0 0 > 5 ContrContracted out4 100 > 6 Govt Govt ran 4 100 > 7 ConditionProj open or close 0 0 > 8 Open Proj is open 7 100 > 9 closed Proj is closed7 100 > > So if you ask for name to be LIKE Init and Contr and Open, 0 records > returned > > I can get the three records by going for project ID, but have not had > a chance to run thru the suggections given by others. > Just have tried your suggections already so know what happens. WFM even with a subset of the data: jochemd=> begin; BEGIN jochemd=> create table example (uid int, name text, description text, parent int, proj_id int); CREATE TABLE jochemd=> jochemd=> insert into example values (3, 'Engineering', 'Project in Eng phase', 1, 100); INSERT 6060153 1 jochemd=> insert into example values (6, 'Govt', 'Govt ran', 4, 100); INSERT 6060154 1 jochemd=> insert into example values (8, 'Open', 'Proj is open', 7, 100); INSER
RE: SQL Help
Jochem Sorry my bad, no caffene when I look at your poste and answered, was tunnel visioned on the WHERE and totaly missed the USING part of th query. Will experment and see what I get. Thanks Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 9:03 AM To: CF-Talk Subject: RE: SQL Help Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > your suggested query below returns 0 records, becuase the field will > never contain all three at the same time in the same record. That is not the test being done. > UID Name Description Parent Proj_ID > 1 Status current status of project 0 0 > 2 Initializing Project is starting 1 100 > 3 Engineering Project in Eng phase 1 100 > 4 Type Who is doing Proj 0 0 > 5 ContrContracted out4 100 > 6 Govt Govt ran 4 100 > 7 ConditionProj open or close 0 0 > 8 Open Proj is open 7 100 > 9 closed Proj is closed7 100 > > So if you ask for name to be LIKE Init and Contr and Open, 0 records > returned > > I can get the three records by going for project ID, but have not had > a chance to run thru the suggections given by others. > Just have tried your suggections already so know what happens. WFM even with a subset of the data: jochemd=> begin; BEGIN jochemd=> create table example (uid int, name text, description text, parent int, proj_id int); CREATE TABLE jochemd=> jochemd=> insert into example values (3, 'Engineering', 'Project in Eng phase', 1, 100); INSERT 6060153 1 jochemd=> insert into example values (6, 'Govt', 'Govt ran', 4, 100); INSERT 6060154 1 jochemd=> insert into example values (8, 'Open', 'Proj is open', 7, 100); INSERT 6060155 1 jochemd=> jochemd=> SELECT jochemd-> proj_ID jochemd-> FROM jochemd-> Example T1 INNER JOIN jochemd-> Example T2 USING (proj_id) INNER JOIN jochemd-> Example T3 USING (proj_id) jochemd-> WHERE jochemd-> T1.Name LIKE '%Open%' jochemd-> AND jochemd-> T2.Name LIKE '%Engineering%' jochemd-> AND jochemd-> T3.Name LIKE '%Govt%'; proj_id - 100 (1 row) jochemd=> rollback; ROLLBACK jochemd=> Are you sure your database understands USING correctly? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Jochem your suggested query below returns 0 records, becuase the field will never contain all three at the same time in the same record. the table looks something like this: (example only ;o) UID NameDescription Parent Proj_ID 1 Status current status of project 0 0 2 Initializing Project is starting 1 100 3 Engineering Project in Eng phase 1 100 4 Type Who is doing Proj 0 0 5 Contr Contracted out 4 100 6 Govt Govt ran 4 100 7 Condition Proj open or close 0 0 8 Open Proj is open 7 100 9 closed Proj is closed 7 100 So if you ask for name to be LIKE Init and Contr and Open, 0 records returned I can get the three records by going for project ID, but have not had a chance to run thru the suggections given by others. Just have tried your suggections already so know what happens. Thanks help Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:32 AM To: CF-Talk Subject: RE: SQL Help Ian Skinner said: > My first suggestion would be an embed sub-query. That would work if you add another level for the "Govt" condition. > SELECT > fields > > FROM > Table. > ( SELECT > fields > > FROM > TABLE > > WHERE > Name LIKE "%Engineering%" > ) AS FooBar > > WHERE >FooBar.ID = Table.ID > AND Name LIKE "%Open%" > > Of course this assumes you are using a DBMS that allows sub-queries. > I understand that not all of them do. It is pretty trivial to rewrite as a self-join. I adapted thee names of the original problem: SELECT project_ID FROM Table T1 INNER JOIN Table T2 USING (project_id) INNER JOIN Table T3 USING (project_id) WHERE T1.Name LIKE '%Open%' AND T2.Name LIKE '%Engineering%' AND T3.Name LIKE '%Govt%' Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Using MS SQL 2000, and have used subqueries with it before. But think the best option so far might be the NOT LIKE suggtion by Mark. Thanks for this option also, need to play with all of them and see what I get. This DB is just sooo screwed up, that its turning my brain to mush. Thanks for all the help from everyone. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:08 AM To: CF-Talk Subject: RE: SQL Help My first suggestion would be an embed sub-query. SELECT fields FROM Table. ( SELECT fields FROM TABLE WHERE Name LIKE "%Engineering%" ) AS FooBar WHERE FooBar.ID = Table.ID AND Name LIKE "%Open%" Of course this assumes you are using a DBMS that allows sub-queries. I understand that not all of them do. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Need to play around with this for awhile and see what I get. For some reason thought I tried NOT LIKE, but dont remember now ;o\ Agreed this is not a very good way to handle this. I did not designed the DB nor can I change it. Have to work with what they gave me. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:12 AM To: CF-Talk Subject: RE: SQL Help How about: WHERE (name LIKE '%Open%' or name LIKE '%Engineering%') AND name NOT LIKE ('%closed%') Personally, this is probably not the best way to handle status. I always have a status field - either an int or a small character field and use a constraint ('open','closed','pending') and always be assured of a proper status. -Mark gets me projects that are closed as well as open -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:41 AM To: CF-Talk Subject: SQL Help Hi all I need some help with a query that supplies a report. The issue for me is one of the tables: (simplified) Table UID Name Description Parent Project_id This table contains different information in the same field (name),like the projects status (Initializing, Engineering, etc) , the type of project (Contractor, Govt), and condition (Open, Closed). So projects can have 1, 2 or 3 records in this table. The problem is if the user wants a report of all Open-Engineering-Govt projects. Name is a Text field. So I can get all the open with: WHERE name LIKE '%Open%' (needs to be LIKE because the information is not consistant, ie: Open, is Open, Opened, etc). But WHERE name LIKE '%Open%' and name LIKE '%Engineering%' gets me nothing becuase the field cant be both at same time and WHERE name LIKE '%Open%' or name LIKE '%Engineering%' gets me projects that are closed as well as open I can get the information I need by running mulitple queries: WHERE name LIKE '%Open%' WHERE name LIKE '%Engineering%' and project_ID = #first.project_id# is both opened and Engineering. But this is cumbersome. anyone know a better way? We are using: CF5 and SQL 2000. Thanks Rodney _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Jeff thanks for info and the forward -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 9:47 AM To: CF-Talk Subject: Re: SQL Help Hi Rodney, I'm not really able to help all that much, but what I suggest is trying the SQL mailing list. I replied and forwarded this to that list in an effort to get it over to "the SQL people". They're really great at this sort of stuff, and you might get a faster, better response from it. Have at it, "SQL people". - Original Message - From: "Bruce, Rodney S HQISEC/Veridian IT Services" To: "CF-Talk" <[EMAIL PROTECTED]> Subject: SQL Help > Hi all > > I need some help with a query that supplies a report. > > The issue for me is one of the tables: (simplified) > > Table > UID Name Description Parent Project_id > > > This table contains different information in the same field (name),like the > projects status (Initializing, Engineering, etc) , the type of project > (Contractor, Govt), and condition (Open, Closed). > > So projects can have 1, 2 or 3 records in this table. > > The problem is if the user wants a report of all Open-Engineering-Govt > projects. > > Name is a Text field. > > So I can get all the open with: > > WHERE name LIKE '%Open%' > (needs to be LIKE because the information is not consistant, ie: Open, is > Open, Opened, etc). > > But > > WHERE name LIKE '%Open%' and name LIKE '%Engineering%' > gets me nothing becuase the field cant be both at same time > > and > WHERE name LIKE '%Open%' or name LIKE '%Engineering%' > gets me projects that are closed as well as open > > I can get the information I need by running mulitple queries: > > > WHERE name LIKE '%Open%' > > > > > WHERE name LIKE '%Engineering%' and project_ID = > #first.project_id# > > > is both opened and Engineering. > > > > But this is cumbersome. > > anyone know a better way? > > We are using: CF5 and SQL 2000. > > Thanks > Rodney > > > > > > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Help
Hi all I need some help with a query that supplies a report. The issue for me is one of the tables: (simplified) Table UID Name Description Parent Project_id This table contains different information in the same field (name),like the projects status (Initializing, Engineering, etc) , the type of project (Contractor, Govt), and condition (Open, Closed). So projects can have 1, 2 or 3 records in this table. The problem is if the user wants a report of all Open-Engineering-Govt projects. Name is a Text field. So I can get all the open with: WHERE name LIKE '%Open%' (needs to be LIKE because the information is not consistant, ie: Open, is Open, Opened, etc). But WHERE name LIKE '%Open%' and name LIKE '%Engineering%' gets me nothing becuase the field cant be both at same time and WHERE name LIKE '%Open%' or name LIKE '%Engineering%' gets me projects that are closed as well as open I can get the information I need by running mulitple queries: WHERE name LIKE '%Open%' WHERE name LIKE '%Engineering%' and project_ID = #first.project_id# is both opened and Engineering. But this is cumbersome. anyone know a better way? We are using: CF5 and SQL 2000. Thanks Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Isdefined Issue
Thanks for reply To clarify: Your saying that a reference to an array is not a valid variable name? isdefined("QGetProjects.PROJ_NAME[#R#]") but a Structure is: because this works: isDefined("session.tdy.#controller#") guess I am just missing something, sense CF processes arrays else were fine: #MYArray[2]# and you can use arrays in other functions: DateCompare(session.tdy[controller][newrecord],form.arrdate) I know that the DateCompare is looking at the value in the array element and isdefined is looking for the element name itself. But to me this seems to be inconsistent, IF CF can tell me the value of the array element then it should be able to tell me if its been defined? Or am I way off? Thanks Rodney -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 4:11 PM To: CF-Talk Subject: RE: Isdefined Issue The string passed to isDefined must be a syntactically valid variable name, which your name is not. It's the array dereference that's causing you problems. You can use this code instead: (QGetProjects.PROJ_NAME[Records] EQ QGetProjects.PROJ_NAME[Records+1])> Cheers, barneyb > -Original Message- > From: Bruce, Rodney S HQISEC/Veridian IT Services > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 03, 2004 3:03 PM > To: CF-Talk > Subject: Isdefined Issue > > HI all > > Can't figue out why I am getting this error: > > Parameter 1 of function IsDefined which is now > "QGetProjects.PROJ_NAME[2]" > must be a syntactically valid variable name > > It is used in this if statement: > > > > (QGetProjects.PROJ_NAME[Records] EQ > QGetProjects.PROJ_NAME[Records+1])> > > If I take out the isdefined all works until I hit a record that is not > defined. > > QGetProjects is a query. > > I can: > > > #QGetProjects.Proj_Name[2]# > > > So the variable is valid. > > > I am using CF 5 > > Anyone know this issue?? > > Thanks for any help > Rodney > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Isdefined Issue
HI all Can't figue out why I am getting this error: Parameter 1 of function IsDefined which is now "QGetProjects.PROJ_NAME[2]" must be a syntactically valid variable name It is used in this if statement: (QGetProjects.PROJ_NAME[Records] EQ QGetProjects.PROJ_NAME[Records+1])> If I take out the isdefined all works until I hit a record that is not defined. QGetProjects is a query. I can: #QGetProjects.Proj_Name[2]# So the variable is valid. I am using CF 5 Anyone know this issue?? Thanks for any help Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: txt file which lines don't have the same length
added remarks, X should be good, will contain the length of the array from when its created. But Y will contain the length of the last file_array[x].Personnel array, not the length for each of them. -Original Message- From: CHALLEL Nicolas PREF54 [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:15 AM To: CF-Talk Subject: RE: txt file which lines don't have the same length Thanks for your precious help. I just don't really know how to display my datas... I tried something like that x being value of my first loop (to count records) y being value of my second loop (to count person on each row) #file_array[i].Personnel[j]# but the 4th line returns an error message to me : "that the element at position 1 in dimension 1 of object "PERSONNEL" cannot be found. That dimension of the object is empty. Please, modify the index _expression_" Should I use Struct functions to display ? -----Message d'origine- De : Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 janvier 2004 17:15 À : CF-Talk Objet : RE: txt file which lines don't have the same length This is only one way of doing it, may not be the most efficient, but should work, ---Assumes that record number is with location not person--- do same for next 4 elements-- ---sets array to hold structure for persons-- ListGetAt(TempRecord, z, ";")> ListGetAt(TempRecord, z+1, ";")> ListGetAt(TempRecord, z+2, ";")> Then you can display by looping thru the array This is really quick and off the top of my head, you may need to work with it some to get it just right for yourself. others can probley tune it up. but hope it helps point you in right direction. -Original Message- From: Nicolas CHALLEL [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 1:48 AM To: CF-Talk Subject: Re:txt file which lines don't have the same length Hello and thanks for your help. I manage to proceed with a file counting 6 fix entries for each row, separated by comma (;). But I can't proceed with variable entries... file="#expandPath('.')#\T128.TXT" variable="message"> Record Number: #i Date: #file_array[a]# Code: #file_array[b]# Lib: #file_array[c]# Value1: #file_array[d]# Value2: #file_array[e]# Value3: #file_array[f]# Name: #file_array[g]# First Name: #file_array[h]# Value: #file_array[i]# Instead of getting ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 COLLINS Jenifer 0033 ___ Record Number 3 13/01/2004 11:36 711 TOKYO 0125 0075 0102 PAUL Sean 0077 BOSTON Mickael 0114 CHRIS Helen 0072 I get ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 ___ Record Number 3 COLLINS Jenifer 0033 13/01/2004 11:36 711 TOKYO 0125 0075 0102 So it's impossible for me after that to request and try to calculate for instance the sum of value1+value2+value3 and other stuff like that... What would you suggest me to do ? May be counting the number of entries for the longer row and write blank records in shorter rows before proceeding the file ? I don't really know what to do. It would be nice if you have ideas to improve my script. Thanks a lot. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: txt file which lines don't have the same length
You will have to get the array length for each Personnel because the are different Something like: x being value of my first loop (to count records) y being value of my second loop (to count person on each row) #file_array[i].Personnel[j]# To see what the array looks like do a give you a better idea of what your working with. -Original Message- From: CHALLEL Nicolas PREF54 [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:15 AM To: CF-Talk Subject: RE: txt file which lines don't have the same length Thanks for your precious help. I just don't really know how to display my datas... I tried something like that x being value of my first loop (to count records) y being value of my second loop (to count person on each row) #file_array[i].Personnel[j]# but the 4th line returns an error message to me : "that the element at position 1 in dimension 1 of object "PERSONNEL" cannot be found. That dimension of the object is empty. Please, modify the index _expression_" Should I use Struct functions to display ? -----Message d'origine- De : Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 janvier 2004 17:15 À : CF-Talk Objet : RE: txt file which lines don't have the same length This is only one way of doing it, may not be the most efficient, but should work, ---Assumes that record number is with location not person--- do same for next 4 elements-- ---sets array to hold structure for persons-- ListGetAt(TempRecord, z, ";")> ListGetAt(TempRecord, z+1, ";")> ListGetAt(TempRecord, z+2, ";")> Then you can display by looping thru the array This is really quick and off the top of my head, you may need to work with it some to get it just right for yourself. others can probley tune it up. but hope it helps point you in right direction. -Original Message- From: Nicolas CHALLEL [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 1:48 AM To: CF-Talk Subject: Re:txt file which lines don't have the same length Hello and thanks for your help. I manage to proceed with a file counting 6 fix entries for each row, separated by comma (;). But I can't proceed with variable entries... file="#expandPath('.')#\T128.TXT" variable="message"> Record Number: #i Date: #file_array[a]# Code: #file_array[b]# Lib: #file_array[c]# Value1: #file_array[d]# Value2: #file_array[e]# Value3: #file_array[f]# Name: #file_array[g]# First Name: #file_array[h]# Value: #file_array[i]# Instead of getting ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 COLLINS Jenifer 0033 ___ Record Number 3 13/01/2004 11:36 711 TOKYO 0125 0075 0102 PAUL Sean 0077 BOSTON Mickael 0114 CHRIS Helen 0072 I get ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 ___ Record Number 3 COLLINS Jenifer 0033 13/01/2004 11:36 711 TOKYO 0125 0075 0102 So it's impossible for me after that to request and try to calculate for instance the sum of value1+value2+value3 and other stuff like that... What would you suggest me to do ? May be counting the number of entries for the longer row and write blank records in shorter rows before proceeding the file ? I don't really know what to do. It would be nice if you have ideas to improve my script. Thanks a lot. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: txt file which lines don't have the same length
This is only one way of doing it, may not be the most efficient, but should work, ---Assumes that record number is with location not person--- do same for next 4 elements-- ---sets array to hold structure for persons-- ListGetAt(TempRecord, z, ";")> ListGetAt(TempRecord, z+1, ";")> ListGetAt(TempRecord, z+2, ";")> Then you can display by looping thru the array This is really quick and off the top of my head, you may need to work with it some to get it just right for yourself. others can probley tune it up. but hope it helps point you in right direction. -Original Message- From: Nicolas CHALLEL [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 1:48 AM To: CF-Talk Subject: Re:txt file which lines don't have the same length Hello and thanks for your help. I manage to proceed with a file counting 6 fix entries for each row, separated by comma (;). But I can't proceed with variable entries... file="#expandPath('.')#\T128.TXT" variable="message"> Record Number: #i Date: #file_array[a]# Code: #file_array[b]# Lib: #file_array[c]# Value1: #file_array[d]# Value2: #file_array[e]# Value3: #file_array[f]# Name: #file_array[g]# First Name: #file_array[h]# Value: #file_array[i]# Instead of getting ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 COLLINS Jenifer 0033 ___ Record Number 3 13/01/2004 11:36 711 TOKYO 0125 0075 0102 PAUL Sean 0077 BOSTON Mickael 0114 CHRIS Helen 0072 I get ___ Record Number 1 13/01/2004 11:36 345 London 0025 0415 0012 SMITH Deborah 0085 ___ Record Number 2 13/01/2004 11:36 202 Paris 0144 0002 0711 CLIFTON Jack 0055 ___ Record Number 3 COLLINS Jenifer 0033 13/01/2004 11:36 711 TOKYO 0125 0075 0102 So it's impossible for me after that to request and try to calculate for instance the sum of value1+value2+value3 and other stuff like that... What would you suggest me to do ? May be counting the number of entries for the longer row and write blank records in shorter rows before proceeding the file ? I don't really know what to do. It would be nice if you have ideas to improve my script. Thanks a lot. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: txt file which lines don't have the same length
if the below example holds true for all lines you could: (assuming there are LF and/or CR at then end of each line). if no LF and/or CR looks like you could use the date to know when each new line starts. Grab the first 6 elements of each line(below they are consistent: date;code;lib;value1;value2;value3). Then every three elements after that until end of line will be Name;First Name;Value. using list functions to do this. drop the file in front of #File.message# scope using variables hope this helps -Original Message- From: Nicolas CHALLEL [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:14 AM To: CF-Talk Subject: txt file which lines don't have the same length Hi, How can I make a request by using a txt file which lines don't have the same length ? This txt file is generated by a compiled program that make lines of this type with ";" as delimeter. example lines... date;code;lib;value1;value2;value3;Name;First name;value; 13/01/2004 11:36;345;London;0025;0415;0012;SMITH;Deborah;0085; 13/01/2004 11:36;202;Paris;0144;0002;0711;CLIFTON;Jack;0055;COLLINS;Jen ifer;0033; 13/01/2004 11:36;711;TOKYO;0125;0075;0102;PAUL;Sean;0077;BOSTON;Mickael ;0114;CHRIS;Helen;0072; On line #2 you read Clifton and Collins attached to {13/01/2004 11:36;202;Paris;0144;0002;0711;} but on line#3 there are Paul,Boston and Chris attached to {13/01/2004 11:36;202;Paris;0144;0002;0711;} and I can't duplicate my columns' name I just can have one Name column, one Surname column and one value Column and yet, this txt files contains 2 or 3 or 4 persons for one record... I've tried to use use a loop function to place each element in an array while indicating row number, but my server CF5.0 returns this error : Error processing CFFILE Error attempting to read 'C:\Documents and Settings\myName\R54T01.txt.' and I typed this code : variable="Message"> #file.message# the option box CFFILE is properly ticked in the CF administrator settings... but I can't read anything and I need to create a requested table no matter how many people by line Can someone help me ? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: access table backup question
Select * into Newtable From Oldtable workings when ran in ACCESS 2000 -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:34 PM To: CF-Talk Subject: access table backup question Hi All, I want to backup couple of access tables every night, means just make a copy of the table. Is there any easy solution to just copy the table instead of me writing a script to grab all records and then insert to the table. I have about 10,000 records in the table with about 10 fields. Ketan Patel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Using Access front end for MS SQL
Hi all Was wondering if anyone has tried this or has information. They want to use the already built Access front end (menus/forms/reports) application. But they want to use MS SQL. I know that tables can be linked from MS SQL to Access, which gets the information to the front end application. but I don't know of anyway to run SPs from MS SQL in Access. Also would Access's size limit still apply to the linked tables? Or is there another way to use the Access front end? Any information will be helpful. Even if it's facts to help talk them out of this ;o) Thanks Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import of Text File
use to read the file into a variable. Use LEN(trim(yourvar)) to see if the file is empty. Then use the list functions to break it up into the data elements to be entered into your database. use listlen() to determine how many elements then loop thru the list using listgetat() to pull out each element and place in a var, then do an insert query to place each record in your database. You didn't mention how each record would be separated out. CR/LN or if you know that every Nth element would be the start of a new record. Hope this helps point you in the right direction. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:38 PM To: CF-Talk Subject: Import of Text File Hello All, I need to import a tab delimited text file in to an access database. I know that this is possible just don't know how to go about it. One more thing is that sometimes the file may be empty. Can someone point me in the right direction? Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL SP
Yes for MS SQL 2K its: db1..tbl Thanks for the help Rodney -Original Message- From: Smith, Matthew P -CONT(CSC) [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 10:40 AM To: CF-Talk Subject: RE: SQL SP Isn't it "..", as in SELECT tb1.id, tb2.name FROM db1..table1 tb1, db2..table2 tb2 ? -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:22 PM To: CF-Talk Subject: Re: SQL SP >Hi all > >Hope someone can help me with this: > >How can I tell a SP to query a different dbs inside of a SP? > >I need to be able to run some queries on one db and within that same SP run >queries on another db. >IS this possible? Or will I need to do two different SP one in each db and >a temp table to hold the information from the first SP to run against the >second SP. >and just do the two calls from the CF page? > I don't know what RDBMS you're using, but you should be able to scope the table name with either the database name or the schema name: myDB1.tableName, myDB2.tableName, etc. Regards, Dave. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL SP
Hi all Hope someone can help me with this: How can I tell a SP to query a different dbs inside of a SP? I need to be able to run some queries on one db and within that same SP run queries on another db. IS this possible? Or will I need to do two different SP one in each db and a temp table to hold the information from the first SP to run against the second SP. and just do the two calls from the CF page? Thanks for any help Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stripping out columns in Excel
Here is a good link to get more information about working with excel http://www.cfcomet.com/excel/ -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 1:54 PM To: CF-Talk Subject: RE: Stripping out columns in Excel Yeah Tony, I was trying to come up with a way to do it in my code rather than manually deleting the columns I don't need in Excel. I all ready went ahead and deleted the columns because it was easier but I'd still like to find a way to do it in my code. Thanks, Ben -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 4:14 PM To: CF-Talk Subject: RE: Stripping out columns in Excel besides highlighting the column in excel and deleting it? -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 3:44 PM To: CF-Talk Subject: Stripping out columns in Excel Hey everyone, I have an excel file that has about 10 columns in it but I only need 4. I converted the excel file to a csv file but now am stuck on how to get only the columns I need. Is there a good solution for doing this? Thanks, Ben ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138012 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Stripping out columns in Excel
oops ;o) cut and paste will get me everytime in previous email part of the code I sent was: objSheet = objSheets.Item("wptotals"); wptotals = Your Worksheet name. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138014 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Stripping out columns in Excel
Ben If I understand correctly you want to delete the column in the excel worksheet before you change it to a csv file. Below code does this thru a com object. Haven't played around with it much but this will delete a column from an excel worksheet. objExcel.Visible = False; objExcel.DisplayAlerts = False; objBooks = objExcel.Workbooks; objBook = objBooks.Open("C:\yourdir\yourfile.XLS"); objBook.Activate(); objSheets = objBook.Worksheets; objSheet = objSheets.Item("wptotals"); objRange = objSheet.Range("A:A"); objRange.delete(); objBook.save("C:\yourdir\yourfile.XLS"); objBooks.close(); -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 1:54 PM To: CF-Talk Subject: RE: Stripping out columns in Excel Yeah Tony, I was trying to come up with a way to do it in my code rather than manually deleting the columns I don't need in Excel. I all ready went ahead and deleted the columns because it was easier but I'd still like to find a way to do it in my code. Thanks, Ben -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 4:14 PM To: CF-Talk Subject: RE: Stripping out columns in Excel besides highlighting the column in excel and deleting it? -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 3:44 PM To: CF-Talk Subject: Stripping out columns in Excel Hey everyone, I have an excel file that has about 10 columns in it but I only need 4. I converted the excel file to a csv file but now am stuck on how to get only the columns I need. Is there a good solution for doing this? Thanks, Ben ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138011 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Help: CF5 is making access file grow to 2GB
I had a similar issue, but quite as bad, but an MS access db would grow to 2GB in about a week or less depending on the activity. I solved (if you call it that) the issue by doing an automatice compression of the db everynight. Let me know and I will email you the code off list. I got the origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137400 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: advice
That is why I did specify American Pizza ;o) and the beef is just different not better or worse just different -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:21 AM To: CF-Talk Subject: Re: advice > Would recommend it to anyone that can live on food other than American > Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137343 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: advice
Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 14:46 > To: CF-Talk > Subject: advice > > > Anyone on the list ever study/work /been overseas Trying to make a > decsion about finishing my MBA overseas and wanted to speak to someone > who has done it > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137325 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: SQL help
always seem to miss the simple stuff. removing the ' worked. Thanks for the help Rodney -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 3:10 PM To: CF-Talk Subject: SQL help Hi all We are finally tring to upgrate from Access to SQL 2000. I am working on making the necessary changes to the queries. One I am having a problem with is were the WHERE statement is: WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#) m=number for the month: m=5. work_day is the field in the db table. this works fine with Access(data type date/time), but with SQL I get the error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified for datepart when the data type is smalldatetime and if I change it to timestamp, no error but no records are returned either. This is used to create a report based on the project selected and the month. THanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL help
Hi all We are finally tring to upgrate from Access to SQL 2000. I am working on making the necessary changes to the queries. One I am having a problem with is were the WHERE statement is: WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#) m=number for the month: m=5. work_day is the field in the db table. this works fine with Access(data type date/time), but with SQL I get the error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified for datepart when the data type is smalldatetime and if I change it to timestamp, no error but no records are returned either. This is used to create a report based on the project selected and the month. THanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMail
Stephenie and Jochem Thanks both of you this is what we are looking for, Server wide is fine only one site on the server and we want controll over all the mail. Thanks again Rodney -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:49 AM To: CF-Talk Subject: RE: CFMail Yes, in the registry under HKEY_LOCAL_MACHINE --> SOFTWARE -->Allaire --> CurrentVersion --> Mail there is a key for BaseDirectory that should point to your cfusion\mail folder, you can change this, but I believe wherever you point this should have a spool dir inside of it (ie: don't point it straight to another spool dir, but to a dir with spool dir inside it). ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message----- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:40 PM To: CF-Talk Subject: RE: CFMail CF 5, win2K --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMail
CF 5, win2K -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:36 AM To: CF-Talk Subject: RE: CFMail Which version of CF? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:16 PM To: CF-Talk Subject: CFMail Hi all Is there a way when using to get CF to drop the mail into a diffrent dir then ../mail/spool? Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMail
Hi all Is there a way when using to get CF to drop the mail into a diffrent dir then ../mail/spool? Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ArrayDeleteAt for a 2d array?
sorry this will leave the array row there, but empty. works better with ArrayDeleteAt( LoginArray,ArrayRows) which will completely take that row out of the array -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:29 PM To: CF-Talk Subject: RE: ArrayDeleteAt for a 2d array? ArrayClear(LoginArray[ArrayRows] ) If I remember correctly a 2d arrray is just an array of arrays so this should work. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:50 PM To: CF-Talk Subject: ArrayDeleteAt for a 2d array? How do you loop over a *2d* array and delete a single row (and all its elements), where that row is determined by a test of the contents. Like so: I've been fighting a losing battle with this all afternoon. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ArrayDeleteAt for a 2d array?
ArrayClear(LoginArray[ArrayRows] ) If I remember correctly a 2d arrray is just an array of arrays so this should work. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:50 PM To: CF-Talk Subject: ArrayDeleteAt for a 2d array? How do you loop over a *2d* array and delete a single row (and all its elements), where that row is determined by a test of the contents. Like so: I've been fighting a losing battle with this all afternoon. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Common Access Cards
Hi all We are just starting to work with CACs. We found the below code in ASP, but so far nothing for CF. We can get this to work, but would like it in CF if possible. There seems to be three parts to the CACs: Encryption Certificate USERNAME-Identity Signature Certificate And this code only reads from the USERNAME-Identity part of the card. The email is contained in the Encryption Certificate. In ASP or CF how can we read this part? Here is the ASP Code: <%@ Language = "VBScript"%> Untitled Document FULL NAME: <%=Request.ClientCertificate("subjectCN")%> ORGANIZATIONAL UNIT: <%=Request.ClientCertificate("subjectOU")%> Thanks for any help Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: -OT- Javascript and combo boxes
oops, maybe I read your post wrong. If you are looking at setting all the selects to the same option try something like this: Don't know how you have your selects named now but if they are in order like: MySelect1 OnChange="resetlists(1)" MySelect2 OnChange="resetlists(2)" MySelect3 OnChange="resetlists(3)" ... MySelectLast because on the last one there are no more below it to change?? Function resetlists(start){ Var SelectName = "MySelect" + start; Var next = start-1; Var SelectNext = "MySelect" + next; While (next < MaxnumSelects){ control = 0; while (control< document.form.[Selectnext].options.length){ if (document.form.[Selectnext].options.[control].value == document[formname][SelectName].value){ document.dform.Workplans.options[control].selected = true; } control++; } next++; } } Something like this might work. Look it over, it's written on the cuff so , will ;o) have errors but should get you pointed in a direction, hopefully. -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:53 AM To: CF-Talk Subject: Re: -OT- Javascript and combo boxes the general rule for selecting an option in a combo box is: document.formName.selectBoxName.selectedIndex = n where n is your number (remember, the first option is 0) In your case, i'd guess you want to store the names of your 30 combo boxes in an array, and add a function for onchange into each , which loops over the array, setting eavh value appropriately (which would be this.selectedIndex...passed as an argument) :) you can contact me off-list if you need any help with it if you'd like. charlie Thane Sherrington writes: > At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: >>Howdy Thane, >> >>Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: >> >> > Is it possible to use Javascript to select a choice in a combo box? >> >> > For instance, if I have a form with people listed, and beside each, a >> combo >> > box with all the departments in the company, can I select a department in >> > the first combobox, and have the other combo boxes automatically switch to >> > that department as well? >> >>Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF >>Exchange. > > I don't think this is what I want. I've got about 30 combo boxes, all > with four or five departments. What I want to do is when I select the > first department for the first person, the following boxes change to that > department. Then if I change the department for the second person, I want > the remaining boxes to change to that. > > T > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: -OT- Javascript and combo boxes
Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. This is an example of a FS function: "> Dept2 Then on your Serverpage (just the CF template with the query code) you would have something like: Select * WHERE Dept = #ActiveServer.Department# You could have as many calls in the function as you needed to populate any number of select boxes. you can run any CF code on the server page. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: Re: -OT- Javascript and combo boxes At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: >Howdy Thane, > >Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: > > > Is it possible to use Javascript to select a choice in a combo box? > > > For instance, if I have a form with people listed, and beside each, a > combo > > box with all the departments in the company, can I select a department in > > the first combobox, and have the other combo boxes automatically switch to > > that department as well? > >Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF >Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFOBJECT
Hi I have a page that uses to invoke an excel object. It was working before, now I am getting this error. Error trying to create object specified in the tag. COM error 0x800401F3. Invalid class string The error occurred while processing an element with a general identifier of (CFOBJECT), occupying document position (17:3) to (17:81) in the template This page has been running and working find up to a month ago. Last time the reports were done. We ran it now to start working on reports again and get this error. Anyone know were to look, what to check that might have broke it. Have checked the CF service account/permissions have they haven't changed. One thing that has come to mind: does use WebDAV? I know with the latest IAVA alerts this was locked down on the web server. Thanks for any help Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: some flash fun
Simple check out the symbol on 9 that is the one that will come up, and it changes everytime. you will see that same symbol on any number you end up with. -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:32 PM To: CF-Talk Subject: OT:some flash fun http://www.cyberglass.co.uk/FlashEx/mindreader.html how they do that??? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:
Give them the same name with different values Yes No -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 1:23 PM To: CF-Talk Subject: Yes No Currently I can click on both the "yes" and "no" and they both get selected. I don't want that to happen. The user should only be able to select one. How can I do this? I also have another list of radio buttons with 5 items but only want to allow the user to select one and NOT multiples. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Very strange Application.cfm issue
Hoping someone might be able to shed some light on an issue we are having with files in a directory not processing the Application.cfm file. There is no code in the Application the file to redirect. we even just made it display "application for this dir". But some files fill not process it and will skip to the next level up and process that Application.cfm file. Even stranger. A simple test.cfm file only has "test 1". Will skip up a level. rename the file to test1112.cfm (just a random number), it will work. change the name back to test.cfm and again jumps to next level up. change it back to test112.cfm and processes correct application.cfm. Have copied files from other directories that work fine into this dir and all will skip the application.cfm until the names are changed. and when the names are changed back to original. They again skip up a level. If files are copied or moved into other dir, they work fine (process the correct application.cfm). We have copied other application.cfms into the dir with the same results. We are total confused and wondering if anyone has seen or heard of this anywhere else. We've worked around the problem, simply by creating a new dir and moving everything there. But was hoping to get some answers. Running: CF5 WIN2K Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic Insert/Update - Still not working
Ignore my last msg, miss read this one -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:39 AM To: CF-Talk Subject: RE: Dynamic Insert/Update - Still not working Have you tried a bit of logic like: checked> Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Dynamic Insert/Update - Still not working
Have you tried: checked> or checked> -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:39 AM To: CF-Talk Subject: RE: Dynamic Insert/Update - Still not working Have you tried a bit of logic like: checked> Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: political leanings test
on the same side ;o) My ratings: Economic Left/Right: -5.62 Authoritarian/Libertarian: -2.51 Right about were Gandhi is. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:31 PM To: CF-Talk Subject: political leanings test http://www.politicalcompass.org/ One of those political spectrum detection tests. Good for a nice heated debate on the list. :) My ratings: Economic Left/Right: -3.25 Authoritarian/Libertarian: -2.56 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Javascript List?
not as good ;o) but good [EMAIL PROTECTED] http://groups.yahoo.com/group/JS-Jive -Original Message- From: Greg McDaniel [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 10:29 AM To: CF-Talk Subject: OT: Javascript List? Could someone please recommend a Javascript List that is at least as good as CF-Talk? Greg M. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: numbers only
Thanks That worked. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 10:23 AM To: CF-Talk Subject: Re: numbers only Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > I am trying to remove commas from numbers being inputted by user like 3,333 > changed to . > > This works: > tempstring = tempstring.replace(/[^0-9]/g,""); > > but it removes periods 3.33, which I want to keep. > so I tried: > tempstring = tempstring.replace(/^\.[^0-9]/g,""); tempstring = tempstring.replace(/[^0-9\.]/g,""); Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
numbers only
Hi all I am trying to remove commas from numbers being inputted by user like 3,333 changed to . This works: tempstring = tempstring.replace(/[^0-9]/g,""); but it removes periods 3.33, which I want to keep. so I tried: tempstring = tempstring.replace(/^\.[^0-9]/g,""); but this doesn't seem to remove anything. Help, what am I missing? TIA Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excel 'Lookup' Function
you can look here and see if its any help http://www.cfcomet.com/excel/ -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 1:17 PM To: CF-Talk Subject: Excel 'Lookup' Function I'm really stumped here. Can anybody tell me how to turn this Excel formula into CF friendly code? =LOOKUP(B58,$A47:$A52,B47:B52)+(B57/100)*(B167-LOOKUP(B57,$A39:$A45,B39: B45)) I'd be forever in your debt!! :) Thanks! -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Excel 'Lookup' Function
Guess that would all depend on what you are trying to do? are you trying to read from a spreadsheet into a CF page? Do you have these numbers in a query output and just need to reproduce the formula in your CF page? Could use a little more detail ;o) -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 1:17 PM To: CF-Talk Subject: Excel 'Lookup' Function I'm really stumped here. Can anybody tell me how to turn this Excel formula into CF friendly code? =LOOKUP(B58,$A47:$A52,B47:B52)+(B57/100)*(B167-LOOKUP(B57,$A39:$A45,B39: B45)) I'd be forever in your debt!! :) Thanks! -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using MS Access Queries as SP
Is everyone stumped?? -Original Message- From: "Bruce>,Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED] [mailto:"Bruce>,Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 11:45 AM To: CF-Talk Subject: Using MS Access Queries as SP Hi everybody I am trying to use queries in access(2K) as SP. I can get all to work but dates. If I hard code dates in the query like: #1/15/2003# the correct records are returned. Just can't get it to work with: This doesn't error, but also doesn't return any records. I have tried placing the #s around the var in the query, but Access doesn't like that. I have tried which gets me the error: Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) I have tried: which sends the date as: #1/15/2003# to the query, again no error, but no records. The format of the date field is Short Date mm/dd/. Using: CF5 WIN2K Access 2K Any help would be appreciated. TIA Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CFOBJECT to Excel
Thanks that seems to have done it. Still confusing that it was working and then stopped, O well Thanks again -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 10:02 PM To: CF-Talk Subject: RE: CFOBJECT to Excel Bruce check this link out: http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE305C2 D66A7025#22 Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 11:51 AM To: CF-Talk Subject: CFOBJECT to Excel Hello all Hope someone can help with a problem I am having calling excel. This code was working. I ran it a number of times. I then made changes to the page. Nothing to change the call, I just added a few lines to display information from another query. even undid all the changes and it still doesn't' work. Here's the code that generates the error: 1. 2. 3. 4. 5. 6. 7. The ERROR: Error trying to create object specified in the tag. COM error 0x5. Access is denied. The error occurred while processing an element with a general of (CFOBJECT), occupying document position (5:3) to (5:81) in the template file What's frustrating is that it was just working, errr. TIA Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFOBJECT to Excel
Hello all Hope someone can help with a problem I am having calling excel. This code was working. I ran it a number of times. I then made changes to the page. Nothing to change the call, I just added a few lines to display information from another query. even undid all the changes and it still doesn't' work. Here's the code that generates the error: 1. 2. 3. 4. 5. 6. 7. The ERROR: Error trying to create object specified in the tag. COM error 0x5. Access is denied. The error occurred while processing an element with a general of (CFOBJECT), occupying document position (5:3) to (5:81) in the template file What's frustrating is that it was just working, errr. TIA Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ODBC Data Source [Merant dBase/FoxPro Driver]
hi all Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro Driver] in CF admin? I haven't used it before and cant seem to find any examples. I have tried the simple queries: SELECT STATION, ORG_ELMT FROM t16101; DELETE t16101.* FROM t16101; for the select I get: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag for the delete I get the error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC dBase driver]Missing FROM keyword in DELETE statement SQL = "Delete t16101.* FROM t16101;" I can verify the connection in CF Admin and it says its OK any examples would be a great help Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: need tag for dropdown and input
This is something I have used, with a little JS to reset the or input box just doing a quick type, so sorry for any typos. Select option #text# Then on the action page check if myfileld1 EQ "" or not. or check for the value of the myfield2 EQ "none" or not. hope this is close to what you are looking for. -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:33 AM To: CF-Talk Subject: Re: need tag for dropdown and input Valerie L. Criswell writes: > I know I've seen it somewhere on my journeys. > > It's the tag that displays both a dropdown (populated from a query) as well > as an accompanying text input so that the if the needed value isn't listed > in the dropdown, the user can enter it into the text box. But only one > variable for the value is sent. > > Anyone know where I can pick this up? > > I'm not sure what to search for on the DevX. I sure wish they would make a > more powerful and relevant search tool. Not really something that i would expect to find in the DevX, regardless of how powerful the search tool is. Just do a normal , as well as a text input as you described. On the form's action page, just run a condition to see if the text input is blank. If it is, use the value from the . If not, use the text input value. Some js on the form to prevent both a select value and a text input value would be nice too. If you need that, lemme know and i'll throw something together. charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF Service Starting/Stopping
Its full of these warnings: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\data\anyfile.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\Custom Tags\functions\anyfile.cfm'. I changed the file name to anyfile, because this is happening for many files. There are .cfm files with same names in different directories under \CustomTags. but many are also like this one were its referencing only one file: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\tags\form_fieldFocus.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\TAGS\form_fieldFocus.cfm'. and I have check there is only one form_fieldFocus.cfm file. Is CF Admin case sensitive, I did notice that in all cases were the files are then same, the directory listed is in different cases? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:31 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Rodney, can you look at what is in the Application log? 232 and 109 errors can indicate slow responses to the browser. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:05 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF Service Starting/Stopping
sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF Service Starting/Stopping
Mike Thanks for the reply Unfortunately cant get the server.log open the file is 1.2GB in size. Got to the Application.log open(it was only 123mg), See errors of form fields missing/misspelled etc. (which were known and corrected) and many of the following "warnings" "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\ourtags\index.cfm'." not all for same file. So for more questions: I don't see how missing form fields, could cause a restart. What does the above warning mean? Is there anyway in CF admin to limit the size of the log file, so we don't have the issue of a large file again? Is there a way of opening the server.log (without buying a program), MSWord is limited to 25mbs? Thanks Rodney -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:42 AM To: CF-Talk Subject: RE: CF Service Starting/Stopping Rodney, take a look in the ColdFusion error logs, in particular Application and Server logs. If you go into ColdFusion Administrator then Tools-Log Files you can view the logs there. If you need further guidance please give us some examples of any error messages in there, particularly in the Application log file. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:20 AM To: CF-Talk Subject: CF Service Starting/Stopping Hello all Sorry I know it is probably in the archives, but my search logic is not working. We are having an issue with the ColdFusion Service Stopping and Starting. But the messages in the event logs don't give details, just say that the service has been stopped/Started. What should we be looking for on this issue? We are running: CF 5 WIN2K IIS5 Thanks for any insight Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CF Service Starting/Stopping
Hello all Sorry I know it is probably in the archives, but my search logic is not working. We are having an issue with the ColdFusion Service Stopping and Starting. But the messages in the event logs don't give details, just say that the service has been stopped/Started. What should we be looking for on this issue? We are running: CF 5 WIN2K IIS5 Thanks for any insight Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Database design question
Janine one question: would the goals be the same for all the students? I would go with 3 tables 1. Student info 2. Goal info 3. link table with fk from student/goal tables and comments(grades) something like Table1 Studentid StudentName Table2 Goalid GoalName Table3 Studentid goalid period(date) Comments(grades) just my .02 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 1:59 PM To: CF-Talk Subject: OT: Database design question hmmm- I am very into keepting my database relational, but am wondering what the best route for thi particular issue is... Heres' the scoop 1. One student can be working on many goals so I have 1 one to many relationships. 2. Each goal needs graded every marking period (up to 6 times a year)- these are not traditioanl grades but a long comments piece) So goals have a one to many relationship with the grades. I'm thinking the best way to handle it is to break it into 3 tables table one student info table 2 all the goals for the students hooked to students with the studentid table 3 all the grades for the goals hooked to goals by goalID My other option is to have 2 tables table one student info table two goals + 6 grading periods comment sections Thanks in advance for any input. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Creating table in MS Access
Hello all I am trying to create a table on the fly in Access I have: CREATE TABLE #newname# ( res_name text, proj_name text, HOURS number, TASK_NAME text, WORK_DAY datetime) Which works, but I need the number field to be decimal, currently it defaults to double and rounds the numbers off. I have tried: CREATE TABLE #newname# ( res_name text, proj_name text, HOURS decimal, TASK_NAME text, WORK_DAY datetime) but it doesn't work Thanks for any help Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Stored proc help
Thanks That seems to have done it -Original Message- From: Andy Ewings [mailto:andy.e@;thoughtbubble.net] Sent: Friday, November 08, 2002 3:19 AM To: CF-Talk Subject: RE: Stored proc help Stick this code at the top of your SP: SET DATEFORMAT DMY -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] Sent: 07 November 2002 19:29 To: CF-Talk Subject: RE: Stored proc help Sent it once but here it is again. It has the recommended changes and runs without errors but returns nothing? the username has full privileges to the db. and I have gone into the tables and verified that there are records with a start date after the one entered. and if the storedproc is run from the SQL server it returns records? -Original Message- From: Bryan Stevenson [mailto:bryan@;electricedgesystems.com] Sent: Thursday, November 07, 2002 11:29 AM To: CF-Talk Subject: Re: Stored proc help How about we get to see some code instead of playing 20 questions ;-) 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: "Bruce, Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 9:49 AM Subject: RE: Stored proc help > No params are dates > > -Original Message- > From: Andy Ewings [mailto:andy.e@;thoughtbubble.net] > Sent: Thursday, November 07, 2002 10:26 AM > To: CF-Talk > Subject: RE: Stored proc help > > > Is one of your parameters type "text" or "ntext"? > > -Original Message- > From: Weaver, Anthony [mailto:AWeaver@;Limitedbrands.com] > Sent: 07 November 2002 17:07 > To: CF-Talk > Subject: RE: Stored proc help > > > make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use > CreateODBCDateTime(your date). i get this often on date formats > > -Original Message- > From: Bruce, Rodney S HQISEC/Veridian IT Services > [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] > Sent: Thursday, November 07, 2002 12:04 PM > To: CF-Talk > Subject: Stored proc help > > > Hello all > > > I am trying to call a storedproc from an SQL 7 db. > > and I get this error. Does anyone know what it means. > > > ODBC Error Code = S1C00 (Driver not capable) > > [Microsoft][ODBC SQL Server Driver]Optional feature not implemented > > > > I have tested the connection through CF admin and it tests ok. > If I leave out a param. I get the error the param is missing. > > SO I think the connection to the db if ok. > > Thanks > Rodney > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Stored proc help
Sent it once but here it is again. It has the recommended changes and runs without errors but returns nothing? the username has full privileges to the db. and I have gone into the tables and verified that there are records with a start date after the one entered. and if the storedproc is run from the SQL server it returns records? -Original Message- From: Bryan Stevenson [mailto:bryan@;electricedgesystems.com] Sent: Thursday, November 07, 2002 11:29 AM To: CF-Talk Subject: Re: Stored proc help How about we get to see some code instead of playing 20 questions ;-) 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: "Bruce, Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 9:49 AM Subject: RE: Stored proc help > No params are dates > > -Original Message- > From: Andy Ewings [mailto:andy.e@;thoughtbubble.net] > Sent: Thursday, November 07, 2002 10:26 AM > To: CF-Talk > Subject: RE: Stored proc help > > > Is one of your parameters type "text" or "ntext"? > > -Original Message- > From: Weaver, Anthony [mailto:AWeaver@;Limitedbrands.com] > Sent: 07 November 2002 17:07 > To: CF-Talk > Subject: RE: Stored proc help > > > make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use > CreateODBCDateTime(your date). i get this often on date formats > > -Original Message- > From: Bruce, Rodney S HQISEC/Veridian IT Services > [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] > Sent: Thursday, November 07, 2002 12:04 PM > To: CF-Talk > Subject: Stored proc help > > > Hello all > > > I am trying to call a storedproc from an SQL 7 db. > > and I get this error. Does anyone know what it means. > > > ODBC Error Code = S1C00 (Driver not capable) > > [Microsoft][ODBC SQL Server Driver]Optional feature not implemented > > > > I have tested the connection through CF admin and it tests ok. > If I leave out a param. I get the error the param is missing. > > SO I think the connection to the db if ok. > > Thanks > Rodney > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm