To Jeff Whatcott - Cost Structuring

2001-05-01 Thread Eric Root
I appologize ahead of time if it is inappropriate to continue to offer feedback to Jeff Whatcott in this forum. I wanted to make a point while Jeff has his ear to the ground, then I will do my best to stay off line G. I once worked for a prestigious engineering firm. In the late eighties, a

not displaying the action page

2001-05-01 Thread Mark Smyth
Hi everone i'm trying to force a submitted form page that is being browsed using the back button to display the following message. Warning: Page has Expired The page you requested was created using information you submitted in a form. This page is no longer available. As a security

RE: Printing a structure in sorted order (repost)

2001-05-01 Thread Thomas Chiverton
i.e. sort by value (in perl foreach $name (sort {$r{$b} = $r{$a} } keys %r) does the same thing) Well, I've written it and posted it off to the allaire DevX :-) http://devex.allaire.com/developer/gallery/info.cfm?ID=C9C4AFF9-3A94-11D5-83 F400508B94F380method=Full

RE: can GIF can caught virus?

2001-05-01 Thread Thomas Chiverton
Yes. For instance, there was a problem with Netscape and GIF's a while back, and there is an overflow in the Flash player, though not yet exploitable. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 30 April 2001 18:15 To: CF-Talk Subject: can GIF can

Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE

Making VisBasic into a com object

2001-05-01 Thread Mike Kear
I asked one of my client's programmers for some info on how the database is organised for our web site, and what he's given me is a VBScript ASP page. I can see the function calls and subroutines in the file, which is 536 lines long. Can I take these functions and use them in CF somehow without

Re: Making VisBasic into a com object

2001-05-01 Thread Jeffry Houser
At 09:08 PM 05/01/2001 +1000, you wrote: I asked one of my client's programmers for some info on how the database is organised for our web site, and what he's given me is a VBScript ASP page. I can see the function calls and subroutines in the file, which is 536 lines long. If I understand

Re: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Bud
On 5/1/01, Thomas Chiverton penned: I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. Nope, its an Acess ODBC datasource, and the field is marked as text, length 50. Next :-) Regards, Thomas Chiverton Intranet Architect and

1000s of SQL updates

2001-05-01 Thread Michael Lugassy
I'm trying to find the best possible way to update 1000s of SQL records at a time. I currently have a huge list that has all the colum values that need to have the change made (set the date to NOW()). Is there a better way then: SET colum=value WHERE CFLOOP listcolum=#listitem# OR /CFLOOP

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Erika L Walker
If the field is marked as text, shouldn't there be ticks around the variables then? Like so: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = '#form.skill#' /cfquery Is uderid a text field or is skill a text

Re: Verity creating duplicate records

2001-05-01 Thread Judith Taylor
You need to purge your collection before you update it. In the docs, it states that Verity will do just what you are describing. I have a little demo that I did for our local CFUG (MidOhioValley) where I have this little tidbit: CFINDEX ACTION=PURGE This action basically deletes all the data

RE: More locking confusion...

2001-05-01 Thread Raymond Camden
** Macromedia Representative ** I think the author _implied_ that you should use duplicate() instead of 'cfset', but simply didn't say it. I haven't read the whole article, so I could be wrong. Anyway, you are correct. If you want to use the Request scope

RE: 1000s of SQL updates

2001-05-01 Thread Andy Ewings
Nopeanyway the code you have suggested won't work anyway as you will have an extra OR at the end of your SQL statement. Just one point to make. If your table that you are updating is being used for transactions (updates, selects, inserts) on a regular basis then you should rethink your

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Andy Ewings
Get the value of the vars and run it directly in the db so you get a meaningfull error message -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
If the field is marked as text, shouldn't there be ticks around the Only 'note' is a text field, all the others are interger fields, and work fine (see bit in original post about the previous query). ~~ Structure your ColdFusion code with

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
Get the value of the vars and run it directly in the db so you get a meaningfull error message How do you do that for Access ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

CFEXPRESS

2001-05-01 Thread savan . thongvanh
the cfexpress page tells the goods about it but it doesn't compare cfexpress and it next bigger version. What's the diff? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Andy Ewings
Create a query and use the SQL view -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
access has its own query tool. you can even do it within CF studio. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 5:46 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Get the value of the vars and

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
have you tried outputting those variables to make sure they're what you expect (ie - not null)? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 3:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have:

Verity Indexing a Remote Server

2001-05-01 Thread Bryan Batchelder
I am trying to create a verity collection that indexes a share on a remote server. (We have 2 front end clustered webservers, and a static data server - I am trying to index files on the static server, via a UNC path) I believe the systems are set up properly in regards to the user which the CF

Really large recordsets (40,015 records) won't return

2001-05-01 Thread Gina . M . Shillitani
I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION

RE: CFEXPRESS

2001-05-01 Thread James Maltby
Next one up is Professional - you have a much wider range of functionality like CFX and custom tag generation, wddx, cfupdate etc. - you can link to a much wider range of odbc data-sources, you get verity search engine and loads of other stuff - the one up from that is Enterprise - which is the

Re: List Functions

2001-05-01 Thread Loryn C Williams
Thank you ALL! I have it running now. You guys are great! Maybe one day I'll know enough to actually be able to contribute to the list as well. Thank you again, Loryn Williams Robert Segal wrote: Sorry,, typo, theloop should be thelist -Original Message- From: L Williams

Re: More locking confusion...

2001-05-01 Thread Ken Wilson
use Duplicate(), and make sure you have the Duplicate() hotfix applied. The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or

Re: CFEXPRESS

2001-05-01 Thread Howie Hamlin
Try this: http://www.allaire.com/documentcenter/partners/cf5_matrix.pdf 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: [EMAIL PROTECTED]

RE: Really large recordsets (40,015 records) won't return

2001-05-01 Thread Andy Ewings
Depends what you want it to do. I'd suggest indexing your tables so you have optimum performance and then limit the number of records returned by the DB. I can't imagine you want to display all 40,000 recs do you? -- Andrew

Re: CFEXPRESS

2001-05-01 Thread Howie Hamlin
Sorry - my last answer was not correcttry this: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition %20Comparison%20MatrixCache=False Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail

RE: Really large recordsets (40,015 records) won't return

2001-05-01 Thread Jones, Matt
That is too much to get the browser to render at a time, narrow the display results, if not the recordset. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:59 AM To: CF-Talk Subject: Really large recordsets (40,015 records) won't

Re: Really large recordsets (40,015 records) won't return

2001-05-01 Thread Dave Hannum
Part of the problem is that browsers just are not made to handle 40,000+ records, especially if the code is not really tight. CF can generate an awful lot of white space if you're not careful. Depending on how much info is in each record, the page you're trying to return is could very well be

Re: Really large recordsets (40,015 records) won't return

2001-05-01 Thread Jeffry Houser
What application do you need that is going to return that many records? You aren't planning on giving the user a single list of all records, are you? It may be better if you break up the list somehow. You can start by using 'top 1 * from mytable' to return the top row from your

RE: More locking confusion...

2001-05-01 Thread Raymond Camden
** Macromedia Representative ** Sorry, I don't know about the Pro version. You may want to try contacting Support? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

RE: More locking confusion...

2001-05-01 Thread Dave Watts
The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving

RE: More locking confusion...

2001-05-01 Thread Jeff Sarsoun
Was duplicate() not broken previous to sp2? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 10:15 AM To: CF-Talk Subject: RE: More locking confusion... The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say

RE: Feedback to Jeff Whatcott - Macromedia

2001-05-01 Thread Darren Adams
I think cfexpress was onthe cover DVD of PCPLUS last month. Previous to that I had not heard of it before. -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 00:27 To: CF-Talk Subject: Re: Feedback to Jeff Whatcott - Macromedia Yeah, I remember there

RE: OT but VIQ: Denial of Service Attacks - UPDATE

2001-05-01 Thread Dave Watts
Well, to those who are interested, I've combed through the log files. Found my attacker and even the commands he executed to put up those pages. (PoisonBOx..blah..blah...blah) ---not that I've caught the creep. That won't happen! :) The client is still installing patches, and we're

RE: IIS 5 and CF 4.5.1 sp2

2001-05-01 Thread Dave Watts
I keep getting this error on my 2000 Professional and 2000 Advanced Server. Any help. The HTTP Filter DLL C:\CFUSION\BIN\ISCFFILT.DLL failed to load. The data is the error. You can either disregard this error (it's harmless), or remove the filter - it's not needed by CF, which uses a

RE: DevCon Europe? Asia? Anywhere Outside the U.S.?

2001-05-01 Thread Darren Adams
Arent there in in europe ? -Original Message- From: GG Hamer [mailto:[EMAIL PROTECTED]] Sent: 30 April 2001 22:46 To: CF-Talk Subject: DevCon Europe? Asia? Anywhere Outside the U.S.? Can anyone identify for me major non-U.S. developer conferences? I know that in the U.S. there will be

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill =

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Andy Ewings
woah...touchy.that'll teach you to offer help Dylan! Can you tell us exactly what datatypes all three fields are in the db. What happened when you ran the query directly in Access? -- Andrew Ewings Project Manager

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)
I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no

I'm sure this worked earlier

2001-05-01 Thread Darren Adams
Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it

Fw: [cold_fusion] Why ColdFusion Is Still Relevant (IntenetWorld)

2001-05-01 Thread Howie Hamlin
MessageFYI - from another list... 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: Robert Baker To: [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001

Re: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread David E. Crawford
Well, your post is not particularly clear. Have you tried running that exact query inside Microsoft Access? Assuming that note is a text field (character) and that userid is numeric and skill is numeric, this query should work just fine. However, if it doesn't work in Access directly it won't

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
no need to get testy :) it's perplexing. i checked the reserved word list for access (i thought NOTE might be) but nothing is in the reserved word list that you're using. what about the code immediately before or after the CFQUERY? anything there that looks suspicious? if you could post more of

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Scott Brader
I've also been caught on more than one occasion passing a userid as a number when it is, in fact, a string in the database. Just a thought. Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Howarth, Craig (IBK-NY)
Is note a reserved word in Access? Try [note] = 'dr'. Craig -Original Message- From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
that may be, but i don't think that would throw a SYNTAX error. it just wouldn't update the field. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
heh no doubt. :) -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:00 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? woah...touchy.that'll teach you to offer help Dylan! Can you tell us exactly what

Re: Verity Indexing a Remote Server

2001-05-01 Thread Bryan LaPlante
Have you tried referring to the share as a drive like G:\Server\Path\To\My\Files where G is the drive letter assigned to the share. - Original Message - From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:11 AM Subject: Verity Indexing a

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
Create a query and use the SQL view The paperclip rather helpfuly says 'Syntax error in update statement' when I try and save update con_list set note = 'dr' where userid = 32715281 and skill =1; ~~ Structure your ColdFusion code with Fusebox. Get

RE: I'm sure this worked earlier

2001-05-01 Thread Dylan Bromby
can you provide the datatypes of the fields? -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:04 AM To: CF-Talk Subject: I'm sure this worked earlier Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code =

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
Can you tell us exactly what datatypes all three fields are in the db. note is 'Text', size 50. userid, skill and skill_level are 'Number', size 'long integer'. userid and skill form the primary key. ~~ Structure your ColdFusion code with

Re: OT (maybe?): IIS5 CF authentication prob

2001-05-01 Thread Bryan LaPlante
That is the one that works for me is to go to the advanced user rights and set permission to log on to the server locally. Are you using IIS challenge response or any additional authentication? Bryan - Original Message - From: Cold Fusion [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, Technically the critera you want to update doesn't exist any more there for no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be

ODBC is EXTREMELY SLOW!

2001-05-01 Thread Craig Bowes
Hi all. I have a machine running one website that doesn’t get that much traffic. It has 2 drives, with windows on the C: drive and the databases and coldfusion sites on the D: drive. The D: drive has about 1.5 GB free, but the C: only has about 300MB free, so I wonder if the low HD space is

OT: Dreamweaver Site preferences/setting

2001-05-01 Thread savan . thongvanh
I'm testing dreamweaver in a thin environment and my application settings are not being saved. I'm sure that this is because i'm on thin and it's on a test box. where does DW save the site settings? could i copy the file to my network dir and just stick it back into the DW dir when I want to

RE: I'm sure this worked earlier

2001-05-01 Thread Thomas Chiverton
Your insert is probably breaking a constraint in the table, or the Access datasource is open in design view (close Access, use 'fix' option in ODBC admin.). Probably :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at

OT: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
Well, your post is not particularly clear. Have you tried Sorry, sorry :-/ Been banging this all day, and I've tried the obvious things 8 times already :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at

sql server 2000

2001-05-01 Thread Jay Brushett
Hi, I was wondering if someone could help me. I need to connect to SQL Server using OLE. I'm not sure exactly what needs to be done inside the administrator (if anything) and inside cfquery. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED]

Re: I'm sure this worked earlier

2001-05-01 Thread Art Broussard
Check your last query. You have an extra ) where you list your values This '#oldnews[i].expdate#'), should be this '#oldnews[i].expdate#', cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Thomas Chiverton
it's perplexing. i checked the reserved word list for access (i thought NOTE might be) but nothing is in the reserved word list that you're using. :nods Thought of that too :-/ what about the code immediately before or after the CFQUERY? anything there that looks suspicious? Snipit

RE: Verity Indexing a Remote Server

2001-05-01 Thread Bryan Batchelder
Is that possible without someone being logged in to the server? I mean, UNC's should work. If they don't, then this particular site will be taken out of the cluster...its just not worth the work needed to make it compatible. I am curious though...is anyone out there doing a verity index on a

RE: Update in CFquery is failing, somone code check this ? FIXED

2001-05-01 Thread Thomas Chiverton
Is note a reserved word in Access? Try [note] = 'dr'. ** Genius ** You win... searches franticly around desk a poster of the current Dell server line. Mail me your address of list :-) Thanks to all the others, hope I didnt annoy you too much.

RE: I'm sure this worked earlier

2001-05-01 Thread Darren Adams
they are all text/memo apart from the date fields. The live fields are boolean field types. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:18 To: CF-Talk Subject: RE: I'm sure this worked earlier can you provide the datatypes of the fields?

RE: MOD2 variation

2001-05-01 Thread Bruce Heerssen
In the past I have used this statement to vary the color of a table row to simulate the 'green bar effect'. tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# Is there a way to modify this so that in the output of a query a br would be output every second row and a

Re: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Howie Hamlin
Maybe that's why he's now out of a job g Seriously, though - have you tried putting square brackets around the word note? Regards, 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

Re: I'm sure this worked earlier

2001-05-01 Thread Joshua Meekhof
Darren, I have a few questions / comments. 1) Why do you convert the query, which is conceptually a structure of arrays into an array of structures? 2) Why don't you insert the records into the data base in one step? e.g. cfquery insert into pressoffice

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
i already checked. according to MS, it's not. here's a list of what are reserved: http://support.microsoft.com/support/kb/articles/Q109/3/12.asp -Original Message- From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:10 AM To: CF-Talk Subject: RE:

RE: I'm sure this worked earlier

2001-05-01 Thread Bruce Heerssen
It would also help if you can post the error message. -Bruce -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 10:18 AM To: CF-Talk Subject: RE: I'm sure this worked earlier can you provide the datatypes of the fields?

RE: I'm sure this worked earlier

2001-05-01 Thread Darren Adams
Access hasnt been open for about 10 mins. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:25 To: CF-Talk Subject: RE: I'm sure this worked earlier Your insert is probably breaking a constraint in the table, or the Access datasource is open in

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)
Cant see anything wrong with the syntax, have you tried removing the spaces before and after all the ='s in the query string,shouldn't make a difference but worth trying. is the DSN correct? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
you have skill and skill_level. my guess is *you* mixed them up. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:22 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the

RE: [cold_fusion] Why ColdFusion Is Still Relevant (IntenetWorld )

2001-05-01 Thread Aidan Whitehall
Received this email from InterntWorld (www.internetworld.com) Here is the online version: http://www.internetworld.com/news/archive/05012001a.jsp Enjoy! If Macromedia hadn't rescinded the ColdFusion Server Hosting license idea, I'd have had difficulty believing this: Jeremy Allaire, who has

RE: sql server 2000

2001-05-01 Thread Matthew Fusfield
The administrator setup is similar to the setup for an ODBC datasource; the main difference is you must type in SQLOLEDB in the provider field...other than that, setting your server database names as well as username and password are the same. The datasource name used in cfquery is whatever you

RE: I'm sure this worked earlier

2001-05-01 Thread Darren Adams
Yes you are correct but it is commented out so surely this would not make a difference ? the code is commented out so that it just deals with the headline. -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:32 To: CF-Talk Subject: Re: I'm sure this

RE: sql server 2000

2001-05-01 Thread Mike Brunt
** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you. http://www.allaire.com/Support/KnowledgeBase/SearchForm.cfm then select article ID's 14709, 14632. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255

RE: Update in CFquery is failing, somone code check this ? FIXED

2001-05-01 Thread Dylan Bromby
someone better tell MS to update their list of reserved words for access. ;) it wasn't in the list. maybe that's new to access2000 (if that's what you're using). -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:46 AM To: CF-Talk

Re: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Tim Painter
I am not sure if it is the way the mail wrapped the text, but is there a carriage return after skill = ? If so, then the query may be trying to pass a carriage return with the #form.skill# (I just ran into this a couple of days ago) Tim P. - Original Message - From: Thomas Chiverton

cfdirectory delete

2001-05-01 Thread river
When I try to delete or rename a folder with cfdirectory it sometimes gives me an error message saying that the folder access is denied. Is there any work-around to this problem? thanks for any help. ~~ Structure your ColdFusion code with

question using IIf

2001-05-01 Thread David Baskin
I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
i sent this email at 8:56am this morning and got it at 9:55am from the list. zoiks! -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:56 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? i already checked.

Studio - File types

2001-05-01 Thread David Shadovitz
*** Team Nobody *** In CF Studio's Extended Find dialog, if you set Find where to In folder, you can restrict the search to certain file types. For example, one group of file types is {*.htm;*.html;*.cfm;*.cfml}. I'd like to create my own group

Re: I'm sure this worked earlier

2001-05-01 Thread Bud
On 5/1/01, Darren Adams penned: Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few

Re: question using IIf

2001-05-01 Thread Michael Dinowitz
* Team Allaire * IIF is way slower than the equivalent CFIF. This does the same thing and is faster. tr bgcolor=CFIF qName.CurrentRow MOD 2ffCFELSEe8e8e8/CFIF I've been told that we should never use IIF and i just took that on blind

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Dylan Bromby
my guess - now that we all know the answer - is i'm wrong :). darn list speed :). -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:04 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? you have skill and

Re: Dreamweaver Site preferences/setting

2001-05-01 Thread tom muck
Site settings are stored in the Registry. Look in HKEY_CURRENT_USER\\Software\\Macromedia\\Dreamweaver 4\\Sites\\ tom www.basic-ultradev.com [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm testing dreamweaver in a thin environment and my application

Microsoft Word Summary Data

2001-05-01 Thread Lundin, William
Does anyone have a tag that will pull in the summary data available from a MS Word file ? If not a tag, then if any has done this some other way. Thanks. Bill Lundin WeBS Group Factory Mutual Insurance Company 401-275-3000 x1380 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

RE: sql server 2000

2001-05-01 Thread Jay Brushett
Thanks to all who responded. I found the answer in the knowledge base articles. Jay At 12:31 PM 5/1/2001 -0400, you wrote: ** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you.

RE: question using IIf

2001-05-01 Thread Daniel H
I think #IIF()# just takes longer to evaluate than Cfif or the even faster cfswitch... At leasts that what I have gathered from others experience and from classes. HTH Dan -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:55 PM To: CF-Talk

JOIN queries from two datasources

2001-05-01 Thread Diana Nichols
Sorry if this has been asked before Can I join two queries from two different datasources (SQL 2000)? I need to relate the username/userID from source 1 to userID from source 2. (If it's too difficult, I'll just copy the username into source 2). TIA! D * Diana Nichols

RE: question using IIf

2001-05-01 Thread Evan Lavidor
I recently picked up a copy of Ben Forta's Certified CF Study Guide. One of the last chapters is about speed and optimization, and it states that IIF(), DE() and Evaluate() are all very slow functions, and while they have their time and place, can and perhaps should often be avoided (Ben,

RE: Studio - File types

2001-05-01 Thread Nicole Ambrose
You can type the file type directly into the file types drop-down. Select an existing file type, highlight it, then type in the file type you want. You can then perform a search on that file type, and the next time you do an Extended Find, that file type will display in your drop-down list.

Re: question using IIf

2001-05-01 Thread stas
Latest CFDJ states that iif takes 4 times as long to execute as cfifcfelse/cfif. The provide a snippet of code to test. - Original Message - From: David Baskin [EMAIL PROTECTED] I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it

Re: CF-Talk-list V1 #306

2001-05-01 Thread Mark Smeets
Any idea how you can turn a certain area of a webpage into a viewing pdf area? I want a certain area on my webpage to open up to a pdf file, not an entirely brand new window (or take up the current one) (and not necessarily use frames either...which I guess could be a cfinclude) Mark

RE: More locking confusion...

2001-05-01 Thread mjohnson
If someone does find the link for the patch could you please post it here. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:15 AM To: CF-Talk Subject: RE: More locking confusion... The hotfix download page says the problem exists in

RE: Studio - File types

2001-05-01 Thread Bruce Heerssen
You can do it with a simple registry hack. 1) In regedit, open the key HKCU/Software/Allaire/Studio45/SavedSettings/ExtendedFindFolder. 2) Add a new string value Item10. Set the value to your new extension. if more than one, use commas to separate (ie: *.abc,*.def). I tried it on mine (CFS

RE: Studio - File types

2001-05-01 Thread John Wilker
If I understand correctly you want a new option in that drop down of file types. All you have to do is type in that drop down the type you want to search and it will remember that type from then on and it will be in the drop down list. Does that help? J. John Wilker Web Applications

RE: question using IIf

2001-05-01 Thread Bryan Batchelder
I can attest to that statement. We had a custom tag that used those three functions HEAVILY - iif, de, and evaluate. It was very very very very slow. Unfortunately for us, it is the core of our application - so it was rewritten as a CFX, then a COM component, and not it is a hybrid COM/XML

  1   2   >