OT: Windows 2000 Professional, scheduled tasks and locking the co mputer
I've got 3 scheduled tasks set up in Windows 2000 Professional. If the computer is locked at night, all 3 tasks run OK the next morning. However, if it's locked (Ctrl-Alt-Del) at the weekend, the events run early Saturday morning but then don't run again on Sunday and Monday morning. When the machine's unlocked Monday morning, used and then locked again at 5.30pm, the tasks run OK early Tuesday morning. Do you know if there's any way to make them run multiple times, even when the PCs locked for several days at a stretch? I've looked through the options that are there and can't find anything that might be causing this behaviour... Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Studio registration number
o.k. Now I understand your point. When I do this I get the message: "This update requires a prior installation." And then the installation process is aborting. So maybe I have to go and get the real CD somewhere. :-) Uwe - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 1:36 AM Subject: Re: CF-Studio registration number You started with 4.52 eval which will not work if you put the serial number in, now that you have that installed download the upgrade which is 4.52 also but now you can put the serial number in... hope this clears up any confusion. Tom - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 2001 3:58 PM Subject: AW: CF-Studio registration number > As I said, I started with 4.5.2 right from the beginning. > So your suggestion doesn't make sense. > But thank you anyway. > > Uwe > > -Ursprüngliche Nachricht- > Von: Tom Davison [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 9. Mai 2001 01:06 > An: CF-Talk > Betreff: Re: CF-Studio registration number > > > You should now download the upgrade to 4.5 and install that and put in the > reg key. > > Tom > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, May 08, 2001 4:58 PM > Subject: AW: CF-Studio registration number > > > > No, that hasn't been the case. > > I tried that already earlier too. > > With no success. > > > > Uwe > > > > > > -Ursprüngliche Nachricht- > > Von: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > Gesendet: Dienstag, 8. Mai 2001 15:32 > > An: CF-Talk > > Betreff: RE: CF-Studio registration number > > > > > > just enter the serial number when you install it. > > > > you can uninstall and reinstall with the number. > > > > -Original Message- > > From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 08, 2001 5:13 AM > > To: CF-Talk > > Subject: CF-Studio registration number > > > > > > Hi, is there a way to fill in the registration number > > of a CF 4.5.2 Studio EVAL-Version later after installation ? > > I downloaded it because I couldn't find my original CF-Studio-CD. > > I looked in the registry but I couldn't find anything concerning a > > registration number. Thanks for ideas. > > > > Uwe > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Uploading a file
ACCEPT is an optional attribute that exists to exclude any file types not listed in that parameter. Leaving it out should not affect the upload. If you are uploading through a form have you set the correct MIME type in the form's ENCTYPE attribute? Tristram Charnley -- Allaire Certified ColdFusion Developer e-mail: [EMAIL PROTECTED] > -Original Message- > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > Sent: 09 May 2001 16:41 > To: CF-Talk > Subject: RE: Uploading a file > > > you are missing the accept paramater, > > destination="#application.root#jobdescriptionDocs\" > ACCEPT="mime_type/file_type"> > > > This could very well be your problem, I think the mime type > for Word docs is > "application/ms-word" > > -Original Message- > From: Nick Betts [mailto:[EMAIL PROTECTED]] > Sent: 08 May 2001 17:41 > To: CF-Talk > Subject: Uploading a file > > > Hi, > I am trying to upload a file on a server using CFFILE. All is well in > development, however on live server I get the following error: > > Error Occurred While Processing Request > Error Diagnostic Information > Request canceled or ignored by serverServer busy or unable to fulfill > request. The server is unable to fulfill your request due to > extremely high > traffic or an unexpected internal error. Please attempt your > request again > (if you are repeatedly unsuccessful you should notify the site > administrator). (Location Code: 26) > > The code I use to upload file is: > destination="#application.root#jobdescriptionDocs\"> > > > Is this error simply a server problem or is it to do with CFFILE. > > Cheers, > Nick. > > > > -Original Message- > From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] > Sent: 08 May 2001 17:16 > To: CF-Talk > Subject: RE: CFFILE > > > I don't think it is a permission problem. I set the permission on the > folder to everyone and still received the same error. It may > be a network > problem. When I upload the file to my hard drive destination > path="c:\" It > works. Any other path on my server returns the same error. Please > advise... > -- > -- > > Error Diagnostic Information > Error processing CFFILE > > The directory specified in the DESTINATION attribute of the > CFFILE tag (g:\) > is not valid. The directory either does not exist or is not > accessible by > the ColdFusion service. > > The error occurred while processing an element with a general > identifier of > (CFFILE), occupying document position (21:1) to (24:33). > > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 08, 2001 11:48 AM > To: CF-Talk > Subject: Re: CFFILE > > > If you are using UNC paths then you need to run CF under a > user account with > rights to the folder on the other server. By default, > CF runs under the system account. You can change this in the > NT Services > applet. > > HTH, > > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. > www.CoolFusion.com > 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > > > - Original Message - > From: "Foggy, Doreen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, May 08, 2001 11:43 AM > Subject: CFFILE > > > > Error Diagnostic Information > > Error processing CFFILE > > The directory specified in the DESTINATION attribute of the > CFFILE tag > > chh-test\www\lmts_int\cic is not valid. The directory > either does not > exist > > or is not accessible by the ColdFusion service. > > The error occurred while processing an element with a > general identifier > of > > (CFFILE), occupying document position > > > > > > I am using the CFFILE tag for the first time and I am > running into some > > problems. Please Help! The directory does exist and I am > not sure what > > accessible by the ColdFuison service means. The directory > is located on > the > > web server. > > * I have two forms > > * upload.cfm (html form) > > * uploadfile.cfm (action page) > > > > The syntax for both is located below: > > > > Upload.cfm > > WebStar: Contracts Online > > > > link="Silver" > > vlink="Yellow" alink="White"> > > border="0" alt=""> > > > > ENCTYPE="multipart/form-data"METHOD=POST> > >> border="0"> > > > > File to upload: > > > > > > > > > > > > File Destination: > > > >> value="\\chh-test\www\lmts_int\cic" size="50"> > > > > > > > > > > > > > > > > > > > > Upload.cfm > > WebStar: Contracts Online > > > > link="Silver" > > vlink="Yellow" alink="White"> > > border="0" alt=""> > > > > > filefield="FileName" > > destination="#form.FileDestination#" > > nameconflict="OVERWRITE"> > > > > > > CF 3.1 CFFILE Tag File Upload Demonstration Results
RE: Watchguard Firewall II stripping CGI variables?
> I'm not sure what version of WG are are using, but either way > you should be > able to go into the policy manager > and set up your own rules for port 80. I would recommend > though, to continue > using the http proxy if thats what your doing and try to > adjust the CF code > to conform to the standards that it wants. Thanks for the information. However, it looks as though it might not be the firewall after all *exasperated sigh*. The cgi variables that had become empty strings (eg HTTP_REFERER and a few others) on two servers are now displaying the correct values again. The Network Admin says he hasn't changed the settings on the firewall in the last few days and several other servers that are on the same network and accessed in the same way are displaying the cgi variables OK (suggesting possibly that it's not a firewall problem but at the level of the boxes). I had enabled "Log Slow Pages" in the ColdFusion Administrator on both the affected boxes that day and wondered if that had something to do with it. I've played around with the setting and after several reboots, it doesn't look like that was the cause. It's a bit of a mystery, but thanks again... -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange MDAC 2.6 Problems on Win2k
Hi, i have two problems with MDAC 2.6 on Win2k when accessing an Access 2k db from CF 4.5 SP2. 1. On one page I insert data to a table and do a CFLOCATION rigth after that. Then on the secont page I display that table. On earlier MDAC-Versions that worked great, but on 2.6 it seems like ODBC is not waiting for the insert to finish, and then display the data. T The result is that the update is not displayed on the second page. When I told CF to wait 500ms and then to do that CFLOCATION, it displays the data correctly(including the insert). Does anybody now how to correct that? 2. When I do a query where I concentrate the two fields projecttype and pname SELECT (project.projecttype & project.pname) as pname FROM project it gives me a syntax error. Did that syntax change? Can you help? Matthias P. Wiemann eWiemann Consulting GmbH Zentnerstr. 17 80798 Muenchen - Germany Tel: +49 (0)89 - 12 73 77 44 Fax: +49 (0)89 - 12 73 77 46 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfloop vs cfoutput - THE WINNER IS...
Seems to me no-ones 100% sure. I've found cfloop to execute better overall in most situations when I am working with very large amounts of data, Chris. I don't generally see much difference in execution time between the two, in any other situation (and cfoutput with a query attribute IS easier to use if it suits your needs) ~Simon -- Personally, use what you like. I have not found any measurable difference in performance between CFOUTPUT and CFLOOP. If performance becomes an issue, try to resolve it then. But usually by the time you sling manhours on it, you can upgrade to faster processor for less money. Sad but true. Ray Thompson I just remembered where I read that cfloops are more effiecient than cfoutput with queries, in ben forta's coldfusion developers study guide, if that helps clarify anything mark - Hmmm, You know, this was beaten into our heads a couple of years ago, so much so that I tend to jump at it (i.e. the last email). Perhaps it is time to reasses this assumption. I do recall Allaire stating it, but I don't recall the context. Mike Dinowitz, are you on the list today? I know you have definitive opinions on this, or at least you did a couple of years ago. I also recall Hal Helms debunking the difference. The funny thing was, I also recall an Allaire speaker describing why CFOUTPUT was faster for query outputs, but don't remember the details. Curious... Chris Graves, CCFD RapidCF I think I read somewhere that cfloop is more efficient than cfoutput with 4.5, previous to this cfoutput was more efficient If i'm wrong i'll soon be corrected :) mark And now to inject a little more uncertainty... Just a couple of months ago an Allaire consultant told me that cfloop was the second slowest tag after cfmail. Always use cfoutput to output queries. I imagine he was speaking relatively though. I can think of some really slow tags. jon -- This is from the Certified ColdFusion Developer Study Guide: pg 37 Tip #1 The function of the query loop is the same as using with a query attribute. For performance reasons, use a Query loop rather than a loop. Before ColdFusion 4.x, the query loop performed better. Generally speaking you should use a with a query attribute when doing all, or mostly, processing in the loop. If there is nothing in the loop but display, use So what's right? --- Well thats a bit misleadingthe more processing you do within a loop, the slower its going to be, no matter the looping method. For pure looping, I remember hearing from somewhere that CFLOOP was actually faster, all other things being equal. I remember being somewhat surprised by this. --- Well thats a bit misleadingthe more processing you do within a loop, the slower its going to be, no matter the looping method. For pure looping, I remember hearing from somewhere that CFLOOP was actually faster, all other things being equal. I remember being somewhat surprised by this. -- fcourse cfoutput, that's why it doesn't allow alot of tags to be typed into it. it's much more faster then CFLOOP, which lets you specify every cf tag you want (CFMAIL, for example) Thanks, Michael Lugassy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfloop vs cfoutput
> Sorry for the crosspost (had conflicting answers from other lists) > > but is there a consensus on which method of looping over a query > is fastest? > > cfloop or cfoutput.. OK, I know you've posted a "Winner" post, but here's the reasoning behind why CFOutput is slower than CFLoop When you run a CFOutput, CF has to look through as see what has to be converted for "output", i.e. #s around variables etc. When you run a CFLoop, it just assumes that anything that's a non-CF tag is to be sent to the browser, and it runs the tags as it reaches them Ideally, you should put a CFLoop around the code you wish to loop over, and only put CFOutput around the variables you want outputted - that provides the best performance on the server (which is probably the most important in most circumstances) Although, I don't like using this method for development (it's harder to read), the performance over many thousands of hits is noticable HTH Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Replace #'s Function!!
try this and see what happens... #code# Chris -Original Message- From: bfalloon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:07 AM To: CF-Talk Subject: Replace #'s Function!! Hello all, I've encounter a stumbling block... I'm performing a CFFILE action to read a text document that contains HTML, but I need to remove any # symbols before I can used the code from the file. I've included my code below, but the # symbol always throws an error. I've also tried double pound signed, but that just seems to completely escape the symbol to replace. In the Replace function I am tried to replace all #'s with nothing... It's not working though. Your help is greatly appreciated!! Benjamin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Insert query inserting a record into multiple tables
Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
2 insert statements needed here -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 12:21 To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email List Servers
VOPmail (vircom.com) is our mail server of choice. It's list functions, though not all inclusive, are good enough. The price is very reasonable for a full featured mail server. However, it sounds like that is not what you are looking for. Perhaps you should take a look at Mercury (pmail.com). Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Bill Holloway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:44 PM To: CF-Talk Subject: OT: Email List Servers Anyone have a good email list server recommendation. I've been looking at iMail but it's more than I need. (what's this list run on?) TIA for suggestions, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
Sure insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:21 AM To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UK-based ColdFusion training course for network administrator s
> You might want to check out Highlander.co.uk > > I did the advanced course there, they might well do a network > administrators one as well. Thanks... will do. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
Wow, that did it. I thought I had tried every combination of brackets, prens, quotes and double quotes. Thanks, this is the first time I've used a join so I wasn't really sure Access supported it or even if that exactly what I wanted (It is). Another strange thing if I change OLE DB connection (thought that might help). I get an even more cryptic error. I'll go back and apply your bracketing convention now and see if I can get it to work with the OLE DB. Thanks Again Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:57 AM To: CF-Talk Subject: RE: MS Access JOIN Error Does this work? FROM [MPA log] LEFT JOIN [52 log] ON [MPA log].[MPA #] = [52 log].[MPA #] Those table names and field names are pretty confusing. Is it an option for you to change the names so that they do not contain spaces, pound signs etc? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:37 PM To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = "SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close, "MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor FROM "MPA log" LEFT JOIN "52 log" ON 'MPA log.MPA #' = '52 log.MPA #'" Data Source = "HRTRACKER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance > Doug Kronenberger > OI National Training and Education Office > Depatment of Veterans Affairs > > 440-526-3030 x7776 [EMAIL PROTECTED] ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UK-based ColdFusion training course for network administrator s
> > You might want to check out Highlander.co.uk > > > > I did the advanced course there, they might well do a network > > administrators one as well. > > Thanks... will do. Just noticed (for anyone else that's interested) that their web site says there will be a "ColdFusion Server Administration" course available sometime this year. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
So there is no way to do it in one query then ? I have done it in two already but, it's just one of those burning questions I had to ask *L* Thanks, -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:19 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables Sure insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:21 AM To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
There is another way.. You could insert the data into one of the tables and then have an insert trigger on that table which automatically inserts the same data into the second table. However you can only do this if every time you insert into table 1 you want the same data to go into table 2 (which I'm not sure you'd ever want to do). Even though you are only wrting 1 sql statement yourself it is still 2 SQL staements that are executing. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:41 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables So there is no way to do it in one query then ? I have done it in two already but, it's just one of those burning questions I had to ask *L* Thanks, -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:19 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables Sure insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:21 AM To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ecometry and Cold Fusion
Hello Everyone, Does anyone have any experience working with Ecometry and Cold Fusion? My workplace has decided to purchase the ecometry product and wants to integrate its capabilities with our current webiste, all CF based. Any comments and information will be most appreciated. Thank you Andres ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
Sorry not in one CFQUERY -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:41 AM To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables So there is no way to do it in one query then ? I have done it in two already but, it's just one of those burning questions I had to ask *L* Thanks, -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:19 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables Sure insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:21 AM To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pinging an email address
1. an MX record is a DNS entry for a mail server 2. on most systems you can use "telnet xxx.xxx.xxx.xxx 25" 3. next you would have to type "HELO" 4. VRFY or EXPN (username) end. SMTP 101 :) "PEREZ, RICHARD RINGO (SBCSI)" <[EMAIL PROTECTED]> on 05/09/2001 04:35:12 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Pinging an email address What is an MX record how do you do that? -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:19 PM To: CF-Talk Subject: RE: Pinging an email address you can telnet to a mail server (they usually have exposure to the internet). 1) lookup the MX record for a domain 2) telnet to that mail server (usually on port 25) 3) do VRFY (username) or EXPN (username) however, those commands are unavailable sometimes for privacy/security reasons. or...sometimes you can FINGER an address. from a command line, use FINGER username@domain. but that's one way to verify it exists. you could also send an email to it and have a bot watch for undeliverable returns. no telling how long that would take to receive though. mail servers are configured differently for that both on the outbound and the inbound. --dylan -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:59 PM To: CF-Talk Subject: Pinging an email address Is there a way to "ping" an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Wrong permissions on a Sun Server
We use Studio (with the FTP Server connection to our Sun CF Server) with no problems. All the directories and files are owned by root, and the group is develop (develop is the group of all developers). The permissions on all directories and files is 775 (rwxrwxr-x). The CF server runs as user nobody, which uses the "other" permission (the r-x above). I suspect Studio merely uses the user/group/permissions of the directory the files go into, which I think is typical Unix. best, Chris Norloff -- Original Message -- From: "Stevens, Jason" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 09 May 2001 14:20:30 -0700 > >I have recently started a position in a rather chaotic CF environment and >wonder if someone could help me with, what I hope, is a simple question. > >We run ColdFusion Server 4.5 on a Sun platform. Whenever we create a .cfm in >Studio and put it on the server the permissions are incorrect. They are >owned by "nobody" rather than the group and id that we need them to be owned >by. Is there a setting I would change to rectify this problem? > >Jason E Stevens >AT&T Wireless >EA Enhancement Team >(425) 829-2293 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Studio registration number
do you have the 4.52 eval installed on the system? It should see that and install over it. This is what I did. Tom - Original Message - From: "CF-Talk (SD Solutions)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 3:40 AM Subject: Re: CF-Studio registration number > o.k. Now I understand your point. > When I do this I get the message: > "This update requires a prior installation." > And then the installation process is aborting. > So maybe I have to go and get the real CD somewhere. :-) > > Uwe > - Original Message - > From: "Tom Davison" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, May 10, 2001 1:36 AM > Subject: Re: CF-Studio registration number > > > You started with 4.52 eval which will not work if you put the serial number > in, now that you have that installed download the upgrade which is 4.52 also > but now you can put the serial number in... hope this clears up any > confusion. > > Tom > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, May 09, 2001 3:58 PM > Subject: AW: CF-Studio registration number > > > > As I said, I started with 4.5.2 right from the beginning. > > So your suggestion doesn't make sense. > > But thank you anyway. > > > > Uwe > > > > -Ursprüngliche Nachricht- > > Von: Tom Davison [mailto:[EMAIL PROTECTED]] > > Gesendet: Mittwoch, 9. Mai 2001 01:06 > > An: CF-Talk > > Betreff: Re: CF-Studio registration number > > > > > > You should now download the upgrade to 4.5 and install that and put in the > > reg key. > > > > Tom > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, May 08, 2001 4:58 PM > > Subject: AW: CF-Studio registration number > > > > > > > No, that hasn't been the case. > > > I tried that already earlier too. > > > With no success. > > > > > > Uwe > > > > > > > > > -Ursprüngliche Nachricht- > > > Von: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > > Gesendet: Dienstag, 8. Mai 2001 15:32 > > > An: CF-Talk > > > Betreff: RE: CF-Studio registration number > > > > > > > > > just enter the serial number when you install it. > > > > > > you can uninstall and reinstall with the number. > > > > > > -Original Message- > > > From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, May 08, 2001 5:13 AM > > > To: CF-Talk > > > Subject: CF-Studio registration number > > > > > > > > > Hi, is there a way to fill in the registration number > > > of a CF 4.5.2 Studio EVAL-Version later after installation ? > > > I downloaded it because I couldn't find my original CF-Studio-CD. > > > I looked in the registry but I couldn't find anything concerning a > > > registration number. Thanks for ideas. > > > > > > Uwe > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert query inserting a record into multiple tables
Ok, thanks for your help. My curiosity is satisfied. Cheers, Darren -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:49 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables There is another way.. You could insert the data into one of the tables and then have an insert trigger on that table which automatically inserts the same data into the second table. However you can only do this if every time you insert into table 1 you want the same data to go into table 2 (which I'm not sure you'd ever want to do). Even though you are only wrting 1 sql statement yourself it is still 2 SQL staements that are executing. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:41 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables So there is no way to do it in one query then ? I have done it in two already but, it's just one of those burning questions I had to ask *L* Thanks, -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:19 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables Sure insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:21 AM To: CF-Talk Subject: Insert query inserting a record into multiple tables Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Post-Spectra Content Management Systems??
I'm sure this has been discussed already, so apologies up front. We are a web co that has been developing Spectra apps for our clients mainly because of its content management (CM) functionality. With the demise of Spectra, does anyone know of a reliable and robust ColdFusion CMS that is commercially available? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Uploading a file
Thanks for all your help. It was indeed a server problem. We have about 5 sites on one server ; (. We have ported site to a dedicated server and all is now well. Thanks guys. Nick. -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 10:11 To: CF-Talk Subject: RE: Uploading a file ACCEPT is an optional attribute that exists to exclude any file types not listed in that parameter. Leaving it out should not affect the upload. If you are uploading through a form have you set the correct MIME type in the form's ENCTYPE attribute? Tristram Charnley -- Allaire Certified ColdFusion Developer e-mail: [EMAIL PROTECTED] > -Original Message- > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > Sent: 09 May 2001 16:41 > To: CF-Talk > Subject: RE: Uploading a file > > > you are missing the accept paramater, > > destination="#application.root#jobdescriptionDocs\" > ACCEPT="mime_type/file_type"> > > > This could very well be your problem, I think the mime type > for Word docs is > "application/ms-word" > > -Original Message- > From: Nick Betts [mailto:[EMAIL PROTECTED]] > Sent: 08 May 2001 17:41 > To: CF-Talk > Subject: Uploading a file > > > Hi, > I am trying to upload a file on a server using CFFILE. All is well in > development, however on live server I get the following error: > > Error Occurred While Processing Request > Error Diagnostic Information > Request canceled or ignored by serverServer busy or unable to fulfill > request. The server is unable to fulfill your request due to > extremely high > traffic or an unexpected internal error. Please attempt your > request again > (if you are repeatedly unsuccessful you should notify the site > administrator). (Location Code: 26) > > The code I use to upload file is: > destination="#application.root#jobdescriptionDocs\"> > > > Is this error simply a server problem or is it to do with CFFILE. > > Cheers, > Nick. > > > > -Original Message- > From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] > Sent: 08 May 2001 17:16 > To: CF-Talk > Subject: RE: CFFILE > > > I don't think it is a permission problem. I set the permission on the > folder to everyone and still received the same error. It may > be a network > problem. When I upload the file to my hard drive destination > path="c:\" It > works. Any other path on my server returns the same error. Please > advise... > -- > -- > > Error Diagnostic Information > Error processing CFFILE > > The directory specified in the DESTINATION attribute of the > CFFILE tag (g:\) > is not valid. The directory either does not exist or is not > accessible by > the ColdFusion service. > > The error occurred while processing an element with a general > identifier of > (CFFILE), occupying document position (21:1) to (24:33). > > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 08, 2001 11:48 AM > To: CF-Talk > Subject: Re: CFFILE > > > If you are using UNC paths then you need to run CF under a > user account with > rights to the folder on the other server. By default, > CF runs under the system account. You can change this in the > NT Services > applet. > > HTH, > > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. > www.CoolFusion.com > 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > > > - Original Message - > From: "Foggy, Doreen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, May 08, 2001 11:43 AM > Subject: CFFILE > > > > Error Diagnostic Information > > Error processing CFFILE > > The directory specified in the DESTINATION attribute of the > CFFILE tag > > chh-test\www\lmts_int\cic is not valid. The directory > either does not > exist > > or is not accessible by the ColdFusion service. > > The error occurred while processing an element with a > general identifier > of > > (CFFILE), occupying document position > > > > > > I am using the CFFILE tag for the first time and I am > running into some > > problems. Please Help! The directory does exist and I am > not sure what > > accessible by the ColdFuison service means. The directory > is located on > the > > web server. > > * I have two forms > > * upload.cfm (html form) > > * uploadfile.cfm (action page) > > > > The syntax for both is located below: > > > > Upload.cfm > > WebStar: Contracts Online > > > > link="Silver" > > vlink="Yellow" alink="White"> > > border="0" alt=""> > > > > ENCTYPE="multipart/form-data"METHOD=POST> > >> border="0"> > > > > File to upload: > > > > > > > > > > > > File Destination: > > > >> value="\\chh-test\www\lmts_int\cic" size="50"> > > > > > > > > > > > > > >
Re: Replace #'s Function!!
that's what I use. very efficient for replacing long texts and html/cfm code on the fly/ Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Studio registration number
Yes. I have 4.5.2 EVAL Although it might not work on Win2000, does it ? Did you try it on Win2000 ? Uwe - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 3:04 PM Subject: Re: CF-Studio registration number do you have the 4.52 eval installed on the system? It should see that and install over it. This is what I did. Tom - Original Message - From: "CF-Talk (SD Solutions)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 3:40 AM Subject: Re: CF-Studio registration number > o.k. Now I understand your point. > When I do this I get the message: > "This update requires a prior installation." > And then the installation process is aborting. > So maybe I have to go and get the real CD somewhere. :-) > > Uwe > - Original Message - > From: "Tom Davison" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, May 10, 2001 1:36 AM > Subject: Re: CF-Studio registration number > > > You started with 4.52 eval which will not work if you put the serial number > in, now that you have that installed download the upgrade which is 4.52 also > but now you can put the serial number in... hope this clears up any > confusion. > > Tom > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, May 09, 2001 3:58 PM > Subject: AW: CF-Studio registration number > > > > As I said, I started with 4.5.2 right from the beginning. > > So your suggestion doesn't make sense. > > But thank you anyway. > > > > Uwe > > > > -Ursprüngliche Nachricht- > > Von: Tom Davison [mailto:[EMAIL PROTECTED]] > > Gesendet: Mittwoch, 9. Mai 2001 01:06 > > An: CF-Talk > > Betreff: Re: CF-Studio registration number > > > > > > You should now download the upgrade to 4.5 and install that and put in the > > reg key. > > > > Tom > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, May 08, 2001 4:58 PM > > Subject: AW: CF-Studio registration number > > > > > > > No, that hasn't been the case. > > > I tried that already earlier too. > > > With no success. > > > > > > Uwe > > > > > > > > > -Ursprüngliche Nachricht- > > > Von: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > > Gesendet: Dienstag, 8. Mai 2001 15:32 > > > An: CF-Talk > > > Betreff: RE: CF-Studio registration number > > > > > > > > > just enter the serial number when you install it. > > > > > > you can uninstall and reinstall with the number. > > > > > > -Original Message- > > > From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, May 08, 2001 5:13 AM > > > To: CF-Talk > > > Subject: CF-Studio registration number > > > > > > > > > Hi, is there a way to fill in the registration number > > > of a CF 4.5.2 Studio EVAL-Version later after installation ? > > > I downloaded it because I couldn't find my original CF-Studio-CD. > > > I looked in the registry but I couldn't find anything concerning a > > > registration number. Thanks for ideas. > > > > > > Uwe > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Studio registration number
No I did not do it on 2000, I have NT 4.0 workstation. Sorry that it don't work for you. Tom - Original Message - From: "CF-Talk (SD Solutions)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 8:27 AM Subject: Re: CF-Studio registration number > Yes. I have 4.5.2 EVAL > Although it might not work on Win2000, does it ? > Did you try it on Win2000 ? > > Uwe > - Original Message - > From: "Tom Davison" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, May 10, 2001 3:04 PM > Subject: Re: CF-Studio registration number > > > do you have the 4.52 eval installed on the system? It should see that and > install over it. This is what I did. > > Tom > - Original Message - > From: "CF-Talk (SD Solutions)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, May 10, 2001 3:40 AM > Subject: Re: CF-Studio registration number > > > > o.k. Now I understand your point. > > When I do this I get the message: > > "This update requires a prior installation." > > And then the installation process is aborting. > > So maybe I have to go and get the real CD somewhere. :-) > > > > Uwe > > - Original Message - > > From: "Tom Davison" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, May 10, 2001 1:36 AM > > Subject: Re: CF-Studio registration number > > > > > > You started with 4.52 eval which will not work if you put the serial > number > > in, now that you have that installed download the upgrade which is 4.52 > also > > but now you can put the serial number in... hope this clears up any > > confusion. > > > > Tom > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, May 09, 2001 3:58 PM > > Subject: AW: CF-Studio registration number > > > > > > > As I said, I started with 4.5.2 right from the beginning. > > > So your suggestion doesn't make sense. > > > But thank you anyway. > > > > > > Uwe > > > > > > -Ursprüngliche Nachricht- > > > Von: Tom Davison [mailto:[EMAIL PROTECTED]] > > > Gesendet: Mittwoch, 9. Mai 2001 01:06 > > > An: CF-Talk > > > Betreff: Re: CF-Studio registration number > > > > > > > > > You should now download the upgrade to 4.5 and install that and put in > the > > > reg key. > > > > > > Tom > > > - Original Message - > > > From: <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 08, 2001 4:58 PM > > > Subject: AW: CF-Studio registration number > > > > > > > > > > No, that hasn't been the case. > > > > I tried that already earlier too. > > > > With no success. > > > > > > > > Uwe > > > > > > > > > > > > -Ursprüngliche Nachricht- > > > > Von: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > > > Gesendet: Dienstag, 8. Mai 2001 15:32 > > > > An: CF-Talk > > > > Betreff: RE: CF-Studio registration number > > > > > > > > > > > > just enter the serial number when you install it. > > > > > > > > you can uninstall and reinstall with the number. > > > > > > > > -Original Message- > > > > From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, May 08, 2001 5:13 AM > > > > To: CF-Talk > > > > Subject: CF-Studio registration number > > > > > > > > > > > > Hi, is there a way to fill in the registration number > > > > of a CF 4.5.2 Studio EVAL-Version later after installation ? > > > > I downloaded it because I couldn't find my original CF-Studio-CD. > > > > I looked in the registry but I couldn't find anything concerning a > > > > registration number. Thanks for ideas. > > > > > > > > Uwe > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
I spent 20 mins looking around trying to find information on the 'demise' of Specta and did not find a thing. I am curious where you obtained this information, as far as I can tell Spectra is still a completely viable product. Chris -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:05 AM To: CF-Talk Subject: Post-Spectra Content Management Systems?? I'm sure this has been discussed already, so apologies up front. We are a web co that has been developing Spectra apps for our clients mainly because of its content management (CM) functionality. With the demise of Spectra, does anyone know of a reliable and robust ColdFusion CMS that is commercially available? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
Steve, Are you aware that spectra is not going to be dead entirely It may not be available commercially, but it will be being supported by Macromedia on Open Source for, I believe, the next two years. If you want to see the email that Charles Teague sent out with regards Macromedia's change of stance with Spectra go to the Northern UK ColdFusion User Group Website, where I've posted it for all to see. http://www.cfug.org.uk/ Regards Stephen > -Original Message- > From: Steve Vosloo [mailto:[EMAIL PROTECTED]] > Sent: 10 May 2001 14:05 > To: CF-Talk > Subject: Post-Spectra Content Management Systems?? > > > I'm sure this has been discussed already, so apologies up front. > > We are a web co that has been developing Spectra apps for our > clients mainly > because of its content management (CM) functionality. With the demise of > Spectra, does anyone know of a reliable and robust ColdFusion CMS that is > commercially available? > > Thanks > Steve > > > > Development Manager > Vardus Internet Solutions (SA) > > Tel: (+27) 21 670 9880 > Fax: (+27) 21 674 4549 > > Email: [EMAIL PROTECTED] > Website: www.vardus.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
have you had your head buried in the sand recently?! Spectra is being discontinued after the next maintenance release [1.5.1] that will be final release, it will be supported by Macromedia for 2 years and then its finito. Some of its core services will be ported into the nect generation CF server. hope this helps. Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
This was posted by Charles Teague on the Spectra Forum. Hi everyone. We really appreciate everyone's patience over the last few weeks. There has been a lot of discussion and concern over the future of Spectra, and I think that the time is right to shed some light on what we are thinking. As you know, Spectra provides developers with a broad set of functionality and technology. Enough so, sometimes its breadth proves daunting. Fundamental to the entire product, however, is its foundation - the content object API. In 1996, when I first started working on Allaire's website, the foundational change that I went through was around thinking about the site as composed of 'content objects.' Over the last 5 years, this core concept has been revised, revolutionized, improved, and expanded. Spectra has been the product that carried this concept forward. This concept, and the content object API, have been the most compelling pieces of Spectra since its inception. Macromedia's goal is to make dynamic content technology like the content object API pervasive, approachable, and cost effective for our developers. To help us better achieve this, we plan to incorporate key components of Spectra technology - a Java-based version of the COAPI architecture and other services directly related to dynamic content - into the application server, as well as delivering next generation dynamic content technologies such as end-user content contribution and team production through a series of new product initiatives. This means that version 1.5 will be Spectra's last feature additive release - we'll invest our resources in making the core technology that we move into our application server and visual tools faster, easier, and better. Macromedia will continue to support Spectra via a community source model, on-going technical support, training, and consulting, as well as having a team of engineers working on bug fixes and quality assurance for community source submissions. Spectra will continue to be offered for sale, using our partners as the primary sales channel. We also will do our best to give you early access to technology previews, alphas, and betas of the new technologies already under development. In the world we live and work in, technology changes constantly, we've all thrived because of our ability to adapt to change. This is no different - a change for the Spectra Product Group, and for every developer, customer and partner out there who has invested their valuable time and mind share into Spectra. While I understand the challenge that a change like this can pose, I am extremely optimistic. The core vision of the Spectra technology is compelling - the opportunity to make this technology available to more developers, cheaper, and better, is a chance that I relish. I hope you share my optimism through this time of change ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Post-Spectra Content Management Systems??
Macromedia has announced that Spectra 1.5 will be the last release to the product. They will continue to sell and support Spectra 1.5 for two years, and will then roll it over to a community supported product that I would suspect would be akin to how the Allaire's Forums product went. As for alternatives, we're taking a very close look at CommonSpot 2.0 by PaperThin ( www.paperthin.com ). I believe that they're close to launching a v2.5 if I understood correctly. At any rate, from what we've seen so far, it's more mature and user friendly than Spectra was. Tomorrow and Monday, we'll be having a couple of demos with them. Email me off list and I'll be glad to give you my impressions then. Dave - Original Message - From: "Chris Maloney" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 9:42 AM Subject: RE: Post-Spectra Content Management Systems?? I spent 20 mins looking around trying to find information on the 'demise' of Specta and did not find a thing. I am curious where you obtained this information, as far as I can tell Spectra is still a completely viable product. Chris -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:05 AM To: CF-Talk Subject: Post-Spectra Content Management Systems?? I'm sure this has been discussed already, so apologies up front. We are a web co that has been developing Spectra apps for our clients mainly because of its content management (CM) functionality. With the demise of Spectra, does anyone know of a reliable and robust ColdFusion CMS that is commercially available? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
Thanks...I finally came across that email, but from what I could tell there was nothing on the Allaire/Macromedia site about it which seems a little odd to me. Chris -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:59 AM To: CF-Talk Subject: RE: Post-Spectra Content Management Systems?? This was posted by Charles Teague on the Spectra Forum. . Hi everyone. We really appreciate everyone's patience over the last few weeks. There has been a lot of discussion and concern over the future of Spectra, and I think that the time is right to shed some light on what we are thinking. As you know, Spectra provides developers with a broad set of functionality and technology. Enough so, sometimes its breadth proves daunting. Fundamental to the entire product, however, is its foundation - the content object API. In 1996, when I first started working on Allaire's website, the foundational change that I went through was around thinking about the site as composed of 'content objects.' Over the last 5 years, this core concept has been revised, revolutionized, improved, and expanded. Spectra has been the product that carried this concept forward. This concept, and the content object API, have been the most compelling pieces of Spectra since its inception. Macromedia's goal is to make dynamic content technology like the content object API pervasive, approachable, and cost effective for our developers. To help us better achieve this, we plan to incorporate key components of Spectra technology - a Java-based version of the COAPI architecture and other services directly related to dynamic content - into the application server, as well as delivering next generation dynamic content technologies such as end-user content contribution and team production through a series of new product initiatives. This means that version 1.5 will be Spectra's last feature additive release - we'll invest our resources in making the core technology that we move into our application server and visual tools faster, easier, and better. Macromedia will continue to support Spectra via a community source model, on-going technical support, training, and consulting, as well as having a team of engineers working on bug fixes and quality assurance for community source submissions. Spectra will continue to be offered for sale, using our partners as the primary sales channel. We also will do our best to give you early access to technology previews, alphas, and betas of the new technologies already under development. In the world we live and work in, technology changes constantly, we've all thrived because of our ability to adapt to change. This is no different - a change for the Spectra Product Group, and for every developer, customer and partner out there who has invested their valuable time and mind share into Spectra. While I understand the challenge that a change like this can pose, I am extremely optimistic. The core vision of the Spectra technology is compelling - the opportunity to make this technology available to more developers, cheaper, and better, is a chance that I relish. I hope you share my optimism through this time of change ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
I saw a demo of commonspot and was very impressed with its functionality however the $$$ were pretty high. Rich -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 9:53 AM To: CF-Talk Subject: Re: Post-Spectra Content Management Systems?? Macromedia has announced that Spectra 1.5 will be the last release to the product. They will continue to sell and support Spectra 1.5 for two years, and will then roll it over to a community supported product that I would suspect would be akin to how the Allaire's Forums product went. As for alternatives, we're taking a very close look at CommonSpot 2.0 by PaperThin ( www.paperthin.com ). I believe that they're close to launching a v2.5 if I understood correctly. At any rate, from what we've seen so far, it's more mature and user friendly than Spectra was. Tomorrow and Monday, we'll be having a couple of demos with them. Email me off list and I'll be glad to give you my impressions then. Dave - Original Message - From: "Chris Maloney" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 9:42 AM Subject: RE: Post-Spectra Content Management Systems?? I spent 20 mins looking around trying to find information on the 'demise' of Specta and did not find a thing. I am curious where you obtained this information, as far as I can tell Spectra is still a completely viable product. Chris -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:05 AM To: CF-Talk Subject: Post-Spectra Content Management Systems?? I'm sure this has been discussed already, so apologies up front. We are a web co that has been developing Spectra apps for our clients mainly because of its content management (CM) functionality. With the demise of Spectra, does anyone know of a reliable and robust ColdFusion CMS that is commercially available? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database sorting
I have a conference database with a text field for time. The times are entered in 12 hour time with am or pm (ex., 9:00 am or 2:00 pm). Is there a way to sort this field to list the conferences in order by time? The problem I see, is 2 comes before 9, so the above example will list the 2:00 pm time before the 9:00 am time. I'd like to do this without changing the actual database if possible. The code I use to list the times is (it displys a table with the current weeks worth of conferences): #dateformat(dateadd("d", i, url.startdate), "ddd, mmm d")# SELECT ID, conf_name, begin_time, conf_date FROM data WHERE conf_date = #createodbcdate(dateadd("d", i, url.startdate))# ORDER BY begin_time #qGetDates.begin_time# #qGetDates.conf_name# This works, except that the conferences are listed in the order they are in the database, not time order. Thanks, Tim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
Although Spectra will be supported for the next 2 years, I'm sure as hell not going to sell it clients now - I'm simply looking for another solution. And it's probably only a 1-2 year solution as CF 6 will have Spectra's CODB etc built in. I'm gonna check out CommonSpot 2.0, or as Neil recommends, probably just write one from scratch. Thanks for the replies. > -Original Message- > From: Chris Maloney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 4:04 PM > To: CF-Talk > Subject: RE: Post-Spectra Content Management Systems?? > > > Thanks...I finally came across that email, but from what I could > tell there > was nothing on the Allaire/Macromedia site about it which seems a > little odd > to me. > > Chris > > -Original Message- > From: Neil Clark [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 8:59 AM > To: CF-Talk > Subject: RE: Post-Spectra Content Management Systems?? > > > This was posted by Charles Teague on the Spectra Forum. > > . > Hi everyone. We really appreciate everyone's patience over the last few > weeks. There has been a lot of discussion and concern over the future of > Spectra, and I think that the time is right to shed some light on what we > are thinking. > > As you know, Spectra provides developers with a broad set of functionality > and technology. Enough so, sometimes its breadth proves daunting. > Fundamental to the entire product, however, is its foundation - > the content > object API. In 1996, when I first started working on Allaire's > website, the > foundational change that I went through was around thinking about the site > as composed of 'content objects.' Over the last 5 years, this core concept > has been revised, revolutionized, improved, and expanded. Spectra has been > the product that carried this concept forward. This concept, and > the content > object API, have been the most compelling pieces of Spectra since its > inception. > > Macromedia's goal is to make dynamic content technology like the content > object API pervasive, approachable, and cost effective for our developers. > To help us better achieve this, we plan to incorporate key components of > Spectra technology - a Java-based version of the COAPI architecture and > other services directly related to dynamic content - into the application > server, as well as delivering next generation dynamic content technologies > such as end-user content contribution and team production through a series > of new product initiatives. This means that version 1.5 will be Spectra's > last feature additive release - we'll invest our resources in making the > core technology that we move into our application server and visual tools > faster, easier, and better. > > Macromedia will continue to support Spectra via a community source model, > on-going technical support, training, and consulting, as well as having a > team of engineers working on bug fixes and quality assurance for community > source submissions. Spectra will continue to be offered for sale, > using our > partners as the primary sales channel. We also will do our best > to give you > early access to technology previews, alphas, and betas of the new > technologies already under development. > > In the world we live and work in, technology changes constantly, we've all > thrived because of our ability to adapt to change. This is no > different - a > change for the Spectra Product Group, and for every developer, > customer and > partner out there who has invested their valuable time and mind share into > Spectra. While I understand the challenge that a change like this > can pose, > I am extremely optimistic. The core vision of the Spectra technology is > compelling - the opportunity to make this technology available to more > developers, cheaper, and better, is a chance that I relish. I > hope you share > my optimism through this time of change > > Neil Clark > Senior Web Applications Engineer > Spectra / ColdFusion / XML / Cerebro > MCB Digital > Macromedia Alliance Member > Tel: 020 8941 3232 > Fax: 020 8941 4333 > Mobile : 077719 448 227 > e-mail: [EMAIL PROTECTED] > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF component for secure FTP
Hi all, Does anyone know of CF component that will do secure FTP using SSH2? Thanks, Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Tools for developers: http://developer.perthweb.com.au -- cfx_pwimageproc: image processing tool -- cfx_pwcardcrypt: credit card validation and encryption Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
insert problem
i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF dynamic pages for Search Engines
Could someone direct me to a source that describes how the major search engines handle dynamic pages, query strings,etc within a coldfusion site ? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
can you post all the error code? Check the field to make sure you are able to use decimals for one. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:23 PM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
Nope, no comma there, "Incorrect syntax near '110.00'." would lead me to guess that you have INSERT INTO Table (Price) values ('#price#')... see if there are quotes around your field name and if there are, remove them. HTH Hatton > -Original Message- > From: Metzy Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 1:23 PM > To: CF-Talk > Subject: insert problem > > > i'm trying to same a number that has been formatted as dollar amount > > if i have an amount that is $1,110.00 it's telling that i have an error > i'm pretty sure that it is because i'm trying to save and the number is > being placed with a comma in it. how can i work around this. > > > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect > syntax near > '110.00'. > > > > The error occurred while processing an element with a general > identifier of > (CFQUERY), occupying document position (367:2) to (367:63). > > > Date/Time: 05/10/01 10:08:17 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
Replace("1,110.00", ",", "", "ALL") or Replace(thevar, ",", "", "ALL") if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
what is the field type that is receiving the amount?if it's a charachter field then you are ok. If not then you will have to remove all comma before passing to the SQL string -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 18:23 To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Update problem
I am showing information in columns. Each column represents a different quarter. We need the user to do an update every quarter. To achieve this look I used the code: #Skill# #GetSubjects.GradeForSubject# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#GradesID# What is happening is that it is only updating the 1st entry- and putting all the variables in that first column! (with a comma delimiter). as a test I added the primary key to the columns - that shows up in the number correctly so it looks like they are corresponding correctly, but the update button will plunk it into the first variable onlyany ideas? Thanks for the brain power. j Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JS:URL Parameter in window.open
does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure in request scope
A request scope variable must be re-set for each page load - that's how request variables work. You could do this which would run this query at the internal indicated by the cachedwithin attribute; if between query runs the CF server would just look at the most recent query results and put those in the request variable. -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 2:00 AM To: CF-Talk Subject: structure in request scope Could someone tell me how to load a structure into the request scope in the application.cfm once only when a user first visits a page. That is, check that the structure is there and dont rerun the query code if it is unless a change has been made to the database. Its for the colour scheme of a site. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post-Spectra Content Management Systems??
I'm looking at eMPower by http://www.ektron.com/web-content-management-software.cfm to fill in some of the gaps. The are the guys that make the eWebEditPro HTML editor that's inside of Spectra. -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:13 AM To: CF-Talk Subject: RE: Post-Spectra Content Management Systems?? Although Spectra will be supported for the next 2 years, I'm sure as hell not going to sell it clients now - I'm simply looking for another solution. And it's probably only a 1-2 year solution as CF 6 will have Spectra's CODB etc built in. I'm gonna check out CommonSpot 2.0, or as Neil recommends, probably just write one from scratch. Thanks for the replies. > -Original Message- > From: Chris Maloney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 4:04 PM > To: CF-Talk > Subject: RE: Post-Spectra Content Management Systems?? > > > Thanks...I finally came across that email, but from what I could > tell there > was nothing on the Allaire/Macromedia site about it which seems a > little odd > to me. > > Chris > > -Original Message- > From: Neil Clark [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 8:59 AM > To: CF-Talk > Subject: RE: Post-Spectra Content Management Systems?? > > > This was posted by Charles Teague on the Spectra Forum. > > . > Hi everyone. We really appreciate everyone's patience over the last few > weeks. There has been a lot of discussion and concern over the future of > Spectra, and I think that the time is right to shed some light on what we > are thinking. > > As you know, Spectra provides developers with a broad set of functionality > and technology. Enough so, sometimes its breadth proves daunting. > Fundamental to the entire product, however, is its foundation - > the content > object API. In 1996, when I first started working on Allaire's > website, the > foundational change that I went through was around thinking about the site > as composed of 'content objects.' Over the last 5 years, this core concept > has been revised, revolutionized, improved, and expanded. Spectra has been > the product that carried this concept forward. This concept, and > the content > object API, have been the most compelling pieces of Spectra since its > inception. > > Macromedia's goal is to make dynamic content technology like the content > object API pervasive, approachable, and cost effective for our developers. > To help us better achieve this, we plan to incorporate key components of > Spectra technology - a Java-based version of the COAPI architecture and > other services directly related to dynamic content - into the application > server, as well as delivering next generation dynamic content technologies > such as end-user content contribution and team production through a series > of new product initiatives. This means that version 1.5 will be Spectra's > last feature additive release - we'll invest our resources in making the > core technology that we move into our application server and visual tools > faster, easier, and better. > > Macromedia will continue to support Spectra via a community source model, > on-going technical support, training, and consulting, as well as having a > team of engineers working on bug fixes and quality assurance for community > source submissions. Spectra will continue to be offered for sale, > using our > partners as the primary sales channel. We also will do our best > to give you > early access to technology previews, alphas, and betas of the new > technologies already under development. > > In the world we live and work in, technology changes constantly, we've all > thrived because of our ability to adapt to change. This is no > different - a > change for the Spectra Product Group, and for every developer, > customer and > partner out there who has invested their valuable time and mind share into > Spectra. While I understand the challenge that a change like this > can pose, > I am extremely optimistic. The core vision of the Spectra technology is > compelling - the opportunity to make this technology available to more > developers, cheaper, and better, is a chance that I relish. I > hope you share > my optimism through this time of change > > Neil Clark > Senior Web Applications Engineer > Spectra / ColdFusion / XML / Cerebro > MCB Digital > Macromedia Alliance Member > Tel: 020 8941 3232 > Fax: 020 8941 4333 > Mobile : 077719 448 227 > e-mail: [EMAIL PROTECTED] > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
Bit masks are cool, but remember that there is a limit to how much info you can pack in a bitmask because CF doesn't let you use the bit functions on anything of more than 32 bits. I have taken to using lists for this sort of thing because there's no practical limit to how many items it can contain and there are lots of useful list functions in CF. -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:54 PM To: CF-Talk Subject: Bit Masks Hello! I believe that someone once gave a presentation at one of the CFUGs about using bit masks, also know as Right Bit AND, to set up security access levels. This wasn't the same as the presentation at the Fig Leaf site that's slight more oriented towards hierarchy uses. I've looked at all the CFUG sites linked to from the Allaire site but I can't find the presentation. Does anyone recall where the presentation was made and/or how to get the presentation file? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update problem
Can you include the call to the GetSubjects query too... -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:32 To: CF-Talk Subject: Update problem I am showing information in columns. Each column represents a different quarter. We need the user to do an update every quarter. To achieve this look I used the code: #Skill# #GetSubjects.GradeForSubject# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#GradesID# What is happening is that it is only updating the 1st entry- and putting all the variables in that first column! (with a comma delimiter). as a test I added the primary key to the columns - that shows up in the number correctly so it looks like they are corresponding correctly, but the update button will plunk it into the first variable onlyany ideas? Thanks for the brain power. j Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: structure in request scope
On 5/10/01 1:59 AM Mark Ireland wrote: > Could someone tell me how to load a structure into the request scope in the > application.cfm > > once only when a user first visits a page. That is, check that the > structure is there and dont rerun the query code if it is > > unless a change has been made to the database. It sounds like you want to put the structure into a persistent scope, which request is not. Use the application scope instead if it is global to all users. If not, client or session scope. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Internal Server Error
We just set up a Windows 2000 Advanced Server with ColdFusion 4.5.1 SP2 and cannot get any cfm files to work, it always gives me an Error 500 - Internal Server Error. Does this for asp pages also. I did not set up the machine, so figure the guy that did messed with some setting to mess this up, I have set up computers with similar configurations and have never had this problem before. Any ideas why this is happening? I cannot find any setting that fixes this problem. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Download Software From The CF Server
What is the best way to set up a process so that clients can download software from the CF server? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Post-Spectra Content Management Systems??
Ektron's eMPower is pretty slick, and uses the same WYSYIWYG as Spectra (Ektron's eWebEditPro) http://www.ektron.com -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Steve Vosloo wrote: > I'm sure this has been discussed already, so apologies up front. > > We are a web co that has been developing Spectra apps for our clients mainly > because of its content management (CM) functionality. With the demise of > Spectra, does anyone know of a reliable and robust ColdFusion CMS that is > commercially available? > > Thanks > Steve > > Development Manager > Vardus Internet Solutions (SA) > > Tel: (+27) 21 670 9880 > Fax: (+27) 21 674 4549 > > Email: [EMAIL PROTECTED] > Website: www.vardus.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: URL Parameter in window.open
That should work fine but if you intend to send through CF variables then you need to wrap it in a CFOUTPUT. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:40 To: CF-Talk Subject: JS:URL Parameter in window.open does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
Please excuse my inaccurate response, I wasn't fully thinking... Hatton > -Original Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 10:30 AM > To: CF-Talk > Subject: RE: insert problem > > > Nope, no comma there, "Incorrect syntax near '110.00'." would lead me to > guess that you have > > INSERT INTO Table (Price) values ('#price#')... see if there are quotes > around your field name and if there are, remove them. > > HTH > Hatton > > > -Original Message- > > From: Metzy Martinez [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 10, 2001 1:23 PM > > To: CF-Talk > > Subject: insert problem > > > > > > i'm trying to same a number that has been formatted as dollar amount > > > > if i have an amount that is $1,110.00 it's telling that i have an error > > i'm pretty sure that it is because i'm trying to save and the number is > > being placed with a comma in it. how can i work around this. > > > > > > Error Diagnostic Information > > ODBC Error Code = 37000 (Syntax error or access violation) > > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect > > syntax near > > '110.00'. > > > > > > > > The error occurred while processing an element with a general > > identifier of > > (CFQUERY), occupying document position (367:2) to (367:63). > > > > > > Date/Time: 05/10/01 10:08:17 > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Internal Server Error
fdisk > -Original Message- > From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] > Sent: 10 May 2001 15:55 > To: CF-Talk > Subject: Internal Server Error > > > We just set up a Windows 2000 Advanced Server with > ColdFusion 4.5.1 SP2 and cannot get any cfm files to > work, it always gives me an Error 500 - Internal > Server Error. Does this for asp pages also. I did > not set up the machine, so figure the guy that did > messed with some setting to mess this up, I have set > up computers with similar configurations and have > never had this problem before. Any ideas why this is > happening? I cannot find any setting that fixes this problem. > > = > Bernd VanSkiver > [EMAIL PROTECTED] > ColdFusion Developer > ICQ UIN: 916324 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
I tried doing a replace but i still get the same output I'm doing this before i save. my field type is money. there are no quotes on my field Update product Set sectionID = #sectionID#, productName = '#productName#', description = '#description#', manufacturer = '#manufacturer#', manufURL = '#manufURL#', imageName = '#imageName#', thumbName = '#thumbName#', printName = '#printName#', price = #price#, salePrice = #salePrice# Where productID = #productID# #Replace("price", ",", "", "ALL")# #price# #Replace("salePrice", ",", "", "ALL")# #salePrice# price $45.50 salePrice $111,110.00 Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (377:2) to (377:63). Date/Time: 05/10/01 11:20:05 .. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:29 AM To: CF-Talk Subject: RE: insert problem Replace("1,110.00", ",", "", "ALL") or Replace(thevar, ",", "", "ALL") if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY max. timeout?
Anybody know what the CFQUERY maximum timeout value is? It seems to be driver-dependent; we're running Oracle Native Drivers on CF 4.5. SP2. thanks, Chris Norloff from the online help: TIMEOUT Optional. Lets you specify a maximum number of milliseconds for the query to execute before returning an error indicating that the query has timed-out. This attribute is not supported by most ODBC drivers. TIMEOUT is supported by the SQL Server 6.x or above driver. The minimum and maximum allowable values vary, depending on the driver. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
stored procedure problem
Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Data Integrity - Q of the Day
Here's a question that's been bothersome for some time. We have an interface where participants register for meeting. There is a form they fill out with basic information, including the pharmaceutical company they are associated with. We use drop downs where we can to keep data as constant as possible, but we cannot use dropdowns for the company they are with as there are far too many to compile and list. And therein lies our problem. Users from one company can have a half dozen different ways to spell their company name. There is an admin search page where an administrator can search for registered users by several different criteria, one of which is the user's company name. I dynamically build a drop down for this field on the search page by pulling all distinct company names from the db. Of course, there are several different variations of the company name in the dropdown, which makes it very cumbersome. Has anyone had to deal with this? If so, how did you deal with it? And/or does someone have an idea on how to go about dealing with it? Erika (with a *K*) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Code Snippet:Random Password Generator(repost)
> > Why define the alphabet? Just use decimal values for the > asci char set. Ok here's another code snippet, this is a password gen that I use now and then. The slight advantage of this one is it creates a word which hopefully more rememberable than just random letters and numbers. There's more than one occurrence of some letters to tip the odds towards those. --- #password# - Hope this helps someone. Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: URL Parameter in window.open
oh! oh! I know the answer to this one! :) I did this already..hang on lemme get the code here.. ok! Go to www.opentelecom.com and click Send E page. and do a View Source on that page ^_^ Its all there. But just in case the site is down or somethign here is the relevant code: function OpenPage() { window.open('sendpage.cfm?name='+ document.selectcustomer.name.value + '&message=' + document.selectcustomer.message.value + '&email=' +document.selectcustomer.email.value,'paging','scrollbars=auto,menu=no,heigh t=80,width=600') } //--> And here is the form: Took me a morning to hunt down and debug the syntax on this one :) But it looks rather nice. -Gel -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure problem
do the same thing... use [brackets ] ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:44 AM To: CF-Talk Subject: stored procedure problem Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure problem
you should be able to do the same thing. It's not the VB that interprets the brackets it's the SQL itself. I assume you are passing in a field list into a SP as a param so you know what fields to update?just put brackets around the field names. A P.S. shoot your DBA..before he goes contracting! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 16:44 To: CF-Talk Subject: stored procedure problem Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
I've had problems with using money fields in the past. In fact the last place I worked the DBA's would not allow any fileds of type money at all. Can you get away with using an integer field? Jusat a poinbt to note - you are removing the commas before inserting but are you removing the $'s too? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 19:33 To: CF-Talk Subject: RE: insert problem I tried doing a replace but i still get the same output I'm doing this before i save. my field type is money. there are no quotes on my field Update product Set sectionID = #sectionID#, productName = '#productName#', description = '#description#', manufacturer = '#manufacturer#', manufURL = '#manufURL#', imageName = '#imageName#', thumbName = '#thumbName#', printName = '#printName#', price = #price#, salePrice = #salePrice# Where productID = #productID# #Replace("price", ",", "", "ALL")# #price# #Replace("salePrice", ",", "", "ALL")# #salePrice# price $45.50 salePrice $111,110.00 Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (377:2) to (377:63). Date/Time: 05/10/01 11:20:05 ... -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:29 AM To: CF-Talk Subject: RE: insert problem Replace("1,110.00", ",", "", "ALL") or Replace(thevar, ",", "", "ALL") if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Internal Server Error
Internal server error sometimes means that the permissions are messed up. Try allowing everyone full access to the page, and try again, then work backwards and see how high you can set the permissions and still have it work.. Does anyone know what permissions have to be set for cf to work? Al a1webs.com At 07:54 AM 5/10/2001 -0700, Bernd VanSkiver wrote: >We just set up a Windows 2000 Advanced Server with >ColdFusion 4.5.1 SP2 and cannot get any cfm files to >work, it always gives me an Error 500 - Internal >Server Error. Does this for asp pages also. I did >not set up the machine, so figure the guy that did >messed with some setting to mess this up, I have set >up computers with similar configurations and have >never had this problem before. Any ideas why this is >happening? I cannot find any setting that fixes this problem. > >= >Bernd VanSkiver >[EMAIL PROTECTED] >ColdFusion Developer >ICQ UIN: 916324 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure problem
Rename the column in your query as so: SELECT A OR B as A_OR_B Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:44 AM To: CF-Talk Subject: stored procedure problem Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
Thanks for the list tip! I'm just now developing an application using CF's BitAnd() function. In my application, I currently have the following permission levels: Level UserDescription Permission DB value for BitAnd 1 1 Public - future permission level READ selected pages 2 3 Basic Project Read User Read all pages 4 7 Basic Project Content User Read all, Add/Update selected data 8 15 Project Manager User Read all, Add/Update all 16 31 me ;-) Since a User with a larger permission value must also have the access all Users with lesser permission values do, CF's BitAnd enables only 5 permission levels. I'm concerned the client might come up with additional permission levels/groups in the future, thereby defeating my use of BitAnd, and forcing me to modify code/user database/client database to use a list instead of BitAnd. Or have I missed a clever way to use BitAnd? best, paul PS> It sure helps to ask for help;-) Now that I've done so, I think the simple solution to my problem is not to use BitAnd, but just adopt a sequence of increasing numbers, for example: 5, 10, 15, 20, 25, etc (go by 5's to allow future insertion of new intermediate permission levels), and verify a User's permission is greater than a target. That way, I still only need to store a single number in the database as with BitAnd, and don't need to go to using a list. Any comments? At 10:48 AM 5/10/01 -0400, you wrote: >Bit masks are cool, but remember that there is a limit to how much info you >can pack in a bitmask because CF doesn't let you use the bit functions on >anything of more than 32 bits. I have taken to using lists for this sort of >thing because there's no practical limit to how many items it can contain >and there are lots of useful list functions in CF. > > >-Original Message- >From: Ken Monroe [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, May 09, 2001 4:54 PM >To: CF-Talk >Subject: Bit Masks > > >Hello! > >I believe that someone once gave a presentation at one of the CFUGs about >using bit masks, also know as Right Bit AND, to set up security access >levels. This wasn't the same as the presentation at the Fig Leaf site >that's slight more oriented towards hierarchy uses. I've looked at all the >CFUG sites linked to from the Allaire site but I can't find the >presentation. Does anyone recall where the presentation was made and/or how >to get the presentation file? > >Thx > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Code Snippet:Random Password Generator(repost)
What if it randomly generates a bad word? Erika (with a *K*) -Original Message- From: Daniel Kemp [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:42 AM To: CF-Talk Subject: RE: Code Snippet:Random Password Generator(repost) > > Why define the alphabet? Just use decimal values for the > asci char set. Ok here's another code snippet, this is a password gen that I use now and then. The slight advantage of this one is it creates a word which hopefully more rememberable than just random letters and numbers. There's more than one occurrence of some letters to tip the odds towards those. --- #password# - Hope this helps someone. Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
no no. don't put quotes around price in the Replace function. :) use #Replace(price, ",", "", "ALL")# not #Replace("price", ",", "", "ALL")# -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:33 AM To: CF-Talk Subject: RE: insert problem I tried doing a replace but i still get the same output I'm doing this before i save. my field type is money. there are no quotes on my field Update product Set sectionID = #sectionID#, productName = '#productName#', description = '#description#', manufacturer = '#manufacturer#', manufURL = '#manufURL#', imageName = '#imageName#', thumbName = '#thumbName#', printName = '#printName#', price = #price#, salePrice = #salePrice# Where productID = #productID# #Replace("price", ",", "", "ALL")# #price# #Replace("salePrice", ",", "", "ALL")# #salePrice# price $45.50 salePrice $111,110.00 Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (377:2) to (377:63). Date/Time: 05/10/01 11:20:05 ... -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:29 AM To: CF-Talk Subject: RE: insert problem Replace("1,110.00", ",", "", "ALL") or Replace(thevar, ",", "", "ALL") if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7 Question
I set SET NOCOUNT ON/OFF outside the BEGIN/COMMIT TRANSACTION and it seems to work fine. Thanks! best, paul At 10:54 AM 5/10/01 +0700, you wrote: >* Team Allaire * > > Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT > > TRANSACTION in another version, but I guess it fell down the proverbial > > crack in this developing application. (Probably a bad copy/paste ;-) > >if you shove a bunch of TSQL statements into one cfquery you have to >enclose them all in SET NOCOUNT ON/OFF block to prevent cf from >thinking its getting valid resultsets everytime sql server sends back "x >rows >selected" messages. in fact, for most sp its a good idea to shave a few ms >here & there... > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
when saving dollar amounts, I always use: REReplace('#thelist#', '[^0-9.]', '', 'ALL' ), and then dollarformat() or lscurrencyformat() when I display. HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 2:33 PM To: CF-Talk Subject: RE: insert problem I tried doing a replace but i still get the same output I'm doing this before i save. my field type is money. there are no quotes on my field Update product Set sectionID = #sectionID#, productName = '#productName#', description = '#description#', manufacturer = '#manufacturer#', manufURL = '#manufURL#', imageName = '#imageName#', thumbName = '#thumbName#', printName = '#printName#', price = #price#, salePrice = #salePrice# Where productID = #productID# #Replace("price", ",", "", "ALL")# #price# #Replace("salePrice", ",", "", "ALL")# #salePrice# price $45.50 salePrice $111,110.00 Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (377:2) to (377:63). Date/Time: 05/10/01 11:20:05 ... -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:29 AM To: CF-Talk Subject: RE: insert problem Replace("1,110.00", ",", "", "ALL") or Replace(thevar, ",", "", "ALL") if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (367:2) to (367:63). Date/Time: 05/10/01 10:08:17 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Integrity - Q of the Day
We had a similar issue with the City field in a database. We maintain a City table, and each user record only contains the primary key (an integer id) to the corresponding record in the City table. For the user interface we created a combo-type box, so that a user could either select their City from the drop-down, or enter a new City in a text box. If they entered a new City in the text box, a record is added to the City table. The administrator then has a module in which they can approve or disapprove new cities added. Once they approve the city, it will appear in add drop-down boxes. If they don't want to add the city, then they'll change the pointer in the user table to point to the correct city, and they delete the new city from the City table. It's a bit of work, but it works well for the client. Hope that helps, Bob -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: May 10, 2001 11:52 AM To: CF-Talk Subject: OT: Data Integrity - Q of the Day Here's a question that's been bothersome for some time. We have an interface where participants register for meeting. There is a form they fill out with basic information, including the pharmaceutical company they are associated with. We use drop downs where we can to keep data as constant as possible, but we cannot use dropdowns for the company they are with as there are far too many to compile and list. And therein lies our problem. Users from one company can have a half dozen different ways to spell their company name. There is an admin search page where an administrator can search for registered users by several different criteria, one of which is the user's company name. I dynamically build a drop down for this field on the search page by pulling all distinct company names from the db. Of course, there are several different variations of the company name in the dropdown, which makes it very cumbersome. Has anyone had to deal with this? If so, how did you deal with it? And/or does someone have an idea on how to go about dealing with it? Erika (with a *K*) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: WingDings
Hi, Using CF_HTMLMenu and was looking for a good reference on the ASCII translation of the WingDing character set. Those I've found on the web don't seem to be current or complete. Any ideas on where I can find one? Thanks, Andrew ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: insert problem
No quotes around salePrice: #Replace(salePrice, ",", "", "ALL")# (But why isn't numberFormat working for you ) - Original Message - From: "Metzy Martinez" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 2:32 PM Subject: RE: insert problem > I tried doing a replace but i still get the same output > I'm doing this before i save. > > my field type is money. > there are no quotes on my field > > > > Update product > Set sectionID = #sectionID#, > productName = '#productName#', > description = '#description#', > manufacturer = '#manufacturer#', > manufURL = '#manufURL#', > > imageName = '#imageName#', > > > thumbName = '#thumbName#', > > > printName = '#printName#', > > price = #price#, > salePrice = #salePrice# > Where productID = #productID# > > > > #Replace("price", ",", "", "ALL")# > #price# > > #Replace("salePrice", ",", "", "ALL")# > #salePrice# > > > price $45.50 salePrice $111,110.00 > > > > > > > -- -- > > > Error Occurred While Processing Request > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near > '110.00'. > > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (377:2) to (377:63). > > > Date/Time: 05/10/01 11:20:05 > > > .. > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 7:29 AM > To: CF-Talk > Subject: RE: insert problem > > > Replace("1,110.00", ",", "", "ALL") > > or Replace(thevar, ",", "", "ALL") if it's in a variable. > > -Original Message- > From: Metzy Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 10:23 AM > To: CF-Talk > Subject: insert problem > > > i'm trying to same a number that has been formatted as dollar amount > > if i have an amount that is $1,110.00 it's telling that i have an error > i'm pretty sure that it is because i'm trying to save and the number is > being placed with a comma in it. how can i work around this. > > > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near > '110.00'. > > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (367:2) to (367:63). > > > Date/Time: 05/10/01 10:08:17 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Data Integrity - Q of the Day
Unless you've got a table of distinct companies for registrants to choose from, you've got to solve the problem in the search application. Using a drop down list here, when you know there could be multiple spellings of a company, is probably the wrong approach. It depends a little on how exact the search needs to be. For instance, are you trying adding up $$ amounts for billing purposes, or do you just want administrators to be able to drill down to the individual registrations? If it's the latter, then searching using wildcard matching should suit your purposes. Jim - Original Message - From: "Erika L. Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 9:52 AM Subject: OT: Data Integrity - Q of the Day > Here's a question that's been bothersome for some time. > > We have an interface where participants register for meeting. There is a > form they fill out with basic information, including the pharmaceutical > company they are associated with. > > We use drop downs where we can to keep data as constant as possible, but we > cannot use dropdowns for the company they are with as there are far too many > to compile and list. > > And therein lies our problem. Users from one company can have a half dozen > different ways to spell their company name. > > There is an admin search page where an administrator can search for > registered users by several different criteria, one of which is the user's > company name. I dynamically build a drop down for this field on the search > page by pulling all distinct company names from the db. Of course, there are > several different variations of the company name in the dropdown, which > makes it very cumbersome. > > Has anyone had to deal with this? If so, how did you deal with it? And/or > does someone have an idea on how to go about dealing with it? > > > Erika > (with a *K*) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: XML and Java training?
My boss and I are being asked by hq to get training in XML and Java. Can anybody in this multi-disciplinary group of wizards recommend a training source? (We're in the San Francisco Bay Area.) Thanks! Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Internal Server Error
There is 4.0x info here: http://www.defusion.com/articles/index.cfm?ArticleID=89 if you have corrections/updates to offer I'd love to see them. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:08 PM To: CF-Talk Subject: Re: Internal Server Error Internal server error sometimes means that the permissions are messed up. Try allowing everyone full access to the page, and try again, then work backwards and see how high you can set the permissions and still have it work.. Does anyone know what permissions have to be set for cf to work? Al a1webs.com At 07:54 AM 5/10/2001 -0700, Bernd VanSkiver wrote: >We just set up a Windows 2000 Advanced Server with >ColdFusion 4.5.1 SP2 and cannot get any cfm files to >work, it always gives me an Error 500 - Internal >Server Error. Does this for asp pages also. I did >not set up the machine, so figure the guy that did >messed with some setting to mess this up, I have set >up computers with similar configurations and have >never had this problem before. Any ideas why this is >happening? I cannot find any setting that fixes this problem. > >= >Bernd VanSkiver >[EMAIL PROTECTED] >ColdFusion Developer >ICQ UIN: 916324 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfloop vs cfoutput
Thanks for clearing that up for me KOla -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 12:03 To: CF-Talk Subject: RE: cfloop vs cfoutput > Sorry for the crosspost (had conflicting answers from other lists) > > but is there a consensus on which method of looping over a query > is fastest? > > cfloop or cfoutput.. OK, I know you've posted a "Winner" post, but here's the reasoning behind why CFOutput is slower than CFLoop When you run a CFOutput, CF has to look through as see what has to be converted for "output", i.e. #s around variables etc. When you run a CFLoop, it just assumes that anything that's a non-CF tag is to be sent to the browser, and it runs the tags as it reaches them Ideally, you should put a CFLoop around the code you wish to loop over, and only put CFOutput around the variables you want outputted - that provides the best performance on the server (which is probably the most important in most circumstances) Although, I don't like using this method for development (it's harder to read), the performance over many thousands of hits is noticable HTH Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
Well, you're not limited to 5 levels, but rather 31; if you feel confident that will be enough then you're set. Your second approach works IF you can always assume that all the security levels are either lesser or greater than the new one you want to add, never "equal". But if you need to have two security levels, one with rights to read pages about accounting projects (but not construction projects) and the other with rights to read pages about construction projects (but not accounting projects), which gets the higher number? -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:13 PM To: CF-Talk Subject: RE: Bit Masks Thanks for the list tip! I'm just now developing an application using CF's BitAnd() function. In my application, I currently have the following permission levels: Level UserDescription Permission DB value for BitAnd 1 1 Public - future permission level READ selected pages 2 3 Basic Project Read User Read all pages 4 7 Basic Project Content User Read all, Add/Update selected data 8 15 Project Manager User Read all, Add/Update all 16 31 me ;-) Since a User with a larger permission value must also have the access all Users with lesser permission values do, CF's BitAnd enables only 5 permission levels. I'm concerned the client might come up with additional permission levels/groups in the future, thereby defeating my use of BitAnd, and forcing me to modify code/user database/client database to use a list instead of BitAnd. Or have I missed a clever way to use BitAnd? best, paul PS> It sure helps to ask for help;-) Now that I've done so, I think the simple solution to my problem is not to use BitAnd, but just adopt a sequence of increasing numbers, for example: 5, 10, 15, 20, 25, etc (go by 5's to allow future insertion of new intermediate permission levels), and verify a User's permission is greater than a target. That way, I still only need to store a single number in the database as with BitAnd, and don't need to go to using a list. Any comments? At 10:48 AM 5/10/01 -0400, you wrote: >Bit masks are cool, but remember that there is a limit to how much info you >can pack in a bitmask because CF doesn't let you use the bit functions on >anything of more than 32 bits. I have taken to using lists for this sort of >thing because there's no practical limit to how many items it can contain >and there are lots of useful list functions in CF. > > >-Original Message- >From: Ken Monroe [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, May 09, 2001 4:54 PM >To: CF-Talk >Subject: Bit Masks > > >Hello! > >I believe that someone once gave a presentation at one of the CFUGs about >using bit masks, also know as Right Bit AND, to set up security access >levels. This wasn't the same as the presentation at the Fig Leaf site >that's slight more oriented towards hierarchy uses. I've looked at all the >CFUG sites linked to from the Allaire site but I can't find the >presentation. Does anyone recall where the presentation was made and/or how >to get the presentation file? > >Thx > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL7008N REXX variable (Again)
DB2 Error Code = -7008 [IBM][CLI Driver][AS] SQL7008N REXX variable "SUBMI1" contains inconsistent data. SQLSTATE=55019 This error only occurs on production side. Back-end is the same for local and production development. Using AS/400 on IBM mainframe. Prod box is Unix, local is Win2k. Last time I got this error, I dropped and re-created the table and the error went away (I know that was not a real solution, but it worked). It did not work wehn I tried that this time. What does this error really mean? James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Code Snippet:Random Password Generator(repost)
Seems unlikely, but it does generate some great words like "teethuku" and "taafduno" and the unforgettable "fuoflyru". Fun script. > -Original Message- > From: Erika L Walker [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 12:19 PM > To: CF-Talk > Subject: RE: Code Snippet:Random Password Generator(repost) > > What if it randomly generates a bad word? > > Erika > (with a *K*) > > -Original Message- > From: Daniel Kemp [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 11:42 AM > To: CF-Talk > Subject: RE: Code Snippet:Random Password Generator(repost) > Seems un > > > > Why define the alphabet? Just use decimal values for the > > asci char set. > > Ok here's another code snippet, this is a password gen that I use now > and then. The slight advantage of this one is > it creates a word which hopefully more rememberable than just random > letters and numbers. There's more than one occurrence of some letters > to tip the odds towards those. > > --- > > "cdddffgggjjklmmnnrrsstttvwwwxyz"> > > > > Mid(constList,RandRange('1',len(constList)),'1')> > > Mid(vowelList,RandRange('1',len(vowelList)),'1')> > > > > #password# > - > > > Hope this helps someone. > > Dan. > > > > This message is intended only for the use of the person(s) ("the intended > recipient(s)") to whom it is addressed. > > It may contain information which is privileged and confidential within the > meaning of the applicable law. > If you are not the intended recipient, please contact the sender as soon as > possible. > The views expressed in this communication may not necessarily be the views > held by Live Information Systems Limited. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Integrity - Q of the Day
Yep we had an identical thing where students had to select a school that they attended in the UK from the complete list of schools (a lot!). We got around it asking the user to enter the first three letters of there school - we then present them with the form with a reduced list of schools begininning with those three letters. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 17:26 To: CF-Talk Subject: RE: Data Integrity - Q of the Day We had a similar issue with the City field in a database. We maintain a City table, and each user record only contains the primary key (an integer id) to the corresponding record in the City table. For the user interface we created a combo-type box, so that a user could either select their City from the drop-down, or enter a new City in a text box. If they entered a new City in the text box, a record is added to the City table. The administrator then has a module in which they can approve or disapprove new cities added. Once they approve the city, it will appear in add drop-down boxes. If they don't want to add the city, then they'll change the pointer in the user table to point to the correct city, and they delete the new city from the City table. It's a bit of work, but it works well for the client. Hope that helps, Bob -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: May 10, 2001 11:52 AM To: CF-Talk Subject: OT: Data Integrity - Q of the Day Here's a question that's been bothersome for some time. We have an interface where participants register for meeting. There is a form they fill out with basic information, including the pharmaceutical company they are associated with. We use drop downs where we can to keep data as constant as possible, but we cannot use dropdowns for the company they are with as there are far too many to compile and list. And therein lies our problem. Users from one company can have a half dozen different ways to spell their company name. There is an admin search page where an administrator can search for registered users by several different criteria, one of which is the user's company name. I dynamically build a drop down for this field on the search page by pulling all distinct company names from the db. Of course, there are several different variations of the company name in the dropdown, which makes it very cumbersome. Has anyone had to deal with this? If so, how did you deal with it? And/or does someone have an idea on how to go about dealing with it? Erika (with a *K*) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WingDings
Roll your own: #i# - #chr(i)# > -Original Message- > From: Andrew Peterson [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 12:35 PM > To: CF-Talk > Subject: OT: WingDings > > Hi, > > Using CF_HTMLMenu and was looking for a good reference on the ASCII > translation of the WingDing character set. Those I've found on the web don't > seem to be current or complete. Any ideas on where I can find one? > > Thanks, > Andrew > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and custom stylesheets
Hey gang... I've kinda got this working, but would prefer to improve it a bit. I'm trying to modify an existing app, that uses stylesheets, to allow for customization of the colorsets... so that User #1 can choose the "blue" set, User #2 the "green" set, etc. Each set has a hex color code for each of the styles used, stored in the DB... so basically, user logs in, tap the DB for the colorcodes, make session vars out of each, reference said vars when executing the style code, voila - purdy colors. :) I can do this easily enough if I just include the style page (as a .cfm file) - but what I'd *really* like to do is be able to link to the stylesheet page, so that the styles themselves don't show up in the source, i.e. I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Thanks in advance- --Scott ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure problem
Simon would you use brackets in the output when ref. the field or in the SQL? Greg -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:09 AM To: CF-Talk Subject: RE: stored procedure problem do the same thing... use [brackets ] ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:44 AM To: CF-Talk Subject: stored procedure problem Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports rehash
I hate to rehash this, but I have gone through the archives and cannot find what I need. I am trying to pass parameters to a crystal report, example - last name: if the HTML for last name is left blank I don't wantit as part of the crystal filter, if someone put something in the fieldI want to filter on it. ___ easy to do in CF ___ pulling my hair out on crystal reports. If someone could share the CFM page that calls the CR and passes params, AND share a simple CR that uses these params...I would be forever indebted... time is an issue.. Thank all, JP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT: XML and Java training?]
U of Hawaii for a few weeks. "Braver, Ben" <[EMAIL PROTECTED]> wrote: My boss and I are being asked by hq to get training in XML and Java. Can anybody in this multi-disciplinary group of wizards recommend a training source? (We're in the San Francisco Bay Area.) Thanks! Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update problem
Here's my GetSubjects query. It comes from another page and in called by a CFINCLUDE tag. SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.GradingPeriod1, tbl_StudentGrade.GradingPeriod2, tbl_StudentGrade.GradingPeriod3, tbl_StudentGrade.GradingPeriod4, tbl_StudentGrade.PERMNUM FROM tbl_CourseSkill, tbl_StudentGrade WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=1 OR tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=2 Order BY tbl_StudentGrade.SkillID, GradingPeriod Janine M. Jakim Database Programmer/Analyst Albemarle County Public Schools Department of Technology Phone: (804) 975-9443 Fax: (804) 975-9442 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert problem
Thank you guys for all your help i'm thinking it didn't like the comma because it thought it was a function of sql i'm such a dork i put quotes on the price, it work with out the quotes, he he. but even after that it still didn't change my variable, so i thought about i didn't have to replace the $ sign. after the change of the comma it added my variable. Andy-- i decided to change my money data type to a float, thanks for the input. I'm a recent graduate and i'm a 1 man development team (my coworker quit and their not hiring anyone else) and you are the only folks i can bounce ideas with. Thank you. Susan if your out there i miss You Metzy -Original Message- From: Dave f [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 9:51 AM To: CF-Talk Subject: Re: insert problem No quotes around salePrice: #Replace(salePrice, ",", "", "ALL")# (But why isn't numberFormat working for you ) - Original Message - From: "Metzy Martinez" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 2:32 PM Subject: RE: insert problem > I tried doing a replace but i still get the same output > I'm doing this before i save. > > my field type is money. > there are no quotes on my field > > > > Update product > Set sectionID = #sectionID#, > productName = '#productName#', > description = '#description#', > manufacturer = '#manufacturer#', > manufURL = '#manufURL#', > > imageName = '#imageName#', > > > thumbName = '#thumbName#', > > > printName = '#printName#', > > price = #price#, > salePrice = #salePrice# > Where productID = #productID# > > > > #Replace("price", ",", "", "ALL")# > #price# > > #Replace("salePrice", ",", "", "ALL")# > #salePrice# > > > price $45.50 salePrice $111,110.00 > > > > > > > -- -- > > > Error Occurred While Processing Request > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near > '110.00'. > > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (377:2) to (377:63). > > > Date/Time: 05/10/01 11:20:05 > > > .. > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 7:29 AM > To: CF-Talk > Subject: RE: insert problem > > > Replace("1,110.00", ",", "", "ALL") > > or Replace(thevar, ",", "", "ALL") if it's in a variable. > > -Original Message- > From: Metzy Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 10:23 AM > To: CF-Talk > Subject: insert problem > > > i'm trying to same a number that has been formatted as dollar amount > > if i have an amount that is $1,110.00 it's telling that i have an error > i'm pretty sure that it is because i'm trying to save and the number is > being placed with a comma in it. how can i work around this. > > > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near > '110.00'. > > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (367:2) to (367:63). > > > Date/Time: 05/10/01 10:08:17 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
> I believe that someone once gave a presentation at one of the CFUGs about > using bit masks, also know as Right Bit AND, to set up security access > levels. This wasn't the same as the presentation at the Fig Leaf site > that's slight more oriented towards hierarchy uses. I've looked > at all the > CFUG sites linked to from the Allaire site but I can't find the > presentation. Does anyone recall where the presentation was made > and/or how to get the presentation file? I once did a presentation a long time ago for the Atlanta CFUG on a simple security model that used bits in this fashion, but it was designed for CF4.0, and has a few outdated syntax samples in it if you are using something newer than 4.0. I'm emailing you a copy of it offlist. If anyone else wants it, please let me know offlist. Here's a bonus for working with bits... Slap the following code into a CFM template, run it, and them print the output. I keep a copy of it on my wall, and it really helps with remembering how the heck bit functions work and where the positions are/start etc... -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 10987654321098765432109876543210 #BitMaskRead(x, i, 1)# = x = (#x#) #BitMaskRead(y, i, 1)# = y = (#y#) #BitMaskRead(BitAnd(x, y), i, 1)# = BitAnd(x, y) = #BitAnd(x, y)# #BitMaskRead(BitOr(x, y), i, 1)# = BitOr(x, y) = #BitOr(x, y)# #BitMaskRead(BitXOr(x, y), i, 1)# = BitXOr(x, y) = #BitXOr(x, y)# #BitMaskRead(BitNot(x), i, 1)# = BitNot(x) = #BitNot(x)# #BitMaskRead(BitNot(y), i, 1)# = BitNot(y) = #BitNot(y)# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Resturant/Golf reservation system
Has anyone out there created a reservation system for either a resturant or a golf course? I am looking to see if there is anything out there that already exists so that I do not have to re invent the wheel for this. Thank you Alan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
I understand the 31, but it's 5 levels not 31 with the constraint I described below. But your point is well-taken. I guess I should look for where issues similar to the ones you raise might arise. On the accounting/construction issue you raise, I have a similar one I didn't mention. Project Content Users with "Read all, Add/Update" Access may Add/Update projects at their campus only (there are 33 campuses). I address this by insuring each User is assigned a CampusID (except for Project Managers and above). best, paul At 01:07 PM 5/10/01 -0400, you wrote: >Well, you're not limited to 5 levels, but rather 31; if you feel confident >that will be enough then you're set. > >Your second approach works IF you can always assume that all the security >levels are either lesser or greater than the new one you want to add, never >"equal". But if you need to have two security levels, one with rights to >read pages about accounting projects (but not construction projects) and the >other with rights to read pages about construction projects (but not >accounting projects), which gets the higher number? > >-Original Message- >From: Paul Smith [mailto:[EMAIL PROTECTED]] >Sent: Thursday, May 10, 2001 12:13 PM >To: CF-Talk >Subject: RE: Bit Masks > > >Thanks for the list tip! > >I'm just now developing an application using CF's BitAnd() function. > >In my application, I currently have the following permission levels: > >Level UserDescription > Permission > DB value for > BitAnd > >1 1 Public - future permission level > READ selected pages >2 3 Basic Project Read User > Read all pages >4 7 Basic Project Content User > Read all, Add/Update selected data >8 15 Project Manager User > Read all, Add/Update all >16 31 me ;-) > >Since a User with a larger permission value must also have the access all >Users with lesser permission values do, CF's BitAnd enables only 5 >permission levels. I'm concerned the client might come up with additional >permission levels/groups in the future, thereby defeating my use of BitAnd, >and forcing me to modify code/user database/client database to use a list >instead of BitAnd. > >Or have I missed a clever way to use BitAnd? > >best, paul > > >PS> It sure helps to ask for help;-) Now that I've done so, I think the >simple solution to my problem is not to use BitAnd, but just adopt a >sequence of increasing numbers, for example: 5, 10, 15, 20, 25, etc (go by >5's to allow future insertion of new intermediate permission levels), and >verify a User's permission is greater than a target. That way, I still >only need to store a single number in the database as with BitAnd, and >don't need to go to using a list. Any comments? > > >At 10:48 AM 5/10/01 -0400, you wrote: > >Bit masks are cool, but remember that there is a limit to how much info you > >can pack in a bitmask because CF doesn't let you use the bit functions on > >anything of more than 32 bits. I have taken to using lists for this sort >of > >thing because there's no practical limit to how many items it can contain > >and there are lots of useful list functions in CF. > > > > > >-Original Message- > >From: Ken Monroe [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, May 09, 2001 4:54 PM > >To: CF-Talk > >Subject: Bit Masks > > > > > >Hello! > > > >I believe that someone once gave a presentation at one of the CFUGs about > >using bit masks, also know as Right Bit AND, to set up security access > >levels. This wasn't the same as the presentation at the Fig Leaf site > >that's slight more oriented towards hierarchy uses. I've looked at all the > >CFUG sites linked to from the Allaire site but I can't find the > >presentation. Does anyone recall where the presentation was made and/or >how > >to get the presentation file? > > > >Thx > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Contracts & invoice forms for freelance?
does any one have a basic formal agreement docs, or contracts i could modify for a freelance job? a formal contract which outlines your fees, returns of content and information if we part company, termination of agreement, turn around time, ect. also if you have a & Monthly invoice with a work detail that would be helpful. as far as billing goes, i am not sure what i need to do. would i need to fill out some sort of tax form? any help, advice & forms would be great! thanks. just got a little freelance job, to pad my honey moon costs. :] then going to try on tuxes today @ 4:30! i am thinking purple, with reign stones! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq:47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hosting /Dedicated or else
Looking for recommendations on CF Hosting places. No cheap places, places that kick butt! Christopher Badouin - founder www.giveitaudio.com -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:51 AM To: CF-Talk Subject: RE: URL Parameter in window.open oh! oh! I know the answer to this one! :) I did this already..hang on lemme get the code here.. ok! Go to www.opentelecom.com and click Send E page. and do a View Source on that page ^_^ Its all there. But just in case the site is down or somethign here is the relevant code: function OpenPage() { window.open('sendpage.cfm?name='+ document.selectcustomer.name.value + '&message=' + document.selectcustomer.message.value + '&email=' +document.selectcustomer.email.value,'paging','scrollbars=auto,menu=no,heigh t=80,width=600') } //--> And here is the form: Took me a morning to hunt down and debug the syntax on this one :) But it looks rather nice. -Gel -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WingDings
Used to be little Windows Accessory - CHARMAP.EXE. You should be able to find a copy somewhere, it works great for me. - Original Message - From: "Andrew Peterson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 12:35 PM Subject: OT: WingDings > Hi, > > Using CF_HTMLMenu and was looking for a good reference on the ASCII > translation of the WingDing character set. Those I've found on the web don't > seem to be current or complete. Any ideas on where I can find one? > > Thanks, > Andrew > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and custom stylesheets
I've tried the same thing and also failed! There *ARE* differences in the way that INCLUDED'd and SRC= stylesheets work. I never figured out how or why. - Original Message - From: "Scott Weikert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 1:27 PM Subject: CF and custom stylesheets > Hey gang... > > I've kinda got this working, but would prefer to improve it a bit. I'm > trying to modify an existing app, that uses stylesheets, to allow for > customization of the colorsets... so that User #1 can choose the "blue" set, > User #2 the "green" set, etc. Each set has a hex color code for each of the > styles used, stored in the DB... so basically, user logs in, tap the DB for > the colorcodes, make session vars out of each, reference said vars when > executing the style code, voila - purdy colors. :) > > I can do this easily enough if I just include the style page (as a .cfm > file) - but what I'd *really* like to do is be able to link to the > stylesheet page, so that the styles themselves don't show up in the source, > i.e. > > > > I've had some hassles trying to link the page like this... it doesn't seem > to properly execute the CF code within. > > Anyone out there tried to do this same thing, and succeeded? Input would be > most welcome. > > Thanks in advance- > --Scott > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and custom style sheets
On 5/10/01 1:27 PM Scott Weikert wrote: > > > I've had some hassles trying to link the page like this... it doesn't seem > to properly execute the CF code within. > > Anyone out there tried to do this same thing, and succeeded? Input would be > most welcome. Two suggestions: 1. Make a new style sheet for each option, and use: Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and custom stylesheets
I have done this by replacing the style.css with a variable. I grabbed what the users preferences was via a cookie or the database, and then used that to decide what style sheet to include. Robert J. Bailey (646) 526-4536 -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:27 PM To: CF-Talk Subject: CF and custom stylesheets Hey gang... I've kinda got this working, but would prefer to improve it a bit. I'm trying to modify an existing app, that uses stylesheets, to allow for customization of the colorsets... so that User #1 can choose the "blue" set, User #2 the "green" set, etc. Each set has a hex color code for each of the styles used, stored in the DB... so basically, user logs in, tap the DB for the colorcodes, make session vars out of each, reference said vars when executing the style code, voila - purdy colors. :) I can do this easily enough if I just include the style page (as a .cfm file) - but what I'd *really* like to do is be able to link to the stylesheet page, so that the styles themselves don't show up in the source, i.e. I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Thanks in advance- --Scott ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists