RE: database.ldb
I'm probably off the track (or on a different planet)but is there not a syntax problem in the code??? The closing tag after the "select *" and before the "from" Haroon Williams Group IT Investec Bank Tel 011 286 7529 Fax 011 286 7522 Cell 082 853 4286 Email [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 04/26/01 01:03AM >>> If you are running 4.5.1 there is a "Release" button in the Administrator to unlock the dB's. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 April 2001 08:53 To: CF-Talk Subject: database.ldb ok i hate access. i use this to unlock this db but it wont work now does anyone else have another idea? Select * >From ImageManager Where lock="damnyou" thanks Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.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: CFX_Image - Synopsis
Eric, I think what you're wanting is essentially what others using that tag are hoping for. I surely didn't create the tag, but as I said earlier, I've considered writing some clearer instructions for it (or course these will not likely be included with the tag, unless Jukka re-surfaces and wants them to be). Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: "Eric Root" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 26, 2001 2:03 AM Subject: CFX_Image - Synopsis > This is in response to the thread on CF_image documentation. What is > also needed, is a concise, clear synopsis of WHAT CF_Image does (it's > functions and how it can be used). I was a little overwhelmed by the > documentation and I was not clear about what I would be getting into and > what value the tag might offer. Needs sort of a concise > features/benefit section iterating the parameters that can be > controlled. That is my two cents worth and wish list. > > I am new to CF and I am always looking to see what is out there and how > I might take advantage of CF in the real world. This looks like a great > tag, but I wouldn't know at this point what I would be getting into. > > -- > Eric Root > > > > ~~ 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
CFX_Image - Synopsis
This is in response to the thread on CF_image documentation. What is also needed, is a concise, clear synopsis of WHAT CF_Image does (it's functions and how it can be used). I was a little overwhelmed by the documentation and I was not clear about what I would be getting into and what value the tag might offer. Needs sort of a concise features/benefit section iterating the parameters that can be controlled. That is my two cents worth and wish list. I am new to CF and I am always looking to see what is out there and how I might take advantage of CF in the real world. This looks like a great tag, but I wouldn't know at this point what I would be getting into. -- Eric Root ~~ 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
SQL Server 2000 warning
I don't know if anybody else has noticed this, but the implementation of SQL Server 2000 seems from my limited experience to be absolutely appalling. Let's forget about the speed comparison between 2000 and 7, let's forget about any anti-Microsoft sentiments, lets just look at the functionality. This afternoon I added four columns to a table in a customer testing database (on request). Shortly after I received complaints that a view of that table was returning rubbish. I looked into it. The view was returning four blank columns in the middle, and the data in every column after that was pushed four columns along. This meant that the column labels had no relationship to the data which was actually in them! I copied the SQL that defined the view, and ran it. Sure enough, it returned different results to the view. It seems almost definite to me that the view is recording column numbers, and not updating these numbers if the table definitions are changed. In fact, how this numbering system works boggles the mind, because according to both Enterprise Manager and intuition, the new columns should be at the end, and safely out of harm's way! If you wish to try to replicate this yourself, create a view containing a select * from at least one table (plus a few other columns from joined tables), then add new columns to the table and re-run the query afterward. I will be interested to see if anybody has the same results. David Cummins ~~ 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
Transfer Aborted Error
Hi i have this error almost 70% of the time. I am using OnSubmit Event. But after the event is fired, the page does not trigger to the action page as supposed. Instead i get the above error, Transfer Aborted. I have no idea why. Have anyone encounter this problem before? I am using CF4.5.1. ~~ 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
List Sorting/Finding
I have a database table with three columns: ID, UserName, UserLoc. I need to be able to search on the first four letters of a users last name, the names are stored in this format: lastname, firstname. When I find a matching criteria I need to highlight those records in a list I am displaying, if I do not find any matches I need to know which two records the criteria would fall in between if it did exist in the table. My current method to do this is below, is there a better way to do this? -Code--- SELECT ID, UserName, UserLoc FROM tblUsers ORDER BY UserName DESC #ABR# -- #qryGetInfo.UserLoc[(ListFind(ValueList(qryGetInfo.UserName, "|"), ABR, "|"))]# -End Code-- ~~ 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-Talk-list V1 #295
--[This is an automatically generated email notification.]-- V I R U S A L E R T ! You recently sent a message containing a known virus. The message was sent on 4/25/01 10:08:02 PM. The subject of the message was: "CF-Talk-list V1 #295" The message was sent to the following recipient(s): [EMAIL PROTECTED], [EMAIL PROTECTED] One or more of the recipients listed is a Small Dog Design client. As a result, their copy of the message has been quarantined in a special confinement area and can only be released by their system administrator. This message is only meant to serve as a notification that your message was not delivered to all of the designated recipients. No action is required on your part. Please note, however, that the detection of a virus in a message you sent may be an indication that your computer system has already been compromised by a virus. To obtain detailed information about wh Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF-Talk-list V1 #295
--[This is an automatically generated email notification.]-- V I R U S A L E R T ! You recently sent a message containing a known virus. The message was sent on 4/25/01 10:06:55 PM. The subject of the message was: "CF-Talk-list V1 #295" The message was sent to the following recipient(s): [EMAIL PROTECTED] One or more of the recipients listed is a Small Dog Design client. As a result, their copy of the message has been quarantined in a special confinement area and can only be released by their system administrator. This message is only meant to serve as a notification that your message was not delivered to all of the designated recipients. No action is required on your part. Please note, however, that the detection of a virus in a message you sent may be an indication that your computer system has already been compromised by a virus. To obtain detailed information about wh Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: display results in pages
hi all.. thanx for al yr help.. : ) hmm.. i look thru the custom tags.. hmm ok.. dun really customise to my need.. hmm.. think i would like to try do one myself for my company..so that my colleague can reuse this tags for our future projects.. :Þ heehe.. a challenge to me.. (heehe.. maybe a small challenge to all expert out there.. :) another question... i notice all the custom tags are encrypted... so is it a must for me to encrypt my codes after i finish..?? so to protect my coding logic?? cheers Han Peng, Lim X-media Pte Ltd. Engineer, Technology. Singapore. - Original Message - From: Semrau, Steven L Mr SRA <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 9:56 PM Subject: RE: display results in pages > If the custom tags that the other people have suggested don't work out for > you please post again in CF-Talk, I have one of my own that I have written > that does what you are looking for. > > Steven Semrau > SRA International, Inc. > Senior Member, Professional Staff > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Com: (703) 805-1095 > DSN: (703) 655-1095 > > > -Original Message- > From: han peng [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 25, 2001 8:11 AM > To: CF-Talk > Subject: display results in pages > > > hi ppl... any know how i can go abt doing this in CF?? > thinking of doing a custom tag for this function.. > > the look.. ---><< page 1 | 2 | 3 | 4.. >> > > wat i think of is .. after i did my query search... > i wan to pass the recordcount, the maxrow required, the currentpage and the > url link to the custom tag. to process the above. > > so.. is there any existing code around.. or any hints to go abt it? > > > regards, > han > ~~ 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
refresh page
Hallo, I want to ask something. I use cflocation to move to page "editlecture.cfm". But at page editlecture.cfm, the content of editlecture.cfm not refresh. ( I use page "editlecture.cfm" to display list of lecture) Can you help me? ~~ 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: Whats happening to Spectra
Neil, my interpretation of the message the you posted was that it basically will continue to be supported through 1.5.1 and then moved over into a community supported project with the backing of Macromedia. Rey Bango Team Allaire... - Original Message - From: "Neil Clark" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 9:36 AM Subject: RE: Whats happening to Spectra > No Rumour, it will be discontinued after the next maintenance release 1.5.1. > The plan is to take the core components / services and port them into the > app server - which in my opinion is the way forward... > > only time will tell. > > N > > Neil Clark > Senior Web Applications Engineer > Spectra / CF / XML > MCB Digital > Premier Macromedia Partner > Tel: 020 8941 3232 > Fax: 020 8941 4333 > 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: Sending mail with coldfusion
I use CFMAIL here to send out 24,000+ emails at a time. Never have a problem. Are you sure it's not your SMTP server that's choking? Just a thought. Dave - Original Message - From: William J Wheatley <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 5:11 PM Subject: Sending mail with coldfusion > Ok i have just about had it with CF mail =). With the bulk of the mail we > send out it just eventually fills the spool at about 12,000 or so and then > Dies nothing else goes out, no errors in any of the logs but the mail just > wont go out and its in the /opt/coldfusion/mail directory > > has anyone come up with an alternative to sending mail then using CFMAIL? > Because i swear even trying to send 1 CFMAIL to a hundred people does not > cut it..its a major issue. > > Thanks for the quick help! > > > Bill Wheatley > Director of Development > AEPS INC > Allaire ColdFusion Consulting Partner > Allaire Certified ColdFusion Developer > http://www.aeps.com > ICQ: 417645 > 954-472-6684 X303 > > IMPORTANT NOTICE: > This e-mail and any attachment to it is intended only to be read or used by > the named addressee. It is confidential and may contain legally privileged > information. No confidentiality or privilege is waived or lost by any > mistaken transmission to you. If you receive this e-mail in error, please > immediately delete it from your system and notify the sender. You must not > disclose, copy or use any part of this e-mail if you are not the intended > recipient. The RTA is not responsible for any unauthorized alterations to > this e-mail or attachment to it > > > ~~ 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 UPDATE
If there are many fields you'll need this instead: UPDATE mytable m SET DATE1 = (SELECT DATE1 FROM mytable t WHERE m.REFNO = t.REFNO ANDDATE1 IS NOT NULL) WHERE DATE1 IS NULL I'm not sure if you can alias a table in an UPDATE statement, but I think you can Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Cruz, Joseph [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 4:38 PM To: CF-Talk Subject: RE: SQL UPDATE UPDATE mytable SET DATE1 = (SELECT DATE1 FROM mytable WHERE REFNO = 123 ANDID = 1) WHERE DATE1 IS NULL That should do it for you. As long as the subquery returns only one row, this will work. HTH! :) Joe > -Original Message- > From: Adrian Cesana [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 25, 2001 6:24 PM > To: CF-Talk > Subject: SQL UPDATE > > > I have kind of a strange update I need to run and cant figure > out how to > write the thing properly, I think Im making it more difficult > than it is, > maybe not. > > Here is what the data basically looks like > > IDREFNO DATE1 > 1 123 04/25/2001 > 2 123 > 3 123 > > > > I need to update the NULL DATE1 fields with the VALUE of > DATE1 where NOT > NULL and WHERE REFNO equals REFNO. > > I guess it would be something like this but what value do I > use for the SET? > Can I use a sub query perhaps, how? > > > UPDATE mytable SET DATE1 = ??? WHERE REFNO = REFNO > > > Thanks,Adrian > > > ~~ 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 UPDATE
UPDATE mytable SET DATE1 = (SELECT DATE1 FROM mytable WHERE REFNO = 123 ANDID = 1) WHERE DATE1 IS NULL That should do it for you. As long as the subquery returns only one row, this will work. HTH! :) Joe > -Original Message- > From: Adrian Cesana [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 25, 2001 6:24 PM > To: CF-Talk > Subject: SQL UPDATE > > > I have kind of a strange update I need to run and cant figure > out how to > write the thing properly, I think Im making it more difficult > than it is, > maybe not. > > Here is what the data basically looks like > > IDREFNO DATE1 > 1 123 04/25/2001 > 2 123 > 3 123 > > > > I need to update the NULL DATE1 fields with the VALUE of > DATE1 where NOT > NULL and WHERE REFNO equals REFNO. > > I guess it would be something like this but what value do I > use for the SET? > Can I use a sub query perhaps, how? > > > UPDATE mytable SET DATE1 = ??? WHERE REFNO = REFNO > > > Thanks,Adrian > > > ~~ 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: SQL2000 server not recognized by CF 4.5 - continued...
Hello everyone, i sent an email two days ago about not being able to get CF and SQL2000 to talk to each other. i followed the instructions everyone sent me including installing the latest MDAC and still, i couldn't get them to talk to each other. i did finally get them to talk by checking the "use trusted connection" checkbox, but someone at work told me that i hadn't fixed any problem, i'd just gone around it. of course, i really don't know what he means by that at all. As you might have guessed, i'm new to server admin. Also, i can't even get an access DB to be recognized. CF just tells me the datasource cannot be verified. i've added it in my ODBC panel under SystemDSN, but the problem persists with getting CF to talk to databases. if anyone can shed any light onto this problem i would greatly appreciate it. thanks in advance. d -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:25 PM To: CF-Talk Subject: Re: SQL2000 server not recognized by CF 4.5 On 4/23/01 1:52 PM David Baskin wrote: > I'm hoping someone can help with a problem i cannot figure out. i have a new > box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend > without problems, but now i cannot get SQL and CF to play together. i try to > set up the ODBC and my connection fails every time. the base SQL server that > shows up as default on the ODBC admin does not connect, nor does the one > that i create. not sure how to trouble shoot this problem at all. any help > is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - 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: Emailing Question
Hi, We were having the same problem with our outbound email. It turned out that the email server for that particular domain required authentication for the SMTP server. They had added this as a Spam blocking measure. I removed the SERVER="xx" and PORT="xx" portions and it now works fine. The hosting company specified a server name in the CF Admin, which in turn acts as the "default SMTP server" if no server info is provided in your code. HTH Mike Michael Wilson - CTO/Secretary http://www.xionmedia.com Xion Media, Inc. Web Development P: 704-398-2454 F: 704-398-2063 "In the middle of difficulty lies opportunity." --Albert Einstein > -Original Message- > From: Tracy Bost [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 25, 2001 7:10 PM > To: CF-Talk > Subject: Re: Emailing Question > > > The mail server is probably set up to not allow "relaying". > That is, if it isn't from the server's domain, or a trusted > one specified on the server, it won't allow the mail to pass > through. This is done to prevent spam > - Original Message - ~~ 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: database.ldb
thanks guys/gals
i should have said that im not the host of this particular site so i cant
reboot and fix it or use the release button in the administrator either...
sorry about that.
i got it though
thanks again
(this is why i dont use access)
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 5:02 PM
Subject: RE: database.ldb
> if you're using CF 4.5.x, you can use:
>
>
>
> that will force the release of the datasource. just replace {DSN} with
> catlingalleries (using your DSN below).
>
> to re-enable the DSN, use:
>
>
>
> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 3:53 PM
> To: CF-Talk
> Subject: database.ldb
>
>
> ok i hate access.
> i use this to unlock this db but it wont work now does anyone else have
> another idea?
>
>
> Select *
> >From ImageManager
> Where lock="damnyou"
>
>
> thanks
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.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: Cfmail
Heidi, Be sure that you have valid email address domains in the "from field" and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Emailing Question
The mail server is probably set up to not allow "relaying". That is, if it isn't from the server's domain, or a trusted one specified on the server, it won't allow the mail to pass through. This is done to prevent spam - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 5:53 PM Subject: Emailing Question > Hi all, > > This may be a bit OT. Im using CFMail to send mail, though my "To" and my > "From" attribute are both emails that do not have an account on my email > server, and when this is the case the email will not get sent. > > Now my question is, is this normal behavior for an email server? (I dont > mess with email servers much :) > > btw We are using mdeamon > > TIA, > Jeff > > > ~~ 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: using variable list from a multiple select/form (warning: lon g)
Your trying to do to many loops. Try this and let me know if works for you. SELECT Users.UserName FROM Users Users WHERE (Users.UserId='#form.NOTIFY#') Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:45 PM To: CF-Talk Subject: using variable list from a multiple select/form (warning: long) Hello all, I am having trouble using a particular variable. This is a long email because I am trying to provide enough information to give a clear picture of my problem (which is probably quite simple and I probably should be able to solve it on my own ...) I have a form variable (called "NOTIFY") which comes from a drop-down option (dynamically populated) which allows for multiple choices. The variable arrives on the action page (where the data is inserted in a table, that works no problem) as a comma delimited list. Once it arrives at the action page, it serves two functions. It's email address creation function works beautifully. But then I need to use it to query our membership database to pull out the actual name of the person so that the email message is more user friendly ... (the CN in an email address just won't do for Dear , you know how that goes). What I think I need to do it 1. Count the number of items in the list 2. Run it through a list loop to parse each item out as a separate variable 3. Run the query to the membership database to get the UserNames, using the newly created variables. 4. Run it through a query to put it back in a new variable for output in the single email that is generated. But I don't know how to count the items or run the list loop. Can you help me? Here's the code for the select from the form, populated by an earlier query: #NOTIFY# No Report And this is what I have in the action form, so far: #get_count.RecordCount# SELECT Users.UserName FROM Users Users WHERE (Users.UserId='#form.NOTIFY#') (closes at the end of the mail, I have not included all of that...) @@@ Help!! Special thanks in advance to anyone who has a better idea of how to do this than I have had so far. :-) Oriole ~~ 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: database.ldb
if you're using CF 4.5.x, you can use:
that will force the release of the datasource. just replace {DSN} with
catlingalleries (using your DSN below).
to re-enable the DSN, use:
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 3:53 PM
To: CF-Talk
Subject: database.ldb
ok i hate access.
i use this to unlock this db but it wont work now does anyone else have
another idea?
Select *
>From ImageManager
Where lock="damnyou"
thanks
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.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: database.ldb
if you're running 4.5.x you don't have to reboot. see my reply to the original post. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 4:01 PM To: CF-Talk Subject: Re: database.ldb - Original Message - From: "Jay Patton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 5:53 PM Subject: database.ldb > ok i hate access. > i use this to unlock this db but it wont work now does anyone else have another idea? > > > Select * > >From ImageManager > Where lock="damnyou" > > > thanks > > Jay Patton > Web Design / Application Design > Web Pro USA > p. 406.549.3337 ext. 203 > p. 1.888.5WEBPRO ext. 203 > e. [EMAIL PROTECTED] > url. www.webpro-usa.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: database.ldb
If you are running 4.5.1 there is a "Release" button in the Administrator to unlock the dB's. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 April 2001 08:53 To: CF-Talk Subject: database.ldb ok i hate access. i use this to unlock this db but it wont work now does anyone else have another idea? Select * >From ImageManager Where lock="damnyou" thanks Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.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: database.ldb
- Original Message - From: "Jay Patton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 5:53 PM Subject: database.ldb > ok i hate access. > i use this to unlock this db but it wont work now does anyone else have another idea? > > > Select * > >From ImageManager > Where lock="damnyou" > > > thanks > > Jay Patton > Web Design / Application Design > Web Pro USA > p. 406.549.3337 ext. 203 > p. 1.888.5WEBPRO ext. 203 > e. [EMAIL PROTECTED] > url. www.webpro-usa.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
Emailing Question
Hi all, This may be a bit OT. Im using CFMail to send mail, though my "To" and my "From" attribute are both emails that do not have an account on my email server, and when this is the case the email will not get sent. Now my question is, is this normal behavior for an email server? (I dont mess with email servers much :) btw We are using mdeamon TIA, Jeff ~~ 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: Problem with Studio 4.5.2 help
Thanks! I found that a couple of hours ago. I'm in testing right now. Crossing my fingers. At 06:16 PM 4/25/2001 -0400, you wrote: >Jennifer, > >There is a hotfix available for the FTP problem you're having with Studio >4.5.2. You can get it from here: >http://www.allaire.com/Handlers/index.cfm?ID=20650&Method=Full > >Deb > >- Original Message - >From: "Jennifer" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, April 23, 2001 9:54 PM >Subject: Re: Problem with Studio 4.5.2 help > > > > Me too! Plus I can't get it to maintain an FTP connection while idle. I > > searched all documents for cfparam. > > > > I am so not appreciating 4.5.2! > > > > > > > ~~ 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
using variable list from a multiple select/form (warning: long)
Hello all, I am having trouble using a particular variable. This is a long email because I am trying to provide enough information to give a clear picture of my problem (which is probably quite simple and I probably should be able to solve it on my own ...) I have a form variable (called "NOTIFY") which comes from a drop-down option (dynamically populated) which allows for multiple choices. The variable arrives on the action page (where the data is inserted in a table, that works no problem) as a comma delimited list. Once it arrives at the action page, it serves two functions. It's email address creation function works beautifully. But then I need to use it to query our membership database to pull out the actual name of the person so that the email message is more user friendly ... (the CN in an email address just won't do for Dear , you know how that goes). What I think I need to do it 1. Count the number of items in the list 2. Run it through a list loop to parse each item out as a separate variable 3. Run the query to the membership database to get the UserNames, using the newly created variables. 4. Run it through a query to put it back in a new variable for output in the single email that is generated. But I don't know how to count the items or run the list loop. Can you help me? Here's the code for the select from the form, populated by an earlier query: #NOTIFY# No Report And this is what I have in the action form, so far: #get_count.RecordCount# SELECT Users.UserName FROM Users Users WHERE (Users.UserId='#form.NOTIFY#') (closes at the end of the mail, I have not included all of that...) @@@ Help!! Special thanks in advance to anyone who has a better idea of how to do this than I have had so far. :-) Oriole ~~ 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.ldb
ok i hate access. i use this to unlock this db but it wont work now does anyone else have another idea? Select * >From ImageManager Where lock="damnyou" thanks Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.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: Forcing matching selections
Gina
Here's some code I have modified, got it from a java web site.
I had the user make the selections with the checkboxes first and
build the drop downs from the checked boxes. Also if the user decides to
go back and uncheck a box, the selection is taken off the drop down. When
the user makes an order selection from the first dropdown the second is made
(minus the selection), I only did it for 3 but you can add another to make
it four.
var v;
while (control >1){
f.Selection1.options[control] = null;
control--;
}
f.Selection1.selectedIndex = 0;
control = f.Selection2.options.length;
while (control >0){
f.Selection2.options[control] = null;
control--;
}
f.Selection2.selectedIndex = 0;
control = f.Selection3.options.length;
while (control >0){
f.Selection3.options[control] = null;
control--;
}
f.Selection3.selectedIndex = 0;
if (f.acron.checked){
c = 'System Acronym';
v = '2';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
if (f.prog.checked){
c = 'Programs';
v = '3';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
if (f.serv.checked){
c = 'Service(s)';
v = '4';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
if (f.inter.checked){
c = 'Number of Interfaces';
v = '5';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
if (f.Cert.checked){
c = 'Certification';
v = '6';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
if (f.div.checked){
c = 'Division';
v = '7';
var o = new Option(c,v,false,false);
f.Selection1.options[f.Selection1.options.length] =
o;
}
}
-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 4:38 PM
To: CF-Talk
Subject: RE: Looking for a Good Search Solution
huh?
actually WHY isnt verity good for you?
you said your pages are dynamic BUT you do not want to re-index often. That
sounds like it is counter productive. dynamic pages should be indexed
often. However, you can index whenever you want... every day, week, year,
hour, min... (though i wouldnt recommend doing it in terms of minutes).
but whenever you want...
i think you need to explain your requirements a bit more in-depth to let ppl
help you out, but verity is very flexible... its all about the code...
Terry Bader
IT/Web Specialist
Macromedia Certified Coldfusion Developer
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
> -Original Message-
> From: Michael Ross [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 24, 2001 4:19 PM
> To: CF-Talk
> Subject: Looking for a Good Search Solution
>
>
> Hi all...
>
> I have been scratching my head trying to figure out a good
> searching solution. Verity just doesn't seem to work for
> me Most of the pages are dynamic and new content pages
> are added daily. I don't want to re index the site all the
> time(or is that normal).
>
> Anyone have any good idea's on how to have a search function
> that searchs all the content and page's with db content other
> than verity? Or some good tips to utilize verity better?
>
> 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
Security Question
Just wanted some input from the list We have a security system on our site. User ids and passwords are stored in a SQL 7 DB. My question is how do you secure it? Because of IS policies, access to the database is based on mixed SQL and NT authentication. Password protecting the database and the datasource are a given. But is this enough. The powers that be are concerned that storing the passwords unencrypted in the database is less than secure, and I agree. What do you all do. One thought that we have had was to set the password field to binary, then use the ToBinary and ToBase64 functions to convert text into binary before checking against the DB. Any thoughts to whether this would work or not? Any warnings/considerations? How do you all handle this aspect of security? Thank in advance for any input. Marwan Saidi Webmaster CED - Concord IS [EMAIL PROTECTED] 407.741.8645 ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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
Query Join Brain Fart
Hey everyone - Arrgh. I haven't done any of these in a while, and I'm having a little bit of a brain fart. Could somebody put these together in a join when the SQL table returned has the following columns: CandidateID, Num_Skills, BM_score If I get the example then I think (hope? dream?) that my brain might start functioning again like it should. :-) Select CandidateID, Count(*) AS num_skills FromCandidateSkills Where CandidateSkills.CandidateID IN (#ListCandidateID#) Group By CandidateID Select Sum(ExpYears) AS BM_score FromCandidateSkills Where CandidateSkills.CandidateID = #Client_saSearch.CandidateID# AND ((CandidateSkills.SkillID = #Skills1#) OR (CandidateSkills.SkillID = #Skills2#) OR (CandidateSkills.SkillID = #Skills3#)) Thank you for your time in advance, Stephen R. Cassady [EMAIL PROTECTED] http://www.ububik.com http://www.tallylist.com <--- cause' you no you waa! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: textfile parsing
I don't know if this will help but I wrote this code to do a 1 time file
load. It's not as generic as it could be but it might give you some ideas.
Import Text
#row#
Select GetMaxID from dual
Insert into news.news
(news_id, release_date, publish, contact, news_type, headline,
offset, insert_date, insert_userid)
Values
(#varID#, TO_DATE('#DateFormat(field2,'mm/dd/')#','MM/DD/'),
'Y', '#field1#', '#field4#', '#field6#',100, sysdate, 3286)
Insert into news.news_body
(news_id, part_id, part)
Values
(#varID#, #partcnt#, '#bodypart#')
--- END FILE
Duncan Hays
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 11:02 AM
To: CF-Talk
Subject:textfile parsing
Hi all,
I'm trying to parse the contents of a text file, with the ultimate aim of
putting the data in a database table. The text file contains email messages
(which may contain html code), with each new message beginning with the text
'=newmessage=' (minus quotes). I'm trying to use the listappend function
like this:
to split the file into individual messages. But, it doesn't seem to be using
the specified delimiter to split the messages. In fact I'm not sure what
it's using. The test file contains three messages but when I try to use
listtoarray and output the array there are 700 odd elements!
Any idea what's going on here? Any better way to do it?
Thanks,
Kay.
~~
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: textfile parsing
As i'm sure 50 people will tell you, "=newmessage=" in this case is your list of single character delimiters. Hence, a string like "THe RaIn " becomes a list of 4 elements: "TH"," R", "I", " ". You probably want to replace the string "=newmessage=" globally with a non-printable control character, then use that as your delimiter. You can always change it back after you're done processing. Michael Caulfield -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 10:02 AM To: CF-Talk Subject: textfile parsing Hi all, I'm trying to parse the contents of a text file, with the ultimate aim of putting the data in a database table. The text file contains email messages (which may contain html code), with each new message beginning with the text '=newmessage=' (minus quotes). I'm trying to use the listappend function like this: to split the file into individual messages. But, it doesn't seem to be using the specified delimiter to split the messages. In fact I'm not sure what it's using. The test file contains three messages but when I try to use listtoarray and output the array there are 700 odd elements! Any idea what's going on here? Any better way to do it? Thanks, Kay. ~~ 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: Design Question
Considering you want your answer in Fusebox, you should probably take it to the Fusebox list (www.houseoffusion.com). - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 8:30 AM Subject: Design Question > Ok folks I need some help with design...this is all stuff I know inside out > when I'm working with Access but am struggling when I try to put it in terms > of CF/Fusebox... > > 1. I need a login- once successfully logged in a teacher will only see > his/her students. I got that. > 2. So I need each for the teacher to choose a student (i'm trying to do > this with frames-they pick from the list on the side) and the subject that > they need to add grades for (math/english/etc)I'd like to have it so > that subjects are dynamic too (versus having separate pages for each subject > with the subject hardcoded by courseID... I'd prefer a table to fill with > whichever subject was chosen). > a. The teacher should have the choice if she/he wants to do 1 > student all subjects (which will take several "pages"- probably 5-6 to get > through all the subjects + all the subcategories (ie: reads fluently/is > cooperative...) So the teacher needs to be able to go through this page by > page, doing an update at the end of each page (don't want them to lose too > much info if power goes out) > b. The teacher should be able to do the whole class by subject. ie: > she/he picks math and each page has a different student/same subject. > (update being saved after each student page is complete-as teacher goes to > next student. > > So they'd be filtered on several different levels. > I'm trying to figure out how to do all of this without it being unweildy- > (ie: to hook teacher-student 3 tables are involved. To add a grade there > are 4 tables- one with student info/one to hold the grade and 2 reference > tables-one for the subject and one for all the subtopics of each > subject)Or maybe more appropriately I'm trying to figure out how to chop > it up appropriately. > In Access I would make a main form and add all the subforms. The > subforms would use specific updatable queries. The subforms would be > attached to the mainform by some primary/foreign key combo. (so I could > have 10 different subforms hooked to the main form) How do I accomplish this > in CF/Fusebox? Right now I have lots of pieces but they are not > attached--how should I stitch this together? > I wrote up a bunch of fusedocs but now I'm second guessing everything > Any ideas? > > > 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: ' in SQL 2000
This is the error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax
near 'pain'.
(I've also re-arranged the fields list, and tried putting it in the middle
of the SQL, at the end, etc. and it always chokes on the first item in
the list)
Thanks!
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: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 11:38 AM
To: CF-Talk
Subject: RE: ' in SQL 2000
what error message are you getting? Can you post it here.
I've had problems in the past with using dynamic field names in SQL. Again
try building up an SQL string and executing it
--
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: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: 25 April 2001 16:13
To: CF-Talk
Subject: RE: ' in SQL 2000
OKhere is code :)
This generates the SQL lists:
select company, address, addressline2, city, state, zip, country,
region,
corebus, phone1, phone2, cell, email, email2, pager, fax, prename, fname,
mname, lname, sufname, nickname, homephone, website, leadfrom, status,
annualrev, employees, assignedto, notes, bio, birthday, title, department,
assistant, assistanttitle, assistantemail, assistantphone, homeaddress,
homeaddressline2, homecity, homestate, homezip, homecountry, probability,
firstcontact, enterdate, #findlist#
from leads
where leadID=#leadID# and companyID = #companyID#
The above query works fine.
This is the query that chokes:
set nocount on
insert into projects (#steps#, clientID, userID, contacts,
projectname,
startdate, status, leadfrom, probability)
values (#stepsdata#, #getclient.newID#, #get.assignedto#,
'#getcontact.newID#', 'New Opportunity', '#today#', 'active',
'#get.leadfrom#', 0#get.probability#)
select @@identity as newID
set nocount off
And, here is the output from the above SQL (cut and pasted into a
):
insert into projects
(smstep1note,smstep1,smstep1date,smstep2note,smstep2,smstep2date,smstep3note
,smstep3,smstep3date, clientID, userID, contacts, projectname, startdate,
status, leadfrom, probability)
values
('pain','yes','11-Apr-01','budget','yes','11-Apr-01','deadline','yes','16-Ap
r-01', 84, 1, '67', 'New Opportunity', '4/25/2001', 'active', 'magazine ad',
0.30)
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: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 10:28 AM
To: CF-Talk
Subject: RE: ' in SQL 2000
perhaps you could post the code you're using. we could take a look.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 9:42 AM
To: CF-Talk
Subject: ' in SQL 2000
I'm having a frustrating problem
I have several queries in which I'm composing the SQL statement and then
inserting it into the query through a variable (Necessary because I'm
looping through a list to get the fieldnames and values).
e.g.:
then in the query:
insert into table1(#list1#)
values (#list2#)
When I output the generated SQL, it looks perfectbut SQL seems to be
having a problem with the ' (single quotes) surrounding strings I've
tried preservesinglequotes(), using chr(39), etc...and I still get
syntax errors on insert or update. When I take the output data and manually
insert it into the query, it works fine - eliminating the possibility of
data type errors.
I've tried this with 4 different queries, with the same results.
I've now run out of thi
Re: using NT accounts for username/password login authentication
How would you go about accessing the NT accounts and use those username/password for login authentication rather than accessing an MS Access database? Has anyone done this before? ~~ 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: textfile parsing
Try using ReplaceNoCase to replace "=newmessage=" with a single character like "|". Then use list append with the "|" > The delimiter field of cf's list functions specifies which > *single-character* delimiters will be recognized. > > HTH > > Dick > > At 11:01 PM +0800 4/25/01, Kay Smoljak wrote: > >Hi all, > > > >I'm trying to parse the contents of a text file, with the ultimate aim of > >putting the data in a database table. The text file contains email messages > >(which may contain html code), with each new message beginning with the text > >'=newmessage=' (minus quotes). I'm trying to use the listappend function > >like this: > > > > >"=newmessage=")> > > > >to split the file into individual messages. But, it doesn't seem to be using > >the specified delimiter to split the messages. In fact I'm not sure what > >it's using. The test file contains three messages but when I try to use > >listtoarray and output the array there are 700 odd elements! > > > >Any idea what's going on here? Any better way to do it? > > > >Thanks, > >Kay. > > > ~~ 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 Jobs and Projects
http://hotjobs.com http://monster.com your local online news paper Allayer/MM website - Forums - Job Postings Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:31 AM To: CF-Talk Subject: CF Jobs and Projects Are there any CF Jobs or Projects that you know about ... Please message me OFF the LIST at [EMAIL PROTECTED] 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: ' in SQL 2000
Sorry diannaforgot to explain To build a SQL string in a stored proc you need to declare a variable and then build up the string eg: DECLARE @sqlstring as varchar(2000) SELECT @sqlstring = "Select * FROM table WHERE field = " & @field & etc... Then execute the string once you have built it up by doing EXEC(sqlstring) I'm not sure this will solve your problem although it may. As I said before I have encountered problems before where SQL didn't like dynamic field names. -- 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: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 16:16 To: CF-Talk Subject: RE: ' in SQL 2000 I'm not sure what you mean by "build up a sql string in SQL and execute it using EXEC(sqlstring)" .. (Recent convert from Access to SQL - and still learning the tools) ?? Thanks! 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: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 10:11 AM To: CF-Talk Subject: RE: ' in SQL 2000 Can you output the generated SQL and post it to this list. In the meantime you could always try to build up a sql string in SQL and execute it using EXEC(sqlstring) to see if this works. Sometimes I've found it makes a difference -- 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: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:42 To: CF-Talk Subject: ' in SQL 2000 I'm having a frustrating problem I have several queries in which I'm composing the SQL statement and then inserting it into the query through a variable (Necessary because I'm looping through a list to get the fieldnames and values). e.g.: then in the query: insert into table1(#list1#) values (#list2#) When I output the generated SQL, it looks perfectbut SQL seems to be having a problem with the ' (single quotes) surrounding strings I've tried preservesinglequotes(), using chr(39), etc...and I still get syntax errors on insert or update. When I take the output data and manually insert it into the query, it works fine - eliminating the possibility of data type errors. I've tried this with 4 different queries, with the same results. I've now run out of things to try..Ideas? TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long ~~ 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
Design Question
Ok folks I need some help with design...this is all stuff I know inside out when I'm working with Access but am struggling when I try to put it in terms of CF/Fusebox... 1. I need a login- once successfully logged in a teacher will only see his/her students. I got that. 2. So I need each for the teacher to choose a student (i'm trying to do this with frames-they pick from the list on the side) and the subject that they need to add grades for (math/english/etc)I'd like to have it so that subjects are dynamic too (versus having separate pages for each subject with the subject hardcoded by courseID... I'd prefer a table to fill with whichever subject was chosen). a. The teacher should have the choice if she/he wants to do 1 student all subjects (which will take several "pages"- probably 5-6 to get through all the subjects + all the subcategories (ie: reads fluently/is cooperative...) So the teacher needs to be able to go through this page by page, doing an update at the end of each page (don't want them to lose too much info if power goes out) b. The teacher should be able to do the whole class by subject. ie: she/he picks math and each page has a different student/same subject. (update being saved after each student page is complete-as teacher goes to next student. So they'd be filtered on several different levels. I'm trying to figure out how to do all of this without it being unweildy- (ie: to hook teacher-student 3 tables are involved. To add a grade there are 4 tables- one with student info/one to hold the grade and 2 reference tables-one for the subject and one for all the subtopics of each subject)Or maybe more appropriately I'm trying to figure out how to chop it up appropriately. In Access I would make a main form and add all the subforms. The subforms would use specific updatable queries. The subforms would be attached to the mainform by some primary/foreign key combo. (so I could have 10 different subforms hooked to the main form) How do I accomplish this in CF/Fusebox? Right now I have lots of pieces but they are not attached--how should I stitch this together? I wrote up a bunch of fusedocs but now I'm second guessing everything Any ideas? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ' in SQL 2000
what error message are you getting? Can you post it here.
I've had problems in the past with using dynamic field names in SQL. Again
try building up an SQL string and executing it
--
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: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: 25 April 2001 16:13
To: CF-Talk
Subject: RE: ' in SQL 2000
OKhere is code :)
This generates the SQL lists:
select company, address, addressline2, city, state, zip, country,
region,
corebus, phone1, phone2, cell, email, email2, pager, fax, prename, fname,
mname, lname, sufname, nickname, homephone, website, leadfrom, status,
annualrev, employees, assignedto, notes, bio, birthday, title, department,
assistant, assistanttitle, assistantemail, assistantphone, homeaddress,
homeaddressline2, homecity, homestate, homezip, homecountry, probability,
firstcontact, enterdate, #findlist#
from leads
where leadID=#leadID# and companyID = #companyID#
The above query works fine.
This is the query that chokes:
set nocount on
insert into projects (#steps#, clientID, userID, contacts,
projectname,
startdate, status, leadfrom, probability)
values (#stepsdata#, #getclient.newID#, #get.assignedto#,
'#getcontact.newID#', 'New Opportunity', '#today#', 'active',
'#get.leadfrom#', 0#get.probability#)
select @@identity as newID
set nocount off
And, here is the output from the above SQL (cut and pasted into a
):
insert into projects
(smstep1note,smstep1,smstep1date,smstep2note,smstep2,smstep2date,smstep3note
,smstep3,smstep3date, clientID, userID, contacts, projectname, startdate,
status, leadfrom, probability)
values
('pain','yes','11-Apr-01','budget','yes','11-Apr-01','deadline','yes','16-Ap
r-01', 84, 1, '67', 'New Opportunity', '4/25/2001', 'active', 'magazine ad',
0.30)
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: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 10:28 AM
To: CF-Talk
Subject: RE: ' in SQL 2000
perhaps you could post the code you're using. we could take a look.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 9:42 AM
To: CF-Talk
Subject: ' in SQL 2000
I'm having a frustrating problem
I have several queries in which I'm composing the SQL statement and then
inserting it into the query through a variable (Necessary because I'm
looping through a list to get the fieldnames and values).
e.g.:
then in the query:
insert into table1(#list1#)
values (#list2#)
When I output the generated SQL, it looks perfectbut SQL seems to be
having a problem with the ' (single quotes) surrounding strings I've
tried preservesinglequotes(), using chr(39), etc...and I still get
syntax errors on insert or update. When I take the output data and manually
insert it into the query, it works fine - eliminating the possibility of
data type errors.
I've tried this with 4 different queries, with the same results.
I've now run out of things to try..Ideas?
TIA!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~
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: my CFSELCT is not working with attributes
This is a bug/feature with CFSELECT. In order for the require to work, you need to make the size="2". Otherwise you need to make a javascript validation function. I always wished they would fix that so that option "0" could be used as a not-selected value. Mary Hi Guys please Guide me , i am using a required="yes" for cfselect and it is not validating my code CA Staff Liaison Support Kindly help me out -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: textfile parsing
The delimiter field of cf's list functions specifies which *single-character* delimiters will be recognized. HTH Dick At 11:01 PM +0800 4/25/01, Kay Smoljak wrote: >Hi all, > >I'm trying to parse the contents of a text file, with the ultimate aim of >putting the data in a database table. The text file contains email messages >(which may contain html code), with each new message beginning with the text >'=newmessage=' (minus quotes). I'm trying to use the listappend function >like this: > >"=newmessage=")> > >to split the file into individual messages. But, it doesn't seem to be using >the specified delimiter to split the messages. In fact I'm not sure what >it's using. The test file contains three messages but when I try to use >listtoarray and output the array there are 700 odd elements! > >Any idea what's going on here? Any better way to do it? > >Thanks, >Kay. > ~~ 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 Jobs and Projects
Are there any CF Jobs or Projects that you know about ... Please message me OFF the LIST at [EMAIL PROTECTED] 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: Cfmail
It probably is getting through, but is taking longer. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com - Original Message - From: "Heidi Belal" <[EMAIL PROTECTED]> Newsgroups: gradwell.lists.cftalk Sent: Wednesday, April 25, 2001 3:45 PM Subject: Cfmail > Hi! > I have a question regarding cfmail. It's really > strange. I used the cfmail tag to send an email, but > it is not going through to the webemails such as > excite, yahoo, hotmail..etc..but it goes through to my > pop3 account just fine. > Does anybody have an idea why that would be case or > how to fix it? > thanks! > > = > Heidi Belal > ICQ# 32127109 > http://m3.easyspace.com/hmbelal > > A bus stops at a bus station. > A train stops at a train station. On my desk > I have a work station... > ~~ 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: ' in SQL 2000
Wish it was that easy.that was my first guess, though. (See the code I posted in another message). Thanks anyway! 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: Christopher Cortes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:02 AM To: CF-Talk Subject: RE: ' in SQL 2000 Diana, Could you by chance have stray single quotes in the data you are trying to insert? - Chris Christopher Cortes |Coming Q3 2001: Consultant | Stonebridge Technologies, Inc. | Optimizing ColdFusion Putting Technology To Work | By Visit us at www.sbti.com | Christopher Cortes Ofc: 713.985.6244 cel: 281.235.6100 | www.osborne.com <---!> -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 8:42 AM To: CF-Talk Subject: ' in SQL 2000 I'm having a frustrating problem I have several queries in which I'm composing the SQL statement and then inserting it into the query through a variable (Necessary because I'm looping through a list to get the fieldnames and values). e.g.: then in the query: insert into table1(#list1#) values (#list2#) When I output the generated SQL, it looks perfectbut SQL seems to be having a problem with the ' (single quotes) surrounding strings I've tried preservesinglequotes(), using chr(39), etc...and I still get syntax errors on insert or update. When I take the output data and manually insert it into the query, it works fine - eliminating the possibility of data type errors. I've tried this with 4 different queries, with the same results. I've now run out of things to try..Ideas? TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long ~~ 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: ' in SQL 2000
I'm not sure what you mean by "build up a sql string in SQL and execute it using EXEC(sqlstring)" .. (Recent convert from Access to SQL - and still learning the tools) ?? Thanks! 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: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 10:11 AM To: CF-Talk Subject: RE: ' in SQL 2000 Can you output the generated SQL and post it to this list. In the meantime you could always try to build up a sql string in SQL and execute it using EXEC(sqlstring) to see if this works. Sometimes I've found it makes a difference -- 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: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:42 To: CF-Talk Subject: ' in SQL 2000 I'm having a frustrating problem I have several queries in which I'm composing the SQL statement and then inserting it into the query through a variable (Necessary because I'm looping through a list to get the fieldnames and values). e.g.: then in the query: insert into table1(#list1#) values (#list2#) When I output the generated SQL, it looks perfectbut SQL seems to be having a problem with the ' (single quotes) surrounding strings I've tried preservesinglequotes(), using chr(39), etc...and I still get syntax errors on insert or update. When I take the output data and manually insert it into the query, it works fine - eliminating the possibility of data type errors. I've tried this with 4 different queries, with the same results. I've now run out of things to try..Ideas? TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long ~~ 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
