Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-17 Thread John Stottlemire
ourse). I really can't figure this one out. >Will nay of these utilities help? > >http://livedocs.adobe.com/coldfusion/6.1/htmldocs/verityu2.htm > >On 7/13/07, John Stottlemire <[EMAIL PROTECTED]> wrote: >> ~

Re: Im Ashamed But Need Help

2007-07-12 Thread John Stottlemire
This might be crazy... but can't you do a and then take the query set and do a this way you have the actual name of the directory without trying to "look at it" and figure out what it is on your own. >Hello Guys, > > > >I've got a bit of an embracing one here, but I left one of my

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-12 Thread John Stottlemire
The result of this page is always a failure to index the first 51 records in the recordset. I've had my order by set to ASC then to DESC and then changed the field I was ordering by and always the first 51 records within the recordset are not being indexed by the cfindex. (Always where currentr

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-12 Thread John Stottlemire
I really do need to try and get this fixed... here is the code in the page: SELECT TABLE1.RECORD_ID,DESCRIPTION,SOURCE_DESC FROM TABLE1, TABLE2 WHERE TABLE1.RECORD_ID = TABLE2.RECORD_ID AND APPROVED = 'Y' AND QUANTITY - CQTY > 0 AND SOURCE_DESC <> 'NOT AVA

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-10 Thread John Stottlemire
uff >was added. ;) > >On 7/10/07, John Stottlemire <[EMAIL PROTECTED]> wrote: >> ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIA’s for your business. Upgrade now http://www.adobe.

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-10 Thread John Stottlemire
e what doccount you see there. > >On 7/10/07, John Stottlemire <[EMAIL PROTECTED]> wrote: >> ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.a

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-10 Thread John Stottlemire
I > assume you are checking in the admin, looking at Document Count, > right? > > On 7/9/07, John Stottlemire <[EMAIL PROTECTED]> wrote: > > the key field in the cfindex = the primary key of the database table > (I don't think its duplicate keys). > > > > I

Re: verity: CF MX 6.1 recordcount neq recordssearched

2007-07-09 Thread John Stottlemire
op the first 51 records and the collection always ends up with 51 records less than the database query. > Maybe its duplicate keys. Are you saying that if you EMPTY your > collection, do a query that returns N rows, and then cfindex that > query, your collection contains N-52 records?

verity: CF MX 6.1 recordcount neq recordssearched

2007-07-09 Thread John Stottlemire
can anyone shed some light on why a cfindex would exclude the first 51 records from a query recordset no matter what the order by statement says in the sql statement. my query.recordcount is always 51 records more than the query.recordssearched and its always the first 51 records from the query

Re: MS Access Primary Key

2007-04-06 Thread John Stottlemire
opinions expressed within this >communication are not necessarily those expressed by Reed Exhibitions." >Visit our website at http://www.reedexpo.com > >-Original Message- >From: John Stottlemire >To: CF-Talk >Sent: Thu Apr 05 06:55:52 2007 >Subject: Re: MS Acces

Re: MS Access Primary Key

2007-04-06 Thread John Stottlemire
6.aspx > >Greetings > >-----Original Message- >From: John Stottlemire [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 04, 2007 11:56 PM >To: CF-Talk >Subject: Re: MS Access Primary Key > >Come on, someone has to know how to do this > >> Anyone know of a way

Re: MS Access Primary Key

2007-04-04 Thread John Stottlemire
Come on, someone has to know how to do this > Anyone know of a way to find the Primary Key in a table using CFMX and > SQL? > > I know that queryname.columnlist returns the field names, but I'm > trying to determine the primary key of the database table as well. > > Thanks in advance. ~~~

MS Access Primary Key

2007-04-01 Thread John Stottlemire
Anyone know of a way to find the Primary Key in a table using CFMX and SQL? I know that queryname.columnlist returns the field names, but I'm trying to determine the primary key of the database table as well. Thanks in advance. ~~~

Re: Logging into ASP site via CFHttp (Correction!)

2007-02-15 Thread John Stottlemire
Thanks for the link, I was hoping however, to do this without putting another dll on my w2k3 server. >$45 bucks solution here (creates sessions for you): > >http://www.cftagstore.com/tags/cfxhttp5.cfm ~| Upgrade to Adobe ColdFus

RE: Logging into ASP site via CFHttp (Correction!)

2007-02-13 Thread John Stottlemire
curred While Processing Request Object of type class coldfusion.util.FastHashtable cannot be used as an array The error occurred in decode.cfm: line 25 23 : 24 : #ISARRAY(TEMPCOOKIE)# 25 : #ARRAYLEN(TEMPCOOKIE)# -john stottlemire -Original Message- From: Joel [mail

RE: Logging into ASP site via CFHttp (Correction!)

2007-02-13 Thread John Stottlemire
Obviously, for some reason the syntax of my code didn't remain correct when I pasted it. To clear up anything that might be an oversight... The line ending with "my_username does include the "> that is required. It was also formatted real "pretty" on my computer :) __

Logging into ASP site via CFHttp

2007-02-13 Thread John Stottlemire
Step one of a long drawn out problem I'm having. I am posting via a cfhttp to a login page which is using ASP as its back engine. the code I am using is as follows: http://www.dealideal.com/forum/login_user.asp"; USERAGENT = "#cgi.HTTP_USER_AGENT#" METHOD = "post" RESOLVEURL = "yes"