RE: Temporary Tables

Josh, Eventually as in the current connection. Thanks for the detailed response. Sam --- On Sat 05/18, Joshua Tipton wrote: Eventually as in the current connection or eventually as in sometime this week? Temp table straight out of books online You can create local

Looping through file-fields

Hi, I need to loop through 5 form-file-fields. Each one is called file with a number from 1-5 appended to it, i.e. file1. This seems an easy idea, but I'm having trouble with it. If a file *has* been uploaded, I'd need to do something with itbut do nothing if no file is found. My feeble

Re: Looping through file-fields

You'll want to change the following line : Cfif ('form.file#f#') NEQ To : cfif len(trim(evaluate('form.file#f#'))) The evaluate function lets you dynamically evaluate a statement before it's processed. ;) Nate Nielsen FusionScript DevTeam [EMAIL PROTECTED] Develop CF apps that talk to the

Re: Looping through file-fields

cfloop from=1 to=#listLen(form.fieldNames)# index=i cfif len(evaluate(form.file #i#)) cfoutput Received file number #i# /cfoutput cfelse nothing /cfif /cfloop Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

SQL Query Question

I'm having trouble with this query. There are two tables, issue and issueOption. There is a one-to-many relationship between issue (one) and issueOption (many). issID is the key that joins the two tables. I want to select all records from issue that are not in the issueOption. In other

RE: SQL Query Question

Something like this might work: SELECT DISTINCT IssID FROM Issue WHERE NOT EXISTS (SELECT * FROM issueOption WHERE issueOption.issID = Issue.issID) -Original Message- From: Nick Bourgeois [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 19, 2002 11:32 AM To: CF-Talk Subject: SQL

RE: Windows - pesky folders

Try rd /q /s parentdir where parentdir is the name of the directory above the files? Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Scott

Re: Looping through file-fields

Ahhhstupid me. Thanks Nate Will - Original Message - From: Nate Nielsen [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Sunday, May 19, 2002 5:09 PM Subject: Re: Looping through file-fields You'll want to change the following line : Cfif ('form.file#f#') NEQ To : cfif

RE: SQL Query Question

I'm having trouble with this query. There are two tables, issue and issueOption. There is a one-to-many relationship between issue (one) and issueOption (many). issID is the key that joins the two tables. I want to select all records from issue that are not in the issueOption. In other

Multiple Left Outer Joins

Hi all. Before I wreck my brain trying to figure this out, I'll ask here. :) Is there a way to do multiple Left Outer Joins off of a single table? I know how to join table 1 to table 2, then table 2 to table 3, etc. What I'd like to do is 3 separate Outer Joins to the same Left table in a

RE: Seeking ColdFusionMX Training in Boston, MA

I am seeking intermediate to advanced training on using ColdFusionMX along with MS SQL Server. It's unlikely that you'll see any training specifically geared to CF MX and SQL Server together. Fortunately, if you know about SQL Server already, everything you know about it more or less is

RE: Multiple Left Outer Joins

We just dealt with this, and here was hows ours ended up: cfquery name=mygetwheels datasource=#fourmy.dsn# Select mycarinfo.id, mycarinfo.carmake, mycarinfo.carmodel, mycarinfo.caryear, mycarinfo.custid, mycarinfo.vin, mycarinfo.mileage, mycarinfo.price, mycarinfo.descrip, mycarinfo.imagethumb,

RE: Problem with cfhttp

I thought maybe I was missing something. Glad to see someone could reproduce the problem. Can Christine or anyone else at MM that watches this list give us some ideas as to why this is happening? Apparently, this bug (the exact same situation, in fact, with the truncation in the exact

SQL: is there such a thing as NOT DISTINCT?

I want to output all records in a table where a certain field is duplicated at least once. My first instinct is to filter in the SQL - but how?! I'm using Access 2000, and the field in question is VARCHAR. DISTINCT doesn't *seem* to support being negated with NOT, and anyway, isn't it only meant

RE: is there such a thing as NOT DISTINCT?

There's a wizard for this in Access 2000. On the Queries pane, hit New (oddly not Create query by using wizard), the Find Duplicates Query Wizard. Regards, Matthew Walker /* Easier, smarter forms: http://www.matthewwalker.net.nz/inform2 */ -Original Message-

Re: SQL: is there such a thing as NOT DISTINCT?

Write your SQL code as if you wanted to get all the distinct values. To 'not' the code you should be able to flip the query conditions. Equal becomes not equal, And becomes Or, etc.. For example: Select distinct * from mytable where Mytable.field = #Variable# Is the same as:

RE: is there such a thing as NOT DISTINCT?

I want to output all records in a table where a certain field is duplicated at least once. My first instinct is to filter in the SQL - but how?! I'm using Access 2000, and the field in question is VARCHAR. DISTINCT doesn't *seem* to support being negated with NOT, and anyway, isn't it

Re: SQL: is there such a thing as NOT DISTINCT?

One way to isolate these not distinct rows would be something like this: SELECT myColumn, count(myColumn) FROM myTable WHERE count(myColumn) 1 This would give you only return rows where where there was more than one instance. HTH, Stephen I want to output all records in a table where a

Re: Looping through file-fields

Cfloop from=1 to=5 index=f Cfif ('form.file#f#') NEQ Received file number #f#br Cfelse Nothing for #f#br /CFIF /CFLOOP Use Form[File#f#] instead of ('Form.File#f#') __ Get the mailserver that powers this

Re: UDFs in a Custom Tag problem

You have to do it as an include, the function declaration actually happens on parsing of the template you see, so when your custom tag gets hit on the end tag that parser reads the custom tag template again, and sees a declaration for isOperator - no matter that it won't be used this time around.

Re: SQL: is there such a thing as NOT DISTINCT?

Thanks to all for input. Sidetracked onto another problem at the moment, but Stephen's idea about using 'WHERE count(myColumn) 1' sounds promising and looks elegant! And all the other replies have taught me something about SQL. Cheers! - Gyrus - [EMAIL PROTECTED]

RE: is there such a thing as NOT DISTINCT?

-Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 19, 2002 7:05 PM To: CF-Talk Subject: RE: is there such a thing as NOT DISTINCT? SELECTt1.field_to_match, t1.primary_key, t2.field_to_match,

RE: is there such a thing as NOT DISTINCT?

SELECT t1.field_to_match, t1.primary_key, t2.field_to_match, t2.primary_key FROMtable_with_dups t1 INNER JOIN table_with_dups t2 ON t1.primary_key = t2.primary_key Shouldn't this be: SELECTt1.field_to_match,

indexing a MS Word document

I'm building a on-line recruitment application that will allow people to upload their resumes as .doc attachments. We need to index the text in the document for fast searching, be able to do word counts (for example how many occurrences of java) and we need to be able to store the resume text

RE: indexing a MS Word document

Verity will index Word docs. You just place them all in a folder, and use cfindex type=path. But if you are converting to plain text and storing in db anyway, couldn't you just search that, cfindex type=custom. Word to HTML (maybe useful?)