RE: Bulk restoring databases
You could script it... From tsql help: This example restores a full database and transaction log and moves the restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory. RESTORE DATABASE MyNwind FROM MyNwind_1 WITH NORECOVERY, MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf', MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf' RESTORE LOG MyNwind FROM MyNwindLog1 WITH RECOVERY Restore an entire database: RESTORE DATABASE { database_name | @database_name_var } [ FROM backup_device [ ,...n ] ] [ WITH [ RESTRICTED_USER ] [ [ , ] FILE = { file_number | @file_number } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] [ ,...n ] [ [ , ] KEEP_REPLICATION ] [ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] REPLACE ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ] Ian -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 05:11 To: CF-Talk Subject: Bulk restoring databases Hi all, Anybody know how to bulk restore MSSQL 7 databases, i.e. if you have 40 backups how you'd restore them all on the same SQL box? Bulk backup capability would also be nice if you know how... David __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Mail and SMTP Auth
Jim McAtee wrote: Can CF Server be configured to use SMTP authorization to relay mail through a remote server that requires SMTP Auth? No. But after a glance through RFC 2554 it looks feasible to make sure that the MTA accepts authentication of the From:email AUTH=password type and just append a password to the from address. But I think there is quite some testing to do there. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ORDER BY in a query of queryies (built with QueryNew)
cfoutput query=getorders cfinclude template=cart_items.cfm cfloop query=cartquery cfset NewRow = QueryAddRow(products) cfset Temp = QuerySetCell(products, qty, #cartquery.qty#) cfset Temp = QuerySetCell(products, owner, #cartquery.owner#) cfset Temp = QuerySetCell(products, code, #cartquery.qty#) cfset Temp = QuerySetCell(products, description, #cartquery.desc# cfset Temp = QuerySetCell(products, price, #cartquery.price#) /cfloop /cfoutput cfoutput query=products cfquery name=final dbtype=query select SUM(qty) AS quantity, owner, description, price from products group by owner, description, price order by qty desc /cfquery cfoutput query=final group=owner (#quantity#) | #owner# | #description#hr /cfoutput a couple of things with QoQ's, one: you must select the value to order by with it, two: your query above try order by sum(qty) or order by quantity three: sigh, QoQ's have problems sorting by fields values that are created by querysetcell I have found z __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query angst!
Help! I've got three tables - resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date My output for each event has to show: All resource names, and the total number of each resource booked on that date So far the closest I've got is cfquery name=GetRecord datasource=#variables.database# SELECT DISTINCT SUM(Resource_Allocation.Resource_Id)AS Booked,Resources.Total_Available, Resources.Description, Events.Event_Date FROM Events,Resources,Resource_Allocation WHERE Resource_Allocation.Resource_Id = Resources.Resource_Id ANDResource_Allocation.Event_Id = Events.Event_Id ANDEvents.Event_Date = #variables.EventDate# GROUP BY Resources.Description, Resources.Total_Available,Events.Event_Date /cfquery But this only shows the resources booked for that day, not the whole list of resources I'm grateful if anyone can help Crispin Ryan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error
We received the following error from CF 5.0 this morning: Error Occurred While Processing Request Error Diagnostic Information An error has occurred while processing the expression: webroot=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode122333 5654321 The reason for the error is unknown. The error occurred while processing an element with a general identifier of (CFPARAM), occupying document position (7:1) to (7:40). Date/Time: 02/27/2002 06:56:43 AM Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT; SSA IWS/LAN; 501SP1/BB; 501SP1/IWSLAN-R) Remote Address: 10.31.64.38 This error seems to point to the first cfparam in the following code in our application.cfm file: !--- Must use this file with folder emis --- !--- Rename to application.cfm when using --- !--- Rename to application_emis.cfm when not using --- cfapplication name=emis cfparam name=webroot default=/emis cfparam name=includesDir default=/emis/includes cfparam name=imagesDir default=/emis/images cfparam name=menusDir default=/emis/menus cfparam name=templatesDir default=/emis/templates cfparam name=smapDir default=/emis/smap We stopped and restarted the CF Application Service and that got us back in business. Has anyone else seen this error? Did you determine what caused it and how to fix it? We just upgraded to CF 5.0 last week. Before that the application ran without incident on CF 4.5.1 from last November. Our initial investigation suggests that we should wrap a cflock around the six cfparam tags in our application.cfm file shown above. Does this make sense? Or should we wrap a cflock around each cfparam? These cfparam statements are setting up paths that allow us to cfinclude header and footer files throughout our site. If we use the cflock tag should we use the read only type attribute? Thanks! George [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
'Edit with CF Studio' with right-click in Windows Explorer
After upgrading to Studio 5.0 I lost the 'Edit with CF Studio' option when I right-click on a cfm or html file in Windows Explorer. How can I get this back or is this a new feature of Studio 5.0? Thanks! George __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error
We received the following error from CF 5.0 this morning: Error Occurred While Processing Request Error Diagnostic Information An error has occurred while processing the expression: webroot=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode122333 5654321 The reason for the error is unknown. The error occurred while processing an element with a general identifier of (CFPARAM), occupying document position (7:1) to (7:40). Date/Time: 02/27/2002 06:56:43 AM Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT; SSA IWS/LAN; 501SP1/BB; 501SP1/IWSLAN-R) Remote Address: 10.31.64.38 This error seems to point to the first cfparam in the following code in our application.cfm file: !--- Must use this file with folder emis --- !--- Rename to application.cfm when using --- !--- Rename to application_emis.cfm when not using --- cfapplication name=emis cfparam name=webroot default=/emis cfparam name=includesDir default=/emis/includes cfparam name=imagesDir default=/emis/images cfparam name=menusDir default=/emis/menus cfparam name=templatesDir default=/emis/templates cfparam name=smapDir default=/emis/smap We stopped and restarted the CF Application Service and that got us back in business. Has anyone else seen this error? Did you determine what caused it and how to fix it? We just upgraded to CF 5.0 last week. Before that the application ran without incident on CF 4.5.1 from last November. Our initial investigation suggests that we should wrap a cflock around the six cfparam tags in our application.cfm file shown above. Does this make sense? Or should we wrap a cflock around each cfparam? These cfparam statements are setting up paths that allow us to cfinclude header and footer files throughout our site. If we use the cflock tag should we use the read only type attribute? I have seen this error message on two frequent occasions when people have presented it. The two possibilities are: 1. You use session variables or client variables without enabling them if your CFAPPLICATION tag. Seeing as your error is with a CFPARAM, this is not likely, though I do notice that you do not enable either of those two scopes in your CFAPPLICATION tag. 2. You are using a CF reserved word. Looking at the line that's throwing the error, I think that webroot is a reserved word. Try changing the variable name and see what that does for you. Also, I assume that the directory references you make are virtual mappings in CF Administrator? You can't refer to a directory that is not virtually mapped by typing /emis ... you would have to type ./emis or whatever the relative path is to that directory. Hope this helps, Dave. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: too much cookie?
depends on how much else you're sending back and forth but more than li kely not. (speaking AS a dialup user :) ) [EMAIL PROTECTED] on 02/26/2002 05:52:48 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: too much cookie? I'm wondering if using a cookie back and forth extensivly cause any bottleneck between user server. will a 1-3Kb byte of cookie information is noticeable to a dialup user? Any1? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPOP and html stripping
You can grab the HTML part of the multi-part message from your attachments directory that you specify with the AttachmentsPath attribute of cfpop. CF saves your HTML part of the message with a unique filename, without a file extension. So you'll have to parse out the real attachments first, and then what you're left with should be your html message. Loads of fun! Tyler email | [EMAIL PROTECTED] - Original Message - From: Pete Freitag [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 8:43 PM Subject: RE: CFPOP and html stripping If the message is a multi-part message (contains both HTML and Plain Text) then CFPOP will show just the plain text part. Most email clients will send what you may think are just HTML messages in multi-part format (Outlook, etc) because if a user is using a mail client that does not support HTML but is multipart aware (like Pine for instance) it will only show the user the plain text part. If you see something like this in a message header Content-Type: multipart/alternative; then you are dealing with multi-part messages As far as I know there is no way to get the html part of the message with CFPOP. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:36 PM To: CF-Talk Subject: RE: CFPOP and html stripping No I mean CFPOP - he wants to retrieve the body of a message, store it, then use it in a mass mail application. The body he retrieves has the html stripped out of it. Perhaps it's the senders client eh? Mk -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 3:17 PM To: CF-Talk Subject: RE: CFPOP and html stripping Do you mean CFMAIL? CFPOP just retrieves and deletes message from a server. If he's forwarding an email he must be using CFMAIL. If he doesn't put CFMAIL type=HTML Then it will default to sending plain text. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 3:07 PM To: CF-Talk Subject: CFPOP and html stripping Folks, Can anyone verify that CFPOP on 4.5 strips out all html tags in the body of a message? I have a friend who's trying to let an editor email a mass mail message to his CF server - which then forwards it to the appropriate groups. But the email message is supposed to be html, and it appears that CFPOP gets rid of all the HTML. Mark __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Non-Wrapping strings in IE5
This is pretty odd. I noticed that strings of certain characters just won't warp in IE5. ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! -- Put this in a fixed width table. It won't wrap when it's supposed to. test test test test test test test test test test test test test test test test test test -- This, on the other hand, will. To clarify, the first string does have spaces between the exclamation points. I ran this script to test this behavior. cfloop from=1 to=255 index=i table border=1 width=250 tr tdcfloop from=1 to=100 index=jcfoutput#chr(i)#/cfoutput /cfloop/td /tr /table /cfloop There are about 5-6 characters that just won't wrap in IE5. I haven't tried IE6 yet. Netscape 4 and 6 works just fine. Anybody else encounter this or know if it's fixed in future versions on IE? Eric Carlisle Web Site Developer Progress Energy IT Systems Delivery E-mail: [EMAIL PROTECTED] Phone: (919) 546-4739 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFREPORT :: (CRPE32.DLL) could not be located
ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Please verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Version = The error occurred while processing an element with a general identifier of __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFREPORT :: (CRPE32.DLL) could not be located
I'm pretty sure you need Crystal installed to produce the report. I know that it WASN'T included with 4.5 and isn't in 5. If it's running non-locally you might be able to set the full path to the Crystal server or you could call it directly http://./myreport.rpt;. If called directly it will probably default to using an ActiveX control to display. Much nicer than the html that CFREPORT puts up. I'm working on modifying a custom tag that displays as ActiveX or DHTML and also hides the db username and password like CFREPORT does. I'll post it when I know it works. Duncan Hays -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:34 AM To: CF-Talk Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Please verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Version= The error occurred while processing an element with a general identifier of __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFREPORT :: (CRPE32.DLL) could not be located
i thought there was a scaled down version on cf server 4.5 ent we have reports around here some where but i thought 5 would have it built in! ok... can i install it from 4.5? -paul -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:41 AM To: CF-Talk Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located Don't you have to have Crystal Reports Software ($1,500 plus) installed on your server for CFREPORT to work? J -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 14:34 To: CF-Talk Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Please verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Version = The error occurred while processing an element with a general identifier of __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access - MS SQL script?
Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- Thanks, Lou Klepner __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFREPORT :: (CRPE32.DLL) could not be located
I don't think CF4.5 has anything other than the tag. We got a demo of Crystal Reports 8.0 which let you install the web reporting functionality on the web server. Then we ended up buying Crystal Enterprise 8.0 and CR 8.5. Enterprise 8.0 is a whole app to administer your reports which we don't even use. We just want to produce them from the server. It's a lot more complicated to set up just to use. Duncan Hays -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:47 AM To: CF-Talk Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located i thought there was a scaled down version on cf server 4.5 ent we have reports around here some where but i thought 5 would have it built in! ok... can i install it from 4.5? -paul -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:41 AM To: CF-Talk Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located Don't you have to have Crystal Reports Software ($1,500 plus) installed on your server for CFREPORT to work? J -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 14:34 To: CF-Talk Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Please verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Version= The error occurred while processing an element with a general identifier of __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access - MS SQL script?
Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and then click on Import under the sub-menu. Follow the instructions in the DTS Import Wizard and you're away. ;o) Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access - MS SQL script?
Just make sure that your data is imported properly, particularly where autonumbers must become identity fields. It can also cause duplicating d ata every once in a while. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:06 AM To: CF-Talk Subject: Re: Access - MS SQL script? Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops thro ugh the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and the n click on Import under the sub-menu. Follow the instructions in the DTS Import Wizard and you're away. ;o) Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access - MS SQL script?
Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger. Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck in a situation where I will need to script the SQL tables manually? Thanks again! Lou -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen Moretti Sent: Wednesday, February 27, 2002 10:06 AM To: CF-Talk Subject: Re: Access - MS SQL script? Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Acc ess Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and then click on Import under the sub-menu. Follow the instructions in the D TS Import Wizard and you're away. ;o) Regards Stephen _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access - MS SQL script?
use the upsizing wizard in Access after you grt username and pass from the person in charge of sql server. -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 15:44 To: CF-Talk Subject: RE: Access - MS SQL script? Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger. Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck in a situation where I will need to script the SQL tables manually? Thanks again! Lou -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen Moretti Sent: Wednesday, February 27, 2002 10:06 AM To: CF-Talk Subject: Re: Access - MS SQL script? Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Acc ess Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and then click on Import under the sub-menu. Follow the instructions in the D TS Import Wizard and you're away. ;o) Regards Stephen _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Template running more than once?
It is an action page for a form, but the submit button is NOT being double-clicked. I guess I can add this code to see if the browser somehow thinks a double click is being done, but I don't think that is the issue. Thanks though. Shawn Grover -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 5:21 PM To: CF-Talk Subject: RE: Template running more than once? Is is an action page off a form? Browsers will allow a double click on the submit form to process the action page twice To keep people from clicking the submit button twice use this: INPUT TYPE=Button NAME=Submit VALUE=Start Activity onClick=if(this.value == 'Start Activity') this.form.submit(); this.value='Please Wait.'; At 05:00 PM 2/26/2002 -0700, you wrote: Thanks. We looked into the dynamic image tags and this doesn't seem to be the problem in our case. Anyone have any other ideas/suggestions? Shawn Grover -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 5:00 PM To: CF-Talk Subject: RE: Template running more than once? We have a case where it appears our template is running twice - but only intermittently. I had a similar problem and it was, thankfully, tracked down to an error in a dynamic img tag. Disable images in your browser and see if it still loads the tempalte twice. If it doesn't then try looking in any dynamic image or anchor tags for improperly closed tags. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT JS again
sorry for all the js stuff today. have a function to write a select box of states. is it faster, in general, to write text to a page with a function or return a string and write the string? Thanksabunch, Savan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form field values on post
I'm trying to post a form and then, on the page I'm posting to, loop through all the form fields and get the values. I've been shown form.formfields and that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have to but JS is slow on NT. Thanks Duncan Hays __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form field values on post
on the action page... cfloop list=#form.fieldnames# index=fieldname cfset thisvariablename = Form. #fieldname# cfoutput#fieldname# = #evaluate(#thisvariablename#)/cfoutput /cfloop -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 8:18 AM To: CF-Talk Subject: Form field values on post I'm trying to post a form and then, on the page I'm posting to, loop thro ugh all the form fields and get the values. I've been shown form.formfields a nd that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have to but JS is slow on N T. Thanks Duncan Hays __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form field values on post
Thank you Thank you Thank you -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:28 AM To: CF-Talk Subject: RE: Form field values on post on the action page... cfloop list=#form.fieldnames# index=fieldname cfset thisvariablename = Form. #fieldname# cfoutput#fieldname# = #evaluate(#thisvariablename#)/cfoutput /cfloop -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 8:18 AM To: CF-Talk Subject: Form field values on post I'm trying to post a form and then, on the page I'm posting to, loop thro ugh all the form fields and get the values. I've been shown form.formfields a nd that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have to but JS is slow on N T. Thanks Duncan Hays __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form field values on post
Whoops! on the action page... cfloop list=#form.fieldnames# index=fieldname cfset thisvariablename = Form. #fieldname# cfset myvalue = evaluate(#thisvariablename#) cfoutput#fieldname# = #myvalue#/cfoutput /cfloop -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 8:18 AM To: CF-Talk Subject: Form field values on post I'm trying to post a form and then, on the page I'm posting to, loop thro ugh all the form fields and get the values. I've been shown form.formfields a nd that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have to but JS is slow on N T. Thanks Duncan Hays __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form field values on post
I'm trying to post a form and then, on the page I'm posting to, loop through all the form fields and get the values. I've been shown form.formfields and that great for the names but how to I get the values out. I can't come up with the syntax. form.yourformvariable or if you're looping through the form.fieldnames, cfloop list=#form.fieldnames# index=fieldname cfoutputform.#fieldname# = #form[fieldname]#/cfoutput /cfloop should do the trick. *I'll use JavaScript prior to the submit if I have to but JS is slow on NT. Not sure what you mean by this, but you realise that JS is client side and not server side? Regards Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFREPORT :: (CRPE32.DLL) could not be located
do i need a full version on the server to run cfreport? http://store.crystaldecisions.net/dr/v2/ec_MAIN.Entry16?SP=10024PN=29xid=1 5248V1=30010453V2=30010453V3=1V5=11028983V4=10S1=S2=S3=S4=S5=DSP= 0CUR=840PGRP=0CACHE_ID=36273 what version!?? thank you -paul __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form field values on post
javascript is slow on NT? Are you sure about this? On Wed, 27 Feb 2002, Hays, Duncan wrote: I'm trying to post a form and then, on the page I'm posting to, loop thro ugh all the form fields and get the values. I've been shown form.formfields a nd that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have to but JS is slow on N T. Thanks Duncan Hays __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem w/ CFFILE...
I haven't run across this error before. On my form I have this: td valign=bottom align=rightfont size=2bLogo:/b/font/td td valign=bottominput type=file name=LogoFileName value= size=30 maxlength=64/td Which allows for me to upload a file. I basically click Browse and find the image. The action page has: CFIF Trim(LogoFileName) NEQ cffile action=UPLOAD filefield=Form.LogoFileName destination=#UploadDirectory# nameconflict=MAKEUNIQUE CFSET LogoFileName=ServerFile /CFIF Well I am getting an error on that that says: Message Error in CFFILE tag Type UNKNOWN Detail The form field specified in the CFFILE tag (LogoFileName) does not contain an uploaded file. Please be sure that you have specified the correct form field name. Yet I am choosing a file on the form page. Any idea what would be causing this NOT to work? I have never see this problem before. -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Template running more than once?
I have never been able to get IE for Windows to submit two pages on a double click, but Netscape for Linux, and Irix will allow a double submit. I can replicate the double submit consistently on Linux, and Irix. My action page was not suppose to run if it had already run (based on looking at a database table to stop the running), but when the page is submitted twice at the exact same time the action page would run twice. Since adding that java code i have not had any more problems. At 08:57 AM 2/27/2002 -0700, you wrote: It is an action page for a form, but the submit button is NOT being double-clicked. I guess I can add this code to see if the browser somehow thinks a double click is being done, but I don't think that is the issue. Thanks though. Shawn Grover -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 5:21 PM To: CF-Talk Subject: RE: Template running more than once? Is is an action page off a form? Browsers will allow a double click on the submit form to process the action page twice To keep people from clicking the submit button twice use this: INPUT TYPE=Button NAME=Submit VALUE=Start Activity onClick=if(this.value == 'Start Activity') this.form.submit(); this.value='Please Wait.'; At 05:00 PM 2/26/2002 -0700, you wrote: Thanks. We looked into the dynamic image tags and this doesn't seem to be the problem in our case. Anyone have any other ideas/suggestions? Shawn Grover -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 5:00 PM To: CF-Talk Subject: RE: Template running more than once? We have a case where it appears our template is running twice - but only intermittently. I had a similar problem and it was, thankfully, tracked down to an error in a dynamic img tag. Disable images in your browser and see if it still loads the tempalte twice. If it doesn't then try looking in any dynamic image or anchor tags for improperly closed tags. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Locked
Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error)PP [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'machine'.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (432:1) to (432:46)./pPP __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem w/ CFFILE...
Kelly, Try adding this atribute to your form tag: enctype=multipart/form-data -Elizabeth -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:40 AM To: CF-Talk Subject: Problem w/ CFFILE... I haven't run across this error before. On my form I have this: td valign=bottom align=rightfont size=2bLogo:/b/font/td td valign=bottominput type=file name=LogoFileName value= size=30 maxlength=64/td Which allows for me to upload a file. I basically click Browse and find the image. The action page has: CFIF Trim(LogoFileName) NEQ cffile action=UPLOAD filefield=Form.LogoFileName destination=#UploadDirectory# nameconflict=MAKEUNIQUE CFSET LogoFileName=ServerFile /CFIF Well I am getting an error on that that says: Message Error in CFFILE tag Type UNKNOWN Detail The form field specified in the CFFILE tag (LogoFileName) does not contain an uploaded file. Please be sure that you have specified the correct form field name. Yet I am choosing a file on the form page. Any idea what would be causing this NOT to work? I have never see this problem before. -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Locked
It could also happen if someone opens the database in exclusive mode. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 11:56 AM Subject: Locked Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error)PP [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'machine'.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (432:1) to (432:46)./pPP __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Locked
This can also mean that the database is corrupted. Try opening the DB and compacting and repairing it. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 8:56 AM Subject: Locked Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error)PP [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'machine'.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (432:1) to (432:46)./pPP __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 'Edit with CF Studio' with right-click in Windows Explorer
After upgrading to Studio 5.0 I lost the 'Edit with CF Studio' option when I right-click on a cfm or html file in Windows Explorer. How can I get this back or is this a new feature of Studio 5.0? Thanks! By default, you should have this option. In any case, though, it's easy to add it in. Just go to Windows Explorer, select Folder Options from the Tools menu, go to the File Types tab, highlight the extension you want to edit, then select the Advanced button. Note that the above steps are for Windows 2000; if you're running NT, the same thing can be done, but the menu structure is a little different. You'd still do it through Windows Explorer, though. Finally, this is just an interface to the Registry. I'm not sure which key to edit, but this one looks to be a likely suspect: HKCU\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.cfm\OpenWi thList Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: which is the best way to do auto retrieval of Address...
Yes you could do that, in the onchange paramater of the select box have it popup a new window. Do the query in that new window, then user the following javascript. script opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; /script If the form isn't named, and you only have 1 form on your page, you can use opener.forms[0].streetname Although this will cause a popup to show and disappear, I think a better way would be to just navigate to the same page with ?zip=12345 at the end of it. You'd have to cfparam all of your form fields this way, like cfparam name=thisform.FirstName default= Then in the form, input type=text name=FirstName value=#thisform.FirstName# At the top of the page you'd need to do something like. cfif isDefined(FORM.postalcode) cfset thisform = StructCopy(FORM) /cfif That will copy everything submitted through the form into the thisform structure, so if they filled out half of the form before selecting a postal code, it will load it all in the form. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:19 AM To: CF-Talk Subject: Re: which is the best way to do auto retrieval of Address... hmm.. are u saying... upon selected a postal code.. i callup a popup page which will perform a cfquery and do a matching... then pass back the matched value back to parent?? can I do that..?? if can... how shld i pass the value to and fro child and parent page...?? cheers han - Original Message - From: Robert Obreczarek [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:44 PM Subject: RE: which is the best way to do auto retrieval of Address... How about using frames? maybe an iframe/ilayer. that way you could click on a name, and the info would pop in a another frame Robert -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:13 PM To: CF-Talk Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td width=5%nbsp;/td td width=5%nbsp;/td /tr tr tdST/td td colspan =3cfinput type=text name=strStreetName size=50 maxlength=50 message=Please enter your Street Name. required=Yes onerror=setFocus value=#session.prospect.strStreetName#/td tdBLDG/td td colspan =3cfinput type=text name=strBuildingName size=50 maxlength=50 message=Please enter your Building Name. required=No value=#session.prospect.strBuildingName#/td /tr tr
RE: local variable dump?
Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: local variable dump?
The local (variables.) scope is not a structure, so you cannot retreive them automatically. You can see them using the debugger in CFStudio. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: woensdag 27 februari 2002 18:06 To: CF-Talk Subject: QQ: local variable dump? Is it possible to dump/loop through local variables? As I've said many times on this list, cfdump is a godsend for debugging, but I have not found a way to loop through all my local/varaible scoped variables yet... Tyler Silcox email | [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT JS again
There's a tag called cf_state on the dev exchange that does all of the work for you, you just declare the name of the field. cf_state name=state _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 10:59 AM To: CF-Talk Subject: OT JS again sorry for all the js stuff today. have a function to write a select box of states. is it faster, in general, to write text to a page with a function or return a string and write the string? Thanksabunch, Savan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: local variable dump?
Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. Client variables you can. Use GetClientVariablesList() if CFDump doesn't work. Server variables are the other scope that you cannot CFDUMP. Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: which is the best way to do auto retrieval of Address...
http://www.ashleyit.com/rs/main.htm jon - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:13 AM Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td width=5%nbsp;/td td width=5%nbsp;/td /tr tr tdST/td td colspan =3cfinput type=text name=strStreetName size=50 maxlength=50 message=Please enter your Street Name. required=Yes onerror=setFocus value=#session.prospect.strStreetName#/td tdBLDG/td td colspan =3cfinput type=text name=strBuildingName size=50 maxlength=50 message=Please enter your Building Name. required=No value=#session.prospect.strBuildingName#/td /tr tr tdPD/td tdcfSELECT name=strPostalName display=strPostalCode value=strPostalCode query=postalCode_list size=1 message=Please choose your Postal Code. required=Yes onerror=setFocus Selected=#session.prospect.strPostalName# onChange=display_Street(this.options[this.selectedIndex].value, StreetName_array);/CFSELECT/td tdTYPE/td tdcfselect name=strAddressType message=Please enter your Housing Type. required=Yes onerror=setFocus Selected=#session.prospect.strAddressType# size=1 option value=A cfif #session.prospect.strAddressType# eq 'A'SELECTED/cfifA/option option value=B cfif #session.prospect.strAddressType# eq 'B'SELECTED/cfifB/option /cfselect/td tdnbsp;/td tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr /table __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: local variable dump?
Yes. I knew about the GetClientVariablesList. But that is not quite the same code as a standard loop over the structure. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:53 AM To: CF-Talk Subject: Re: local variable dump? Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. Client variables you can. Use GetClientVariablesList() if CFDump doesn't work. Server variables are the other scope that you cannot CFDUMP. Regards Stephen __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
structure of arrays
Could somebody set me straight? First, I have a structure of arrays. I am trying to populate the arrays while looping through the structure keys. I'm getting all lost in the syntax and was hoping someone might be able to spot what I need to do. cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen(variables.mys truct.#query.dynamicKeyname#)+1')#][1] = value cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen(variables.mys truct.#query.dynamicKeyname#)')#][2] = value2 Here's the error: Cannot set dynamic variable with name 'variables.tophead_struct.Consumer[1][1]'. The variable name is illegal. Variable names must start with a letter and can include only letters, numbers, and underscores. It's getting the name correctly, but that's what it doesn't like. It's not referring to it as an array, it's thinking I want an actual variable named that (with the brackets, etc). I think it's because of the quotes wrapped around the variable name, but it doesn't even get past the first period without them. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfjava.cab forced install
I have a friend with the following problem on a CF 4.5.2 server: I have a site that requires the CFJAVA.CAB to be installed and run. There is a form on the entry page and it is marked enablecab=Yes. However, it doesn't force the CAB to install. However, I can send the user to another page that has the same setting and it does. Is there something I'm missing that doesn't force the install? Is there an alternate method to force it? Does he have a path problem? Mark A. Kruger, MCSE, CFG www.cfwebtools.com ..no more brochures! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail subject line
Hello, Can I include a variable field in the subject= line when using cfmail? Here is a sample: CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=Thank you for using our information - #FORM.Institution# The #FORM.Institution# does not display the institution in the subject line when the reply email is recieved. Any help appreciated - thanks! Robert O. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure of arrays
Try: cfset variables.mystruct[#query.dynamicKeyName#][#incrementValue(arrayLen(va riables.mystruct[query.dynamicKeyName]))#][1] = valuee Note - no need for quotes or evaluate. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:41 PM To: CF-Talk Subject: structure of arrays Could somebody set me straight? First, I have a structure of arrays. I am trying to populate the arrays while looping through the structure keys. I'm getting all lost in the syntax and was hoping someone might be able to spot what I need to do. cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen (variables.mys truct.#query.dynamicKeyname#)+1')#][1] = value cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen (variables.mys truct.#query.dynamicKeyname#)')#][2] = value2 Here's the error: Cannot set dynamic variable with name 'variables.tophead_struct.Consumer[1][1]'. The variable name is illegal. Variable names must start with a letter and can include only letters, numbers, and underscores. It's getting the name correctly, but that's what it doesn't like. It's not referring to it as an array, it's thinking I want an actual variable named that (with the brackets, etc). I think it's because of the quotes wrapped around the variable name, but it doesn't even get past the first period without them. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP and html stripping
Tyler, hehe - ok then, on to the great adventure w. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:33 AM To: CF-Talk Subject: Re: CFPOP and html stripping You can grab the HTML part of the multi-part message from your attachments directory that you specify with the AttachmentsPath attribute of cfpop. CF saves your HTML part of the message with a unique filename, without a file extension. So you'll have to parse out the real attachments first, and then what you're left with should be your html message. Loads of fun! Tyler email | [EMAIL PROTECTED] - Original Message - From: Pete Freitag [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 8:43 PM Subject: RE: CFPOP and html stripping If the message is a multi-part message (contains both HTML and Plain Text) then CFPOP will show just the plain text part. Most email clients will send what you may think are just HTML messages in multi-part format (Outlook, etc) because if a user is using a mail client that does not support HTML but is multipart aware (like Pine for instance) it will only show the user the plain text part. If you see something like this in a message header Content-Type: multipart/alternative; then you are dealing with multi-part messages As far as I know there is no way to get the html part of the message with CFPOP. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:36 PM To: CF-Talk Subject: RE: CFPOP and html stripping No I mean CFPOP - he wants to retrieve the body of a message, store it, then use it in a mass mail application. The body he retrieves has the html stripped out of it. Perhaps it's the senders client eh? Mk -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 3:17 PM To: CF-Talk Subject: RE: CFPOP and html stripping Do you mean CFMAIL? CFPOP just retrieves and deletes message from a server. If he's forwarding an email he must be using CFMAIL. If he doesn't put CFMAIL type=HTML Then it will default to sending plain text. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 3:07 PM To: CF-Talk Subject: CFPOP and html stripping Folks, Can anyone verify that CFPOP on 4.5 strips out all html tags in the body of a message? I have a friend who's trying to let an editor email a mass mail message to his CF server - which then forwards it to the appropriate groups. But the email message is supposed to be html, and it appears that CFPOP gets rid of all the HTML. Mark __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT-possible IIS problem
Hello all We are trying to stand up a new web server with CF5/IIS5/WIN2K During the process of locking the server permissions/users down. We deleted the IWAM_servername and set up another account with the permissions we thought were needed. WE reviewed all the mapped directories/sites in IIS and changed the log on to the new account and reviewed all the services to also make sure the old account was not in use. But we are still getting the error that the old account is trying to long on and for obvious reasons is being denied access. We re-reviewed everything again and can find what is trying to log on using this account. The error acures with any site we try to run. part of the error is access is being denied to /LM/W3SVC/1/ROOT, which should be the mapping to the first IIS web site or /LM/W3SVC/1/ROOT/CFIDE? which would be the mapping to coldfusion admin. Can anyone think of a hidden or hard to find service or object that might be trying to use this The old IWAM account. THanks for any help __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail subject line
It should work, but it doesn't. Am I missing anything? Thanks for the quick reply. Robert O. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:53 PM To: CF-Talk Subject: Re: cfmail subject line Yes, that should work. Regards, Howie - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:45 PM Subject: cfmail subject line Hello, Can I include a variable field in the subject= line when using cfmail? Here is a sample: CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=Thank you for using our information - #FORM.Institution# The #FORM.Institution# does not display the institution in the subject line when the reply email is recieved. Any help appreciated - thanks! Robert O. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail subject line
cfoutput the variable to the screen... make certain that it's defined and how you want it... The cfmail subject line should accept vars with no problem. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:55 PM To: CF-Talk Subject: RE: cfmail subject line It should work, but it doesn't. Am I missing anything? Thanks for the quick reply. Robert O. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:53 PM To: CF-Talk Subject: Re: cfmail subject line Yes, that should work. Regards, Howie - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:45 PM Subject: cfmail subject line Hello, Can I include a variable field in the subject= line when using cfmail? Here is a sample: CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=Thank you for using our information - #FORM.Institution# The #FORM.Institution# does not display the institution in the subject line when the reply email is recieved. Any help appreciated - thanks! Robert O. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Logs - Page cannot be displayed Error
I'm having a problem with my web server, when traffic gets high the server goes down. When I say goes down I mean IIS stops functioning, it looks like it anyway. When I go to the site I get a Page cannot be displayed error almost like DNS isn't working right. The weird thing is though, when I restart CF services the server comes right back up. I've combed the NT logs and haven't found anything odd. Are there certain CF logs that I can look through to see if it's CF causing the problem? Has anyone ever experienced this problem before? Thanks. Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 Imagination is the one weapon in the war against reality. Jules de Gaultier __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Closing a window from JS without prompt?
I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail subject line
try this: cfset subject =Thank you for using our information - FORM.Institution CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=#subject# Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:45 PM Subject: cfmail subject line Hello, Can I include a variable field in the subject= line when using cfmail? Here is a sample: CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=Thank you for using our information - #FORM.Institution# The #FORM.Institution# does not display the institution in the subject line when the reply email is recieved. Any help appreciated - thanks! Robert O. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: local variable dump?
The only problem is that in order to do this, since client variables are stored in a database or the registry. For every single page request CF would have to do a database query or read the registry and build that structure. That's a big performance hit. Perhaps if they made it an optional thing in the CF admin, like the Disable global client variable updates option, then i'd think it is a good idea. The problem is that would confuse the API a bit, the docs would all have to have a little *, so people would know to check to see if that option was enabled... I usually just store a wddx packet as the client variable, then it's only one line of code to turn the client variable I'm after into a nice struct. jon - Original Message - From: David Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:26 PM Subject: RE: local variable dump? Yes. I knew about the GetClientVariablesList. But that is not quite the same code as a standard loop over the structure. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:53 AM To: CF-Talk Subject: Re: local variable dump? Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. Client variables you can. Use GetClientVariablesList() if CFDump doesn't work. Server variables are the other scope that you cannot CFDUMP. Regards Stephen __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Closing a window from JS without prompt?
oi Shawn!! don't think it's possible without that prompt. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Wednesday, February 27, 2002, 2:04:05 PM, you wrote: SG I'm looking for ideas on how to close a Parent window from Javascript SG without getting the confirmation prompt. SG We don't have an issue with any child windows, but we open an interface to SG our app then want to close the original window without the prompt. SG Any tips? Thanks in advance. SG Shawn Grover SG __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Closing a window from JS without prompt?
oi Critz, I think the only ones that can be closed without a prompt are the ones that are spawned by JS. EC -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:00 PM To: CF-Talk Subject: Re: OT: Closing a window from JS without prompt? oi Shawn!! don't think it's possible without that prompt. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Wednesday, February 27, 2002, 2:04:05 PM, you wrote: SG I'm looking for ideas on how to close a Parent window from Javascript SG without getting the confirmation prompt. SG We don't have an issue with any child windows, but we open an interface to SG our app then want to close the original window without the prompt. SG Any tips? Thanks in advance. SG Shawn Grover SG __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
You can't do it. In the security model of Javascript the only windows that can be closed are the child windows. At least, that's what I've been taught. - Matt Small -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added the object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Works like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT-possible IIS problem
Are you running Active Directory? If so, the security settings for those folders for the web *might* have been initially set for public read-only access under that IWAM_server account (even if you have already changed the security settings under the web site properties) - which would cause an access error. If you aren't running AD, you might still try checking the security settings of those folders/files on the hard disk, make sure that the settings are propagating to their children - as well as ensuring that the web site security settings in IIS are using the new security account. HTH. -Original Message- From: Bruce, Rodney (SIGNAL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:56 AM To: CF-Talk Subject: OT-possible IIS problem Hello all We are trying to stand up a new web server with CF5/IIS5/WIN2K During the process of locking the server permissions/users down. We deleted the IWAM_servername and set up another account with the permissions we thought were needed. WE reviewed all the mapped directories/sites in IIS and changed the log on to the new account and reviewed all the services to also make sure the old account was not in use. But we are still getting the error that the old account is trying to long on and for obvious reasons is being denied access. We re-reviewed everything again and can find what is trying to log on using this account. The error acures with any site we try to run. part of the error is access is being denied to /LM/W3SVC/1/ROOT, which should be the mapping to the first IIS web site or /LM/W3SVC/1/ROOT/CFIDE? which would be the mapping to coldfusion admin. Can anyone think of a hidden or hard to find service or object that might be trying to use this The old IWAM account. THanks for any help __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC and stored procs
What are the limitations of using ODBC with stored procs? I was trying to change over a datasource from OLEdb to ODBC and now I keep getting an error that says: - Error Diagnostic Information ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (5:1) to (5:119). The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21). Date/Time: 02/27/02 13:18:13 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows XP) Opera 6.0 [en] Remote Address: 127.0.0.1 HTTP Referrer: http://acigweb/ - All this stored proc does is update some fields in a table, and it doesn't return any values. Could that be the problem? Thanks Marlon __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
Does this work in NN 4.7? -Original Message- From: Justin Waldrip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:18 AM To: CF-Talk Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added the object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Works like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Closing a window from JS without prompt?
Hi! As far as I know you cannot close a parent window from a child, but I think you can try something like this: 1. call setTimeout(closeFunction, 2000) 2. open the child window from the parent 3. in closeFunction you close your parent window and I think you get no confirmation promt. HTH, Mack - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 11:04 AM Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
that snippet didn't work in either NS or IE for me IE didn't even load the page and NS bombed because it said that closes was not defined i just pasted that snippet into a page. is there something else that needs to be done? Justin Waldrip [EMAIL PROTECTED] on 02/27/2002 01:17:54 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added th e object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Work s like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
Not sure I don't use NN. -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:25 PM To: CF-Talk Subject: RE: Closing a window from JS without prompt? Does this work in NN 4.7? -Original Message- From: Justin Waldrip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:18 AM To: CF-Talk Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added the object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Works like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Closing a window from JS without prompt?
i would use a javascript function to open the window and subsequently c lose itself. If there are any URLs in the history of a window it cannot c lose, with javascript, without a prompt (up to IE 5.5 and NS 4.7). I'm not sure about version 6s. Savan Macarie Neculai [EMAIL PROTECTED] on 02/27/2002 11:25:31 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: Closing a window from JS without prompt? Hi! As far as I know you cannot close a parent window from a child, but I think you can try something like this: 1. call setTimeout(closeFunction, 2000) 2. open the child window from the parent 3. in closeFunction you close your parent window and I think you get no confirmation promt. HTH, Mack - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 11:04 AM Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interfa ce to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Closing a window from JS without prompt?
Sorry I forgot to name the form. I just tried this and it works on IE. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form name=form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:28 PM To: CF-Talk Subject: RE: Closing a window from JS without prompt? that snippet didn't work in either NS or IE for me IE didn't even load the page and NS bombed because it said that closes was not defined i just pasted that snippet into a page. is there something else that needs to be done? Justin Waldrip [EMAIL PROTECTED] on 02/27/2002 01:17:54 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added th e object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Work s like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure of arrays
perfect, thank you so much. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 12:48 PM To: CF-Talk Subject: RE: structure of arrays Try: cfset variables.mystruct[#query.dynamicKeyName#][#incrementValue(a rrayLen(va riables.mystruct[query.dynamicKeyName]))#][1] = valuee Note - no need for quotes or evaluate. == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:41 PM To: CF-Talk Subject: structure of arrays Could somebody set me straight? First, I have a structure of arrays. I am trying to populate the arrays while looping through the structure keys. I'm getting all lost in the syntax and was hoping someone might be able to spot what I need to do. cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen (variables.mys truct.#query.dynamicKeyname#)+1')#][1] = value cfset variables.mystruct.#query.dynamicKeyname#[#evaluate('arraylen (variables.mys truct.#query.dynamicKeyname#)')#][2] = value2 Here's the error: Cannot set dynamic variable with name 'variables.tophead_struct.Consumer[1][1]'. The variable name is illegal. Variable names must start with a letter and can include only letters, numbers, and underscores. It's getting the name correctly, but that's what it doesn't like. It's not referring to it as an array, it's thinking I want an actual variable named that (with the brackets, etc). I think it's because of the quotes wrapped around the variable name, but it doesn't even get past the first period without them. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
thanks
Thanks everyone for the quick replies and assistance on the variable name included subject= line on CFmail. I deleted the - (dash) and it works... __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:SOLUTION - Closing a window from JS without prompt?
We managed to do it, but by tricking the calling window. Here's a code snippet that might be useful for some of you out there: mainwin = window.open('#NewURL#', 'mainwin', ''); !--- Close original window, this trick works under IE5.5+ only --- mainwin.opener = mainwin; window.opener = mainwin; window.close(); (to be fair, I have to give credit for this to another of our developers...) Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 12:28 PM To: CF-Talk Subject: RE: Closing a window from JS without prompt? that snippet didn't work in either NS or IE for me IE didn't even load the page and NS bombed because it said that closes was not defined i just pasted that snippet into a page. is there something else that needs to be done? Justin Waldrip [EMAIL PROTECTED] on 02/27/2002 01:17:54 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added th e object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Work s like a champ for me. You might have to play around with it depending on your need. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param name=Command value=Close /object /head script function closeme() { closes.Click(); } /script body onload=document.form.CloseArea.focus(); form input type=text name=CloseArea onfocus=closeme() style=width: 0px; /form /body /html -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:04 PM To: CF-Talk Subject: OT: Closing a window from JS without prompt? I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Server Login failed
This is my first foray into working with CF and SQL Server. With the ISP's help, I've been able to connect to the remote site's SQL Server and copy the database to my local development box. I can read the tables, etc., locally, but I am now having trouble setting this up as a datasource in the ODBC manager of the Control Panel in Win2K. I keep getting an error Not associated with a trusted SQL Server connection. Here's the error I get when I run the connectivity test: Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xx'. Reason: Not associated with a trusted SQL Server connection. I've confirmed the SQL login info for this database so it must be something else. Can anyone suggest where to go from here? I need to be able to hit the datasource from my ColdFusion app but it's not letting me login. TIA, Chris Montgomery (SQL Server newbie) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT-possible IIS problem
Bruce, Rodney (SIGNAL) wrote: But we are still getting the error that the old account is trying to long on and for obvious reasons is being denied access. We re-reviewed everything again and can find what is trying to log on using this account. The error acures with any site we try to run. I identified the same problem when locking down IIS 5. I didn't find a solution (yet), but we still have some months before IIS 5 deployment. part of the error is access is being denied to /LM/W3SVC/1/ROOT, which should be the mapping to the first IIS web site or /LM/W3SVC/1/ROOT/CFIDE? which would be the mapping to coldfusion admin. Can anyone think of a hidden or hard to find service or object that might be trying to use this The old IWAM account. If you have some tool to make a dump of the entire metabase, now is the time to use it (does anyone know if the IIS4 tools work?). I expect it is some obscure setting somewhere. Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crossed Session Variables - many users with same User
On an Intranet, my users are getting crossed session variables. I would appreciate any ideas as to what I can do about this. I've got a lot of users that are logging on to our NT domain with the same log in (but different static IP addresses) - requirements changed during development. This is causing them to see the session variable of the first one in. I set the session variables by cfif NOT isdefined(Session.Auth_User) set all my session variables. What is the easiest thing I can do about this? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Date Math
I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin http://www.gslsolutions.com/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Math
Try the DateDiff() function. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:17 PM To: CF-Talk Subject: Date Math I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin http://www.gslsolutions.com/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Logs - Page cannot be displayed Error
look through the server log in CF. -chris.alvarado [application developer] 4|Guys Interactive, Inc. http://www.4guys.com - Original Message - From: Mark M. Kecko [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:09 PM Subject: Logs - Page cannot be displayed Error I'm having a problem with my web server, when traffic gets high the server goes down. When I say goes down I mean IIS stops functioning, it looks like it anyway. When I go to the site I get a Page cannot be displayed error almost like DNS isn't working right. The weird thing is though, when I restart CF services the server comes right back up. I've combed the NT logs and haven't found anything odd. Are there certain CF logs that I can look through to see if it's CF causing the problem? Has anyone ever experienced this problem before? Thanks. Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 Imagination is the one weapon in the war against reality. Jules de Gaultier __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Login failed
go to your Client network Utility (under your SQL Server program group). add the name of the database, and select TCP/IP as your connection library. christopher olive, cto, vp of web development, vp security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:49 PM To: CF-Talk Subject: OT: SQL Server Login failed This is my first foray into working with CF and SQL Server. With the ISP's help, I've been able to connect to the remote site's SQL Server and copy the database to my local development box. I can read the tables, etc., locally, but I am now having trouble setting this up as a datasource in the ODBC manager of the Control Panel in Win2K. I keep getting an error Not associated with a trusted SQL Server connection. Here's the error I get when I run the connectivity test: Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xx'. Reason: Not associated with a trusted SQL Server connection. I've confirmed the SQL login info for this database so it must be something else. Can anyone suggest where to go from here? I need to be able to hit the datasource from my ColdFusion app but it's not letting me login. TIA, Chris Montgomery (SQL Server newbie) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date Math
How do i use that? - Original Message - From: Albrechtas, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 3:06 PM Subject: RE: Date Math Try the DateDiff() function. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:17 PM To: CF-Talk Subject: Date Math I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin http://www.gslsolutions.com/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date Math
oh and they are not just dates they are datetimes - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 3:17 PM Subject: Date Math I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin http://www.gslsolutions.com/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ThreeSelectsRelated?
HELP!!! I'm trying to find this tag (Three Selects Related) and I'm not able to find it! Does anyone have a link to a place I can download it from? Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
About to call Macromedia Tech Support on this one...
The following is an error we see in our webserver.log quite a bit: ERROR,TID=3580,02/27/02,10:23:38,Error attempting to write location redirection to web server (Windows NT error number -2147467259 occurred) I'm personally convinced that this is related to some other problems we're having, but that's another story. I'm wondering if anyone has seen this error before/has any clue of where to start looking to resolve it. I've looked on TechNet and MS Support pages for the error number, but it appears to be one of Win2K's generic error messages that apply to many situations, none of which seem to apply to our environment. We're using Win2K Server, CF 4.5 with all patches, SQL Server 2000. Database servers and web/CF servers are separate boxes. All part of the same domain. The interesting thing to me is that this shows up in webserver.log, not application.log or server.log. Any help or thoughts on this is much appreciated. Thanks, Evan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Math
The usage of ColdFusion function can be found in your online documentation (if you have it installed) or you can download pdf versions here. http://www.macromedia.com/support/coldfusion/documentation.html I believe you will want the CFML Reference. Also, look up the DateAdd() function for the second part of your problem. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:23 PM To: CF-Talk Subject: Re: Date Math How do i use that? - Original Message - From: Albrechtas, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 3:06 PM Subject: RE: Date Math Try the DateDiff() function. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:17 PM To: CF-Talk Subject: Date Math I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin http://www.gslsolutions.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Logs - Page cannot be displayed Error
We had that problem with a scheduled task quering a Filemaker db. Rick -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:10 PM To: CF-Talk Subject: Logs - Page cannot be displayed Error I'm having a problem with my web server, when traffic gets high the server goes down. When I say goes down I mean IIS stops functioning, it looks like it anyway. When I go to the site I get a Page cannot be displayed error almost like DNS isn't working right. The weird thing is though, when I restart CF services the server comes right back up. I've combed the NT logs and haven't found anything odd. Are there certain CF logs that I can look through to see if it's CF causing the problem? Has anyone ever experienced this problem before? Thanks. Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 Imagination is the one weapon in the war against reality. Jules de Gaultier __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT-possible IIS problem
If you have some tool to make a dump of the entire metabase, now is the time to use it (does anyone know if the IIS4 tools work?). I expect it is some obscure setting somewhere. I think that either Metabase Editor will work with both IIS 4 and 5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: About to call Macromedia Tech Support on this one...
Looks like this happens on CFLOCATION calls. IIS threw an error to CF Server saying that it can't send the redirection headers. Perhaps the browser's TCP connection to IIS was broken before the CFLOCATION could execute. This should happen intermittently, and would depend on heavy load (server load, and available bandwidth). Just a wild guess. :) James Ang -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 12:21 PM To: CF-Talk Subject: About to call Macromedia Tech Support on this one... The following is an error we see in our webserver.log quite a bit: ERROR,TID=3580,02/27/02,10:23:38,Error attempting to write location redirection to web server (Windows NT error number -2147467259 occurred) I'm personally convinced that this is related to some other problems we're having, but that's another story. I'm wondering if anyone has seen this error before/has any clue of where to start looking to resolve it. I've looked on TechNet and MS Support pages for the error number, but it appears to be one of Win2K's generic error messages that apply to many situations, none of which seem to apply to our environment. We're using Win2K Server, CF 4.5 with all patches, SQL Server 2000. Database servers and web/CF servers are separate boxes. All part of the same domain. The interesting thing to me is that this shows up in webserver.log, not application.log or server.log. Any help or thoughts on this is much appreciated. Thanks, Evan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:ThreeSelectsRelated?
Of course, the minute I post a request for help the world starts treating me nicely... I found it and have downloaded it. Thanks! Hatton C. Hatton Humphrey [EMAIL PROTECTED] wrote on 2/27/2002 3:20:41 PM: HELP!!! I'm trying to find this tag (Three Selects Related) and I'm not able to find it! Does anyone have a link to a place I can download it from? Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Developer version of CF Server 4.5?
Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer version of CF Server 4.5?
download the Enterprise evaluation version when the 30 days times out, it becomes the developer version. Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Developer version of CF Server 4.5?
I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer version... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. ___ _ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Developer version of CF Server 4.5?
Why 4.5??? Why not 5.0 Success is a journey, not a destination!! Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer version... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. ___ _ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Developer version of CF Server 4.5?
I'm working in a 4.5 environment. It's a bit easier to code if I don't accidently use 5.0 stuff (as I've worked in a 5.0 environment as we ll, so my tendency is to use 5.0 code wherever possible). - Original Message - From: Douglas Brown [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 2:25 pm Subject: Re: RE: Developer version of CF Server 4.5? Why 4.5??? Why not 5.0 Success is a journey, not a destination!! Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer versio n... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF S erver 4.5? Can't seem to find one on MM's site. _ __ __ ___ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=col dfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@house offusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm ?sideb ar=lists ___ _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Developer version of CF Server 4.5?
DOH!!! I obviously didn't read that close enough - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer version... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. ___ _ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Developer version of CF Server 4.5?
ah ic I do not believe that 4.5 ever had a developer edition. I could be wrong though. Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:06 PM Subject: Re: RE: Developer version of CF Server 4.5? I'm working in a 4.5 environment. It's a bit easier to code if I don't accidently use 5.0 stuff (as I've worked in a 5.0 environment as we ll, so my tendency is to use 5.0 code wherever possible). - Original Message - From: Douglas Brown [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 2:25 pm Subject: Re: RE: Developer version of CF Server 4.5? Why 4.5??? Why not 5.0 Success is a journey, not a destination!! Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer versio n... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF S erver 4.5? Can't seem to find one on MM's site. _ __ __ ___ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=col dfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@house offusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm ?sideb ar=lists ___ _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer version of CF Server 4.5?
Got a copy of the Studio v4.5 CD around there anywhere? It should be on there. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Developer version of CF Server 4.5?
It didn't, it did have cf express tho -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 4:34 PM To: CF-Talk Subject: Re: RE: Developer version of CF Server 4.5? ah ic I do not believe that 4.5 ever had a developer edition. I could be wrong though. Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:06 PM Subject: Re: RE: Developer version of CF Server 4.5? I'm working in a 4.5 environment. It's a bit easier to code if I don't accidently use 5.0 stuff (as I've worked in a 5.0 environment as we ll, so my tendency is to use 5.0 code wherever possible). - Original Message - From: Douglas Brown [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 2:25 pm Subject: Re: RE: Developer version of CF Server 4.5? Why 4.5??? Why not 5.0 Success is a journey, not a destination!! Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days times out, it becomes the developer versio n... . Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF S erver 4.5? Can't seem to find one on MM's site. _ __ __ ___ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=col dfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@house offusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm ?sideb ar=lists ___ _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Developer version of CF Server 4.5?
I got one at home. I'm just being impatient and want it today :P - Original Message - From: Ken Wilson [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 2:13 pm Subject: RE: Developer version of CF Server 4.5? Got a copy of the Studio v4.5 CD around there anywhere? It should be on there. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. ___ _ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Developer version of CF Server 4.5?
[EMAIL PROTECTED] wrote: Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. You can download an evaluation version of CF 4.5 but it is just a 30 days version. Or you can download the Express Edition, which will work unlimited, but crippled. There might even be a Single User Version available, but this is only an endorsement if that is legal because you have CF Studio 4.5 :) Anyway, the address you need is ftp.allaire.com, somewhere under pub or outgoing. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL indexing
The answer is a definite maybe. I'm Oracle familiar, not SQL Server, but if the data is skewed in any of those columns(90%=0 10%=1) then you may get some benefit when selecting the smaller value. Also, Oracle has special indexes for columns with low cardinality called bitmap indexes. These are amazing for static data, but can really slow down inserts and updates on these tables. You might want to see if SQL Server has something similar. HTH, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 2:26 PM To: CF-Talk Subject: OT: SQL indexing Is there any benefit to indexing a tinyint field that is used as a boolean (either 1 or 0)? I have four fields that work this way and I use them heavily in queries for reporting. They are used in aggregate functions (count and sum) as well as in the where clauses for various queries. I know I could play with the indexes and test the timing, but I only have a live database to work with and don't want to disrupt anything until I feel there will be some significant benefit. Also, along the same lines, I report by grouping output (in SQL - not CF's group=) using the DAY, HOUR and MONTH parts of a datetime stamp. Will indexing help when using portions of a datetime field in this way, as opposed to considering the entire field? BTW - this is using SQL Server 2000 (and I guess the same theory would apply to SQL 7). Thanks! Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Inserting a delimited list into a database
I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have a SQL query insert a record for each value in the list. But it keeps giving me an error on the insert query. Is it not possible to put a cfquery into a loop? Is there a better way to do this? Below is my code. Below that is the error I get. CFLOOP INDEX=ServerID LIST=#servers# DELIMITER=, cfquery datasource=Software Updates name=serverUpdate INSERT INTO update (log_id, server) VALUES (#logQuery.id#,#ServerID#) /cfquery /CFLOOP [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position... I thought that maybe the problem was that I didn't have a cfoutput around the #ServerID#, but that wasn't the problem either. Thanks for the help. -Jake __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting a delimited list into a database
Here's the function to parse a comma-delimited string: CREATE FUNCTION dbo.fnc_ParseDelimited ( @delimitedList VarChar(8000) ) RETURNS @tblSample TABLE (CounterID Int, FieldValue Varchar(100)) BEGIN Declare@CounterID VarChar(4) Declare@FieldValue Varchar(100) Declare @tmpTable Table (CounterID Int Primary Key, FieldValue VarChar(100)) Set @CounterID = 1 While CharIndex(',', @delimitedList) 0 Begin Set @FieldValue = LTrim(RTrim(subString(@delimitedList, 1, charIndex(',', @delimitedList)-1))) Insert Into @tmpTable Select @CounterID, @FieldValue Set @delimitedList = LTrim(RTrim(subString(@delimitedList, (charIndex(',', @delimitedList) + 1), Len(@delimitedList Set @CounterID = @CounterID + 1 End If LTrim(RTrim(@delimitedList)) != '' Insert Into @tmpTable Select @CounterID, @delimitedList Insert Into @tblSample Select * From @tmpTable Return END -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:47 PM To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have a SQL query insert a record for each value in the list. But it keeps giving me an error on the insert query. Is it not possible to put a cfquery into a loop? Is there a better way to do this? Below is my code. Below that is the error I get. CFLOOP INDEX=ServerID LIST=#servers# DELIMITER=, cfquery datasource=Software Updates name=serverUpdate INSERT INTO update (log_id, server) VALUES (#logQuery.id#,#ServerID#) /cfquery /CFLOOP [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position... I thought that maybe the problem was that I didn't have a cfoutput around the #ServerID#, but that wasn't the problem either. Thanks for the help. -Jake __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting a delimited list into a database
Oh yeah... In sql server... Just pass the comma-delimited list to sql server and use this to parse it. Way less calls to the database... -Original Message- From: Costas Piliotis Sent: Wednesday, February 27, 2002 1:49 PM To: '[EMAIL PROTECTED]' Subject: RE: Inserting a delimited list into a database Here's the function to parse a comma-delimited string: CREATE FUNCTION dbo.fnc_ParseDelimited ( @delimitedList VarChar(8000) ) RETURNS @tblSample TABLE (CounterID Int, FieldValue Varchar(100)) BEGIN Declare@CounterID VarChar(4) Declare@FieldValue Varchar(100) Declare @tmpTable Table (CounterID Int Primary Key, FieldValue VarChar(100)) Set @CounterID = 1 While CharIndex(',', @delimitedList) 0 Begin Set @FieldValue = LTrim(RTrim(subString(@delimitedList, 1, charIndex(',', @delimitedList)-1))) Insert Into @tmpTable Select @CounterID, @FieldValue Set @delimitedList = LTrim(RTrim(subString(@delimitedList, (charIndex(',', @delimitedList) + 1), Len(@delimitedList Set @CounterID = @CounterID + 1 End If LTrim(RTrim(@delimitedList)) != '' Insert Into @tmpTable Select @CounterID, @delimitedList Insert Into @tblSample Select * From @tmpTable Return END -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:47 PM To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have a SQL query insert a record for each value in the list. But it keeps giving me an error on the insert query. Is it not possible to put a cfquery into a loop? Is there a better way to do this? Below is my code. Below that is the error I get. CFLOOP INDEX=ServerID LIST=#servers# DELIMITER=, cfquery datasource=Software Updates name=serverUpdate INSERT INTO update (log_id, server) VALUES (#logQuery.id#,#ServerID#) /cfquery /CFLOOP [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position... I thought that maybe the problem was that I didn't have a cfoutput around the #ServerID#, but that wasn't the problem either. Thanks for the help. -Jake __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists