RE: Flash Remoting in multiple instances

[Adrian Lynch]

I'm not sure. It was in JRun admin that something was deleted.

Ade

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 22:23
To: CF-Talk
Subject: RE: Flash Remoting in multiple instances


Are you saying, delete the vDIR that points to the default instance and
create one that points to another instance.
If so, then that is basically what I have just said doesn't work.
Falsh remoting only works if the JrunScripts vDIR is using the default
instance. Using nay other instance doesn't work.


-Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 21:56
To: CF-Talk
Subject: RE: Flash Remoting in multiple instances

It was a long time ago but I remember someone mentioning something about
this.

I THINK the solution was to delete the default instance one and create them
as needed.

But I'd wait for someone else to confirm this just in case.

Ade

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 21:50
To: CF-Talk
Subject: Flash Remoting in multiple instances


I have just noticed the following problem when using Multiple instances
(CFMX7 multi-server).
When using Flash remoting, it only works if the JrunScript virtual directory
is pointing  at the default instance connector folder.
I.E.

C:\jrun4\lib\wsconfig\1

If you use the connector folder for any other instance, flash remoting does
not work.

Can anyone else verify this?

--
Snake






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225346
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Flash Remoting in multiple instances

[Adrian Lynch]

It was a long time ago but I remember someone mentioning something about
this.

I THINK the solution was to delete the default instance one and create them
as needed.

But I'd wait for someone else to confirm this just in case.

Ade

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 21:50
To: CF-Talk
Subject: Flash Remoting in multiple instances


I have just noticed the following problem when using Multiple instances
(CFMX7 multi-server).
When using Flash remoting, it only works if the JrunScript virtual directory
is pointing  at the default instance connector folder.
I.E.

C:\jrun4\lib\wsconfig\1

If you use the connector folder for any other instance, flash remoting does
not work.

Can anyone else verify this?

--
Snake


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225344
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL

[Adrian Lynch]

Oh and don't forget the WHERE clause! :OD

Ade

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 18:31
To: CF-Talk
Subject: RE: SQL


INSERT INTO YourTable (
YourColumns,
...,
...
) SELECT
YourColumns,
...,
...
FROM YourTable

-- For SQL Server
SELECT @@IDENTITY YourNewID
-- Or
SELECT SCOPE_IDENTITY() YourNewID

Ade

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225332
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL

[Adrian Lynch]

INSERT INTO YourTable (
YourColumns,
...,
...
) SELECT
YourColumns,
...,
...
FROM YourTable

-- For SQL Server
SELECT @@IDENTITY YourNewID
-- Or
SELECT SCOPE_IDENTITY() YourNewID

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 18:21
To: CF-Talk
Subject: SQL


Hi guys,

I have club events listed in a database.  To make shorter work for  
promoters when they'd like to duplicate events is there a way to copy  
a row in ms-sql via CF and find the ID of that row?

Thanks,

Saturday

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Monitor DSN

[Adrian Lynch]

Do a query, wrap in in cftry/cfcatch, in the catch, send an email. So
something...

Ade

-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 03:34
To: CF-Talk
Subject: Re: Monitor DSN


Mike,

Can you share your codes with me?

jl

On 11/26/05, Mike Chabot <[EMAIL PROTECTED]> wrote:
> I have a monitor page in each of my applications that is called from
> an external server every five minutes. The monitor page runs a few
> essential queries to test database connectivity. If a query fails, I
> get an E-mail sent from the external server. If the entire page fails,
> I try to call an HTML page in that directory to see if the server is
> up.
>
> You could also buy a product like Whats Up Gold
>  to monitor your
> database server.
>
> -Mike Chabot
>
> On 11/26/05, John Lucania <[EMAIL PROTECTED]> wrote:
> > I often experience that Data Source Names got lost the connectivity
> > due to various reasons such as power outage, reboot, network blip,
> > etc.   Is there a way to monitor the DSN connectivity loss through
> > Scheduled Tasks (sending CFMAIL) or something else?  It is CFMX.
> >
> > jl


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225323
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query result set; making it available to custom tags when query is run from CF template?

[Adrian Lynch]

Following on from that. Do a check in the custom tag to see if the query
data already exists, if it does, use it, if it doesn't, get it. Or, if
you're passing the query data into the tag then you will have done one query
anyway.

Ade

-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED]
Sent: 25 October 2005 03:39
To: CF-Talk
Subject: Re: Query result set; making it available to custom tags when
query is run from CF template?


Well, if the one query contains all of the data needed by all of the custom
tag calls in the same page request, you could just set the query into the
request scope and it would be available to all of the custom tag calls.
 To do that simply follow this example:
 
 Doing this, any cfm file in the same request can access this query object
 HTH


 On 10/24/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
>
> I'm trying to improve a page I've written. It's a calendar, and I'm
> using a custom tag to display the calendar itself. On one view of the
> calendar, there can be four calls to that calendar custom tag (one for
> the current month, 3 for the next 3 months). Rather than call the
> same stored procedure once per custom tag call, I'd rather call it
> once total from the CFM template, and then make that result set
> available to the custom tags.
>
> Is there a way to accomplish this, or do I just need to make multiple
> calls to get the recordset?
>
> Thanks,
>
> Pete


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225308
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF MX 7 processing .PHP extension - IIS 6

[Adrian Lynch]

I think the reason he wants to get CF to process a file with a .php
extension is that the Flash movie points to a file and he can't change the
Flash.

My advice would be to decompile the swf and change the file it's pointing to
:O)

Ade

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 23 November 2005 22:51
To: CF-Talk
Subject: RE: CF MX 7 processing .PHP extension - IIS 6


If it's just one file, I recommend rewriting it in CF... Otherwise your only
choice is to get another server and put PHP on it... (or shared space
somewhere)..

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 3:49 PM
To: CF-Talk
Subject: Re: CF MX 7 processing .PHP extension - IIS 6

If you mean can you write CFML code, save the file as .php, and have CF
execute it, then yes you can. If you mean can the CF server read and process
PHP code written in files with a .php extension, then the answer is of
course not.

On 11/23/05, Jim Curran <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Is there any way to get CF to process .php files?  I have a site we
> acquired
> that has a flash form submitting to a PHP file.  Also, there is no PHP on
> the server, so I can't use it.  Also, installing PGP is not an option.  Is
> there a way I can get CF to process .php files for this one site?
>
> TIA,
>
> - j
>
>
>





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225151
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every 8 hours (Out of the Office)

[Adrian Lynch]

Well if you have "issues"...

"Please refer any IT issues to Chris Terrebonne or Tommy Nguyen."

 give them a call! :OD

-Original Message-
From: Dana [mailto:[EMAIL PROTECTED]
Sent: 19 November 2005 22:19
To: CF-Talk
Subject: Re: CF-Talk: Digest every 8 hours (Out of the Office)


just please nobody else turn an autoresponder on 

On 11/19/05, Dana <[EMAIL PROTECTED]> wrote:
> I already sent MikeD an email but it is the Sabbath remember. Maybe
> not for much longer, does it end at sundown?
>
> On 11/19/05, Jeff Anderson <[EMAIL PROTECTED]> wrote:
> > Please tell me we aren't going to get this every 8 hrs for the next
week...
> >
> >
> >
> > -Original Message-
> > From: Mike McConnell [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, November 19, 2005 16:01
> > To: CF-Talk
> > Subject: Re: CF-Talk: Digest every 8 hours (Out of the Office)
> >
> > I will be out of the office from Monday November 21 through Friday,
November 25.  Please refer any IT issues to Chris Terrebonne or
> > Tommy Nguyen.  I'll be back in the office on Monday, November 28.
> >
> > M. McConnell


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224735
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query Question

[Adrian Lynch]

I don't know about efficient, but try

SELECT TOP 1 eventID

That's if it's SQL Server, the over DBs will have something similar

Ade

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 16 November 2005 21:56
To: CF-Talk
Subject: Query Question


I have 2 tables, for the sake of simplification lets say they look like
this:



EVENT

eventID

eventName





EVENTDATES

eventID

eventDate



Each event would be in the event table once, and possibly multiple times in
the eventDates table.  I want to have a query return one record for each
event with the next eventDate from the eventDates table.



So basically something like:



Select eventID, eventName, eventDate from event inner join eventDates on
event.eventID=eventDates.eventID where eventDate>#Now()#



But I only want 1 record returned for each event. I know I can probably
order by eventID and then do a cfoutput groupby, but I don't really want all
those records coming back (I mean it will basically be number of records in
the event table * number of records in the eventDates table).



Is there a more efficient way of doing this?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224398
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Web Service Error

[Adrian Lynch]

For the archives, the firewall was stripping headers from the SOAP request,
stopping this fixed it.

Ade

-Original Message-
From: adrian lynch [mailto:[EMAIL PROTECTED]
Sent: 16 November 2005 12:22
To: CF-Talk
Subject: Web Service Error


Can anyone tell me what would cause an error with this code?


timeService = CreateObject("webservice",
"http://www.nanonull.com/TimeService/TimeService.asmx?WSDL";);
cityTime = timeService.getCityTime("London");





The error I get is:

"Could not perform web service invocation "getCityTime"."

"AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Client
 faultSubcode:
 faultString: Unable to handle request without a valid action parameter.
Please supply a valid soap action."


I've found reference on the web that the SOAP request is incorrecctly
structured. Am I missing something? I don't want to build the SOAP package
myself.

Thanks.

Adrian



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224370
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Web Service Error

[adrian lynch]

Can anyone tell me what would cause an error with this code?


timeService = CreateObject("webservice", 
"http://www.nanonull.com/TimeService/TimeService.asmx?WSDL";);
cityTime = timeService.getCityTime("London");





The error I get is:

"Could not perform web service invocation "getCityTime"."

"AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Client
 faultSubcode: 
 faultString: Unable to handle request without a valid action parameter. Please 
supply a valid soap action."


I've found reference on the web that the SOAP request is incorrecctly 
structured. Am I missing something? I don't want to build the SOAP package 
myself.

Thanks.

Adrian

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224329
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Error found by CF45 but Not CFMX7?

[Adrian Lynch]

Yup, it was something that cropped up back when CF6 came out. Putting code
from 6 to 5 highlighted this.

Ade

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: 13 November 2005 19:12
To: CF-Talk
Subject: Error found by CF45 but Not CFMX7?


Had an interesting issue come up on Friday - I had sent some code to a
client for a small job I was working on and got a message back that
there was a syntax error.  I replied that it had not happened on my
setup and showed them via a series of screen shots; they replied with
a screen shot of the error.

Nested CFOutput tag found without a query attribute on the outer
CFOutput.  Interestingly enough, there was a syntax error that did not
show up in CFMX7...

Inside a custom tag there was a nested cfoutput.  I didn't write the
tag so I'm not 100% why this occured but it most defnintely was there


    some text
   
  #ThisItem#
   


it blew up on CF45 as well it should... but it did not on 7.  Anyone
see this behavior before?

Hatton


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224038
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SP & UDF parameter meta data

[Adrian Lynch]

Ignore my question in that reply, but don't ignore the first bit, the IS
view might be what you need.

Ade

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 12 November 2005 10:21
To: CF-Talk
Subject: RE: SP & UDF parameter meta data


I'm just looking at this myself, take a look at
INFORMATION_SCHEMA.PARAMETERS in BOL, or run it in QA.

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

I've run into a problem trying to get the datatypes of SP params

Running this...

SELECT
syscolumns.colid,
syscolumns.name,
systypes.name
FROM syscolumns
INNER JOIN systypes ON syscolumns.xtype = systypes.xtype
WHERE syscolumns.id = OBJECT_ID('TestSP')
ORDER BY syscolumns.colid

. returns the param name twice, systypes.name should be the datatype. Can
anyone shed some light on this?

Ade



-Original Message-
From: Rich Kroll [mailto:[EMAIL PROTECTED]
Sent: 04 November 2005 18:18
To: CF-Talk
Subject: OT: SP & UDF parameter meta data


Hello All,

I was wondering if anyone knows how I can access parameters expected by a
UDF in MSSQL? I know that I can use the following to retrieve the expected
parameters for a SP, but how can I do the same for a UDF?

select name
FROM syscolumns
WHERE id = OBJECT_ID('sp_myProcedure')


Anyone have any ideas?

Rich Kroll
Application Developer


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SP & UDF parameter meta data

[Adrian Lynch]

I'm just looking at this myself, take a look at
INFORMATION_SCHEMA.PARAMETERS in BOL, or run it in QA.

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

I've run into a problem trying to get the datatypes of SP params

Running this...

SELECT
syscolumns.colid,
syscolumns.name,
systypes.name
FROM syscolumns
INNER JOIN systypes ON syscolumns.xtype = systypes.xtype
WHERE syscolumns.id = OBJECT_ID('TestSP')
ORDER BY syscolumns.colid

 returns the param name twice, systypes.name should be the datatype. Can
anyone shed some light on this?

Ade



-Original Message-
From: Rich Kroll [mailto:[EMAIL PROTECTED]
Sent: 04 November 2005 18:18
To: CF-Talk
Subject: OT: SP & UDF parameter meta data


Hello All,

I was wondering if anyone knows how I can access parameters expected by a
UDF in MSSQL? I know that I can use the following to retrieve the expected
parameters for a SP, but how can I do the same for a UDF?

select name
FROM syscolumns
WHERE id = OBJECT_ID('sp_myProcedure')


Anyone have any ideas?

Rich Kroll
Application Developer


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Best Practice - Omit "The" and other common words Text Input for Search and another question

[Adrian Lynch]

If "The" is the only word causing you problems, look for it at the beginning
of the search(it would have to be the beginning as you don't want to take it
from the middle of a string) term and remove it before it gets passed to
SQL.

Ade

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: 11 November 2005 16:55
To: CF-Talk
Subject: Best Practice - Omit "The" and other common words Text Input
for Search and another question


Let's say I'm searching book titles in a database.

I want to find "The Red Tent".
However, in the database, it's listed as "Red Tent, The".

So:
search books
where Title like '%#formtitle#%'

So, the following will find it:
"Red Tent"
"Red"
"Tent"

The exact title "The Red Tent" won't.

1. What's the best way to exclude common words from what's entered in
the form field.

2. How would I do something a little more comparitive?
Assume the book title is actually "The Big Fat Tent that is Red"
and if I enter "Red Tent" into the search field, I'd like
it to come up.

The only thing I can think of here would be to take each word entered
into the form field - "The Red Tent" - put them in a list - "The, Red,
Tent" - and then do a search for the terms in the list. Any other ideas?

A verity search will NOT work in this case, as there's a ton of other
tables with joins and all sorts of other rotten stuff involved...

--
---
Les Mizzell


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224010
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Books Online Download

[Adrian Lynch]

Ok, I found it:
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-
8a4b-bd77a7da194b&displaylang=en

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 10 November 2005 22:06
To: CF-Talk
Subject: Books Online Download


Can anyone point me to a download page for SQL Server 2000 BOL. All the
pages I come across are for 2005. If anyone has a copy they can make
available, that would be grand :O)

Ade


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223878
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Books Online Download

[Adrian Lynch]

Can anyone point me to a download page for SQL Server 2000 BOL. All the
pages I come across are for 2005. If anyone has a copy they can make
available, that would be grand :O)

Ade


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries Subquery

[Adrian Lynch]

Or, just had a thought, make the the sub query dynamic


SELECT Zip
FROM UPS



SELECT*
FROM  OOrder
Where zip IN (#ValueList(OOrder.Zip)#)


You might want to allow for no records though.

Ade

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:28
To: CF-Talk
Subject: RE: Query of Queries Subquery


Sad but true... You'll have to run a third QoQ to filter it.
 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 5:23 PM
To: CF-Talk
Subject: RE: Query of Queries Subquery

You can't do sub queries in Q of Q.

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery


I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.


SELECTZip
FROM UPS




SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223747
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries Subquery

[Adrian Lynch]

You can't do sub queries in Q of Q.

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery


I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.


SELECTZip
FROM UPS




SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223745
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfprocresult and recordcount

[Adrian Lynch]

Run the SP in Query Analyser to see the resultsets you're getting back.
It'll be tow or three. Chances are, the third SELECT isn't being run and QA
should show this.

Does the SP return the first two resultsets?

If you leave your SP as it is you could do a check for getNavSubElements
with IsDefined().

Adrian

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 05:04
To: CF-Talk
Subject: Re: cfprocresult and recordcount


OK, the issue might be with my SP; I tried to dump the query structure
and got an error.  I'm pushing my personal stored procedure envelope
here so might have made a mistake.

Anyway, here's my cfstoredproc call:








And here is the stored procedure:

CREATE PROCEDURE spGetNav
@cid integer
AS
SELECT  C.ID, C.parentid, C.displayorder, C.title, C.redirect
FROMtblContent C
WHERE   C.active = 1

SELECT  C.ID, C.title, C.redirect
FROMtblContent C
WHERE   C.parentid IS NULL
ORDER BYC.displayorder

DECLARE @parentidcount integer
SET @parentidcount = (SELECTcount(C.parentid) AS 
parentidcount
  FROM  tblContent C
  WHERE C.ID = @cid)

IF (@parentidcount > 0)
BEGIN
SELECT  ID, title, redirect
FROMgetAllNavElements
WHERE   parentid = (SELECT  
C.parentid
FROM
tblContent C
WHERE   
C.ID = @cid)
ORDER BYdisplayorder

END

GO


As I mentioned, I'm just beginning to go beyond the basics as far as
stored procedures go, so my guess is that I've done something wrong.
The first two SELECT statements are returning result sets.  The third
portion of the SP (or so I thought) begins with the DECLARE statement,
and my guess is that's what is causing the problem.

Can someone point me in the right direction on this one?

Thanks,

Pete


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Referencing filenames in cfindex

[Adrian Lynch]

The file name should be in the query returned from cfindex. It might be
fully qualified so treat it as a list and extract it.

Could be wrong though! :OI

Ade

-Original Message-
From: Lilly Spa [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 01:42
To: CF-Talk
Subject: Referencing filenames in cfindex


I'm trying to run a cfindex on the files in a
directory. Here's my syntax:






~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 500 Null at bottom of debug!

[Adrian Lynch]

Ok, in the comments section of livedocs here:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=0217.htm

--
yoinky said on Sep 28, 2005 at 2:03 AM :
HUGE Pain-In-The-Ass Solution:

DO NOT USE HYPHEN CHARACTERS IN THE NAME="" ATTRIBUTE!

Just incase you are pulling your hair out wondering why your client
management isn't working (like I've been doing for the past week) and have
gone through everything and can't get it working on a database or in the
registry, head this very simple "rule" left out of the documentation.

if you do use a hyphen, at the end of the request when the client scope is
supposed to be automatically persisted by the runtime, it will display a
"500 NULL" error in html at the bottom of the page, it won't even throw a
real exception or log the error, so you have no idea it happened.
yoinky said on Sep 30, 2005 at 1:04 AM :
A follow up to my last post, if you enable client management, and then
somehow delete the #client.hitCount# variable (for example by doing
#structDelete( client )#) then the client data will fail to persist whenever
changes are made!

This error wont through an exception, it wont log the error, it will simply
append a snippet of html to the output with "500 null"

Any other built in client variable can be removed except for HitCount, so be
careful.
---

And I did use StructDelete(CLIENT) a short while before!

Adrian

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 01:25
To: CF-Talk
Subject: 500 Null at bottom of debug!


I've just installed CF7 dev on a new machine. At the bottom of the page,
beneath the debug there's a 500 Null line. The page runs as normal. I've
checked to source to see if the real error was mentioned but it's only 500
Null at the bottom of the page.

Here's a screen: http://www.adrianlynch.co.uk/temp/null.jpg

Any ideas?

Adrian


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

500 Null at bottom of debug!

[Adrian Lynch]

I've just installed CF7 dev on a new machine. At the bottom of the page,
beneath the debug there's a 500 Null line. The page runs as normal. I've
checked to source to see if the real error was mentioned but it's only 500
Null at the bottom of the page.

Here's a screen: http://www.adrianlynch.co.uk/temp/null.jpg

Any ideas?

Adrian


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221951
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT - MSDE - EM/QA Tools

[Adrian Lynch]

Ah nice one! Now I don't have to wait till Monday :OD

Out of interest, how are people getting on with MSDE? I've more or less
ignored it up until today.

Adrian

-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 00:53
To: CF-Talk
Subject: RE: OT - MSDE - EM/QA Tools


If you download the eval for SQL Server 2000 from Microsoft it includes the
client tools.

-Justin


> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 22, 2005 7:49 PM
> To: CF-Talk
> Subject: OT - MSDE - EM/QA Tools
>
> I've just installed MSDE on a local dev machine, I don't have
> the disk with
> EM and QA on and was about to hunt down some alternatives on
> the web. Doesn
> anyone have any recommendations? Web based would be ok too.
>
> Thanks.
>
> Adrian
>
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221950
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT - MSDE - EM/QA Tools

[Adrian Lynch]

I've just installed MSDE on a local dev machine, I don't have the disk with
EM and QA on and was about to hunt down some alternatives on the web. Doesn
anyone have any recommendations? Web based would be ok too.

Thanks.

Adrian


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFDocument font probs

[Adrian Lynch]

I had the same error on some shared hosting accounts at CrystalTech. They
fixed them almost straight away so I'd guess it's  trivial matter to fix.

Not a solution I know, but at least you know others are having it and it's
fixable.

Ade

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 17 October 2005 11:51
To: CF-Talk
Subject: CFDocument font probs


I get the following problem with cfdocument when I use fontembed

access denied (java.io.FilePermission c:\windows\fonts\times.ttf read)

Please see the following as an example

http://www.hoa.cfmxhosting.co.uk/pdftest.cfm


I have even given EVERYONE access on the fonts folder and it will wont work.

--
Russ


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221372
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Getting a variable

[Adrian Lynch]

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 04 October 2005 20:32
To: CF-Talk
Subject: Getting a variable


Hi guys,

I've got a simple question just can't find my answer.

I want to dynamically define a variable.



So in the above case i would want to define, say 

I'm sure this can be done easily i just can't remember.

Thanks,

Saturday

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220061
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE:

[Adrian Lynch]

Wack some #'s in there.

list="#incorrentList#"

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 22:15
To: CF-Talk
Subject: 


Hi guys,

I've appended a list and on this occasion my list outputs 1,3,5 (for
instance).

 
 #GetQuizQuestions.questionText[thisItem]# this
wrong
 

The problem i'm coming across an error which says:

The value "incorrectList" cannot be converted to a number

Does anyone know a way around this?

Thanks,

Saturday



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Why doesn't this query return more than 1 record?

[Adrian Lynch]

If Client_ID is your PK, and you're restricting it in the AND clause, that's
enough to limit it to one.

Ade

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 18:44
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?


Ok...

Clients Table
--
Client_ID
Client_Family_ID (FK for Family_Groups Table)
etc...

Family_Groups Table
--
Group_ID


There are 4 records in the Clients table...all have
the same Client_Family_ID, which is "1"...

There is 1 record in the Family_Groups table,
which has the Family_Group_ID of "1"...

Link is clicked, sending "Client_ID = 1"...(that client
has a Client_Family_ID FK that = "1"

So, give me all the records where the Family_Group_ID = Client_Family_ID
and the Client_ID = 1 ('#URL.Client_ID#')...

I think that "Client_ID = '#URL.Client_ID#' is going to
limit the records to 1...

But how do I get all Clients that have Family_Group_ID's
that match the Family_Group_ID of the Client specified by the
'#URL.Client_ID#' ???

I know I've been away from coding for a couple of months...but sheesh!

Rick







> -Original Message-
> From: Ken Ferguson [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 03, 2005 1:02 PM
> To: CF-Talk
> Subject: Re: Why doesn't this query return more than 1 record?
>
>
> How many records are in each table and what do they look like (just the
> columns in question). The only way I'd see you getting more than one
> record back is if there are several different records in the clients
> table with the same client_id. I'm guessing the tables look
> similar to this:
>
> CLIENTS:
> client_id
> 1
> 2
> 3
>
> client_family_id
> 123
> 456
> 789
>
> FAMILY_GROUPS
> group_id
> 123
> 456
> 789
> group_name
> smith
> james
> johnson
>
> So, when your url.client_id variable equals 1, you're going to get
>
> client_id = 1, fg.group_id = 123, fg.group_name = smith
>
> Am I missing something here
>
>
> Select FG.Group_ID, FG.Group_Name,
>   C.Client_ID,
>   C.Client_First_Name, C.Client_Middle_Name,
> 
> 
> >>>C.Client_Last_Name
> >>>
> >>>
>    from Family_Groups FG, Clients C
>  where FG.Group_ID = C.Client_Family_ID
> and C.Client_ID = '#URL.Client_ID#'
> 
> Rick
> 
> 
> 
> 
> 
> 
> >>>
> >>>
> >>
> >>
> >
> >
>
>



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219944
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Why doesn't this query return more than 1 record?

[Adrian Lynch]

Thought you might be doing something like:


#qYourQuery.SomeRow#


and only seeing one row, namely the first one.

Have you solved it?

Ade

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 18:10
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?


Oh, I'm so mad!  ;o)

I'm returning the results to the website and I've also run
the query on Navicat...

Rick


> -Original Message-----
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 03, 2005 12:45 PM
> To: CF-Talk
> Subject: RE: Why doesn't this query return more than 1 record?
>
>
> Now don't get mad when I suggest this, but how do you know it's only
> returning 1 row?
>
> Ade
>
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: 03 October 2005 17:34
> To: CF-Talk
> Subject: RE: Why doesn't this query return more than 1 record?
>
>
> It should return 4 records, which are the only ones in the
> database / table that match...it's a database that I'm developing
> as I develop the site...
>
> I've been over the data at the db, and over the code multiple
> times and must just be missing something...
>
> It's returning only the first record each time...and that's the record
> that matches the URL.Client_ID...but this code should return more
> than one record, right?
>
> Rick
>
>
> > -Original Message-
> > From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> > Sent: Monday, October 03, 2005 11:58 AM
> > To: CF-Talk
> > Subject: RE: Why doesn't this query return more than 1 record?
> >
> >
> > Well how many rows do you expect back?
> >
> > It has to be down to your WHERE clause. Have a look in the
> tables and see
> > whether more rows fit the criteria you're using.
> >
> > Ade
> >
> > -Original Message-
> > From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> > Sent: 03 October 2005 16:47
> > To: CF-Talk
> > Subject: Why doesn't this query return more than 1 record?
> >
> >
> > I'm not dumb, I'm not dumb, I'm not dumb.
> >
> > If I repeat it often enough, it has to be true, right?
> >
> > Anyway...why won't this query return more than 1 record?
> >
> >  Select FG.Group_ID, FG.Group_Name,
> >C.Client_ID,
> >C.Client_First_Name, C.Client_Middle_Name,
> > C.Client_Last_Name
> > from Family_Groups FG, Clients C
> >   where FG.Group_ID = C.Client_Family_ID
> >  and C.Client_ID = '#URL.Client_ID#'
> >
> > Rick
> >
> >
> >
>
>
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219933
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: missing argument in a function

[Adrian Lynch]

Could you post the whole funtion and the calling code? Might be something
else.

Ade

-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:40
To: CF-Talk
Subject: Re: missing argument in a function


yes. an output before the query and after it returns a valid value.
this is driving me nuts

On 10/3/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Strange! Have you outputted ticket_id before and after to check it's what
> you expect it to be?
>
> Ade
>
> -Original Message-
> From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
> Sent: 03 October 2005 17:27
> To: CF-Talk
> Subject: Re: missing argument in a function
>
>
> correct.. the value that is passed into the where clause.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Online quiz

[Adrian Lynch]

I'd be suprised if it didn't throw a wobbly if you use numbers for your form
names. Best not to.

To answer the dynamic form names bit. Use array notation.


#FORM["myForm_" & i]#


Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:44
To: CF-Talk
Subject: Online quiz


Hi guys,

I have 5 questions in my MS-SQL database and when i want to display
them in an online quiz I loop them through like so:


  
   
  


When these get submitted i look through my DB again to pull the
answers.  And do something like:

 
 
 

The problem i'm having is somehow looping through the
#form.questionID#'s as I don't want to hard-code each one like below
as in some quizzes they'll be less than 5 questions and some more:







Also, will it be a problem that my form names which are ID's will be
numbers, ie 1 or 2 or 3 etc?

Any help on this would be great,

Thanks,

Saturday


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219922
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Why doesn't this query return more than 1 record?

[Adrian Lynch]

Now don't get mad when I suggest this, but how do you know it's only
returning 1 row?

Ade

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:34
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?


It should return 4 records, which are the only ones in the
database / table that match...it's a database that I'm developing
as I develop the site...

I've been over the data at the db, and over the code multiple
times and must just be missing something...

It's returning only the first record each time...and that's the record
that matches the URL.Client_ID...but this code should return more
than one record, right?

Rick


> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 03, 2005 11:58 AM
> To: CF-Talk
> Subject: RE: Why doesn't this query return more than 1 record?
>
>
> Well how many rows do you expect back?
>
> It has to be down to your WHERE clause. Have a look in the tables and see
> whether more rows fit the criteria you're using.
>
> Ade
>
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: 03 October 2005 16:47
> To: CF-Talk
> Subject: Why doesn't this query return more than 1 record?
>
>
> I'm not dumb, I'm not dumb, I'm not dumb.
>
> If I repeat it often enough, it has to be true, right?
>
> Anyway...why won't this query return more than 1 record?
>
>  Select FG.Group_ID, FG.Group_Name,
>C.Client_ID,
>C.Client_First_Name, C.Client_Middle_Name,
> C.Client_Last_Name
> from Family_Groups FG, Clients C
>   where FG.Group_ID = C.Client_Family_ID
>  and C.Client_ID = '#URL.Client_ID#'
>
> Rick
>
>
>



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219919
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: missing argument in a function

[Adrian Lynch]

Strange! Have you outputted ticket_id before and after to check it's what
you expect it to be?

Ade

-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:27
To: CF-Talk
Subject: Re: missing argument in a function


correct.. the value that is passed into the where clause.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219914
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: missing argument in a function

[Adrian Lynch]

Just to be clear, when you say 'value', you do mean in the cfqueryparam? Not
the result from the query?

Ade

-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:07
To: CF-Talk
Subject: Re: missing argument in a function


yes. if the joins are in the query the value is empty. if i remove the
joins the value is valid.

On 10/3/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Are you saying that:
>
> 
>
> is either passing in a blank value or the right value depending on the SQL
> statement above it?
>
> Ade
>
> -Original Message-
> From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
> Sent: 03 October 2005 16:54
> To: CF-Talk
> Subject: missing argument in a function
>
>
> i have a function that takes a ticket_id as an argument. the function
> runs a query and returns it. i have found that
>
> if the query runs like this:
>
> INNER JOIN lkp_Ticket_Types ON tbl_Tickets.Type_ID =
> lkp_Ticket_Types.Type_ID
> INNER JOIN lkp_Ticket_Status ON
tbl_Tickets.Status_ID =
> lkp_Ticket_Status.Status_ID
> INNER JOIN lkp_Ticket_Severity ON
tbl_Tickets.Severity_ID =
> lkp_Ticket_Severity.Severity_ID
> INNER JOIN tbl_Projects ON tbl_Tickets.Project_ID
=
> tbl_Projects.Project_ID
> LEFT OUTER JOIN lkp_Releases ON
tbl_Tickets.Release_ID =
> lkp_Releases.Release_ID
> WHERE   tbl_Tickets.Ticket_ID =  cfsqltype="cf_sql_integer" value="#Ticket_ID#" />
>
> #ticket_id# is blank. BUT
>
> if i removed all the joined tables and just do a query on the /main/
> table the where clause is valid (#ticket_id#) holds the proper value.
>
> any ideas what is/could be causing this? anyone seen anything like this
> before?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219908
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: missing argument in a function

[Adrian Lynch]

Are you saying that:



is either passing in a blank value or the right value depending on the SQL
statement above it?

Ade

-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:54
To: CF-Talk
Subject: missing argument in a function


i have a function that takes a ticket_id as an argument. the function
runs a query and returns it. i have found that

if the query runs like this:

INNER JOIN lkp_Ticket_Types ON tbl_Tickets.Type_ID =
lkp_Ticket_Types.Type_ID
INNER JOIN lkp_Ticket_Status ON tbl_Tickets.Status_ID =
lkp_Ticket_Status.Status_ID
INNER JOIN lkp_Ticket_Severity ON 
tbl_Tickets.Severity_ID =
lkp_Ticket_Severity.Severity_ID
INNER JOIN tbl_Projects ON tbl_Tickets.Project_ID =
tbl_Projects.Project_ID
LEFT OUTER JOIN lkp_Releases ON tbl_Tickets.Release_ID =
lkp_Releases.Release_ID
WHERE   tbl_Tickets.Ticket_ID = 

#ticket_id# is blank. BUT

if i removed all the joined tables and just do a query on the /main/
table the where clause is valid (#ticket_id#) holds the proper value.

any ideas what is/could be causing this? anyone seen anything like this
before?



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219902
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Why doesn't this query return more than 1 record?

[Adrian Lynch]

Well how many rows do you expect back?

It has to be down to your WHERE clause. Have a look in the tables and see
whether more rows fit the criteria you're using.

Ade

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:47
To: CF-Talk
Subject: Why doesn't this query return more than 1 record?


I'm not dumb, I'm not dumb, I'm not dumb.

If I repeat it often enough, it has to be true, right?

Anyway...why won't this query return more than 1 record?

 Select FG.Group_ID, FG.Group_Name,
   C.Client_ID,
   C.Client_First_Name, C.Client_Middle_Name, C.Client_Last_Name
from Family_Groups FG, Clients C
  where FG.Group_ID = C.Client_Family_ID
 and C.Client_ID = '#URL.Client_ID#'

Rick


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219899
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: a little loop help plz

[Adrian Lynch]

If I understand correctly, you're looking to loop over two lists at the same
time.

If the lists are productIDs and quantities then try the following:





Product ID: #ListGetAt(productIDs, i)#
Quantity: #ListGetAt(quantities, i)#






Swap in your SQL code and away you go.

Ade

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: 01 October 2005 22:43
To: CF-Talk
Subject: a little loop help plz


I've got a form that passes two variable lists:
1) Product id (could be up to 3 different product id's)
2) Quantity of product corresponding to the product name:

I'm trying to insert the product ids and the product quantities into the
same table.  I can break down and insert one variable list (ex. product
id) into a linking table by using something like:




INSERT INTO products (product_id)
VALUES #i#



But If I want to "breakdown" the quantity list for that product_id and
insert it into the same linking table I get stuck

Can someone lend a hand here with a pointer
Thanks
Tim


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219834
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query with multiple criteria

[Adrian Lynch]

Try WHERE 1 = 1

Ade

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 15:42
To: CF-Talk
Subject: Query with multiple criteria


Here's a problem that I run into a lot and have never come up with a 
good answer for...

When building a search form that allows to search multiple criteria in a 
table(s) - lets say "lname", "category", and "color" for this example - 
the user can fill in any one of these, or all of them. So, when building 
the query, I always have trouble figuring out what the first item in the 
WHERE statement is, because you don't know which field above might or 
might not be filled in.

So, if they fill in just "category" and "color" - see the problem?
What's "best practice" for this?




Select * From Table
   Where ???


and lname like '%#form.lname#%'


and lname like '%#form.category#%'


and lname like '%#form.color#%'





The form I'm working on have close to 30 possible fields, and spans 
several tables...

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219626
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: problem using a text list variable in a query statement

[Adrian Lynch]

A nice way to debug dynamically built queries is like this:





Delete from optomSitePhotos
WHERE photoLocation IN ('#qualDelPhotoList#')





When you run that, you'll see the query as it is passed to the DB. (Or look
in the debug if it's there).

Copy the generated query into Query Analyser and debug in there.

Could you show us the generated SQL string?

Ade

-Original Message-
From: Joy Holman [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:55
To: CF-Talk
Subject: problem using a text list variable in a query statement


I create a list from form variables that I want to use in a query.

This is where it fails to delete the records (though the query produces no
error:



Delete from optomSitePhotos
WHERE photoLocation IN ('#qualDelPhotoList#')


The list is: photo1.jpg,photo2.gif or 'photo1.jpg,'photo2.jpg' (depending on
whether I use List Quality with the list). It doesn't seem to matter.

The single quotes around #qualDelPhotoList# in the query is required or the
query fails.

Any ideas how to make this work?
Thanks.

Here is a fuller picture of the code:

..




These photos currently display with your facility's 
information. Click
on the appropriate button(s) if you wish to remove either or both photos.

This photo currently display with your facility's 
information. Click
on the appropriate button if you wish to remove the photo.






 


...


..















Delete from optomSitePhotos
WHERE photoLocation IN ('#qualDelPhotoList#')


...


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219597
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: query question

[Adrian Lynch]

Yup. Look at left and right outer joins.

http://www.w3schools.com/sql/sql_join.asp

What DB are you using?

Ade

-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:45
To: CF-Talk
Subject: query question


Morning,

When I use joins with a select statement, and one of the columns in the
query is blank, that record is not part of the record set.  I would like to
include the records with missing columns and have those columns just be
blank.  Is that a possibility?

Thanks,

Mark

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219594
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Now more query problems... boo hoo

[Adrian Lynch]

Now where did I put my BOL?! :OS

-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:38
To: CF-Talk
Subject: RE: Now more query problems... boo hoo


You can use it in the order by clause, he just needs to group all the
columns in his query with GROUP BY.


Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development



> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 29 September 2005 10:30 PM
> To: CF-Talk
> Subject: RE: Now more query problems... boo hoo
>
>
> You can't use COUNT in the ORDER BY clause. (Please someone
> back me up here else I'm off to spend some time with Book Online!).
>
> Ade
>
> -Original Message-
> From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
> Sent: 29 September 2005 13:20
> To: CF-Talk
> Subject: Now more query problems... boo hoo
>
>
> Jumping from one query problem to another... just when it was
> safe to to run a query another problem leapt out of the dungeons.
>
> I would like to only pull the top 8 authors who have the most
> articles (articleID)
>
> I have specified only to get the 8 maxrows but the problem
> i'm having is when i try to add to the ORDER BY COUNT(articleID) DESC
>
> My error is:
>
> [Macromedia][SQLServer JDBC Driver][SQLServer]Column
> 'tbl_020authorDetails.authorID' is invalid in the select list
> because it is not contained in an aggregate function and
> there is no GROUP BY clause.
>
> It can be seen at: http://www.020.com/testsql.cfm
>
>
> 
>  SELECT
>  tbl_020authorDetails.authorID,
>  tbl_020authorDetails.authorFirstName,
>  tbl_020authorDetails.authorSurname,
>  tbl_020authorDetails.authorPhotograph,
>  tbl_020authorDetails.authorAboutMe,
>  tbl_020articleDetails.articleID,
>  tbl_020articleDetails.articleTitle
>  FROM tbl_020articleDetails
>  INNER JOIN tbl_020authorDetails ON
> tbl_020articleDetails.authorID = tbl_020authorDetails.authorID
>  WHERE tbl_020authorDetails.authorPhotograph <> '' AND
> tbl_020articleDetails.articleSubTypeID <> 55
>  ORDER BY tbl_020authorDetails.authorID, COUNT(articleID)
> DESC 
>
> 
> #authorFirstName#
>
> my articles:
> #articleTitle#
> 
>
> Any help would be great.
>
> Thanks,
>
> Stuart
>
>
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219590
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: clear session variables for testing

[Adrian Lynch]

StructClear(SESSION)

Ade

-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:23
To: CF-Talk
Subject: clear session variables for testing


Good Morning,

Is there an easy way to clear all session variables?  It would help me test
for behaviors after session variables have timed out.

Thanks,

Mark



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219585
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Now more query problems... boo hoo

[Adrian Lynch]

You can't use COUNT in the ORDER BY clause. (Please someone back me up here
else I'm off to spend some time with Book Online!).

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:20
To: CF-Talk
Subject: Now more query problems... boo hoo


Jumping from one query problem to another... just when it was safe to
to run a query another problem leapt out of the dungeons.

I would like to only pull the top 8 authors who have the most
articles (articleID)

I have specified only to get the 8 maxrows but the problem i'm having
is when i try to add to the ORDER BY COUNT(articleID) DESC

My error is:

[Macromedia][SQLServer JDBC Driver][SQLServer]Column
'tbl_020authorDetails.authorID' is invalid in the select list because
it is not contained in an aggregate function and there is no GROUP BY
clause.

It can be seen at: http://www.020.com/testsql.cfm



 SELECT
 tbl_020authorDetails.authorID,
 tbl_020authorDetails.authorFirstName,
 tbl_020authorDetails.authorSurname,
 tbl_020authorDetails.authorPhotograph,
 tbl_020authorDetails.authorAboutMe,
 tbl_020articleDetails.articleID,
 tbl_020articleDetails.articleTitle
 FROM tbl_020articleDetails
 INNER JOIN tbl_020authorDetails ON
tbl_020articleDetails.authorID = tbl_020authorDetails.authorID
 WHERE tbl_020authorDetails.authorPhotograph <> '' AND
tbl_020articleDetails.articleSubTypeID <> 55
 ORDER BY tbl_020authorDetails.authorID, COUNT(articleID) DESC



#authorFirstName#

my articles:
#articleTitle#


Any help would be great.

Thanks,

Stuart



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219584
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: INNER JOIN

[Adrian Lynch]

A quick suggestion, write a test page with the minimum of code in. It'll
make it easier for you to debug and easier for us to help.

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 10:50
To: CF-Talk
Subject: INNER JOIN


Hi,

I've been having trouble with JOINS.  My query below works but when i
try outputting my results I am getting duplicate authors (authorID).


 SELECT
 tbl_020authorDetails.authorID,
 tbl_020authorDetails.authorFirstName,
 tbl_020authorDetails.authorSurname,
 tbl_020authorDetails.authorPhotograph,
 tbl_020authorDetails.authorAboutMe,
 tbl_020articleDetails.articleID,
 tbl_020articleDetails.articleTitle
 FROM tbl_020articleDetails
 INNER JOIN tbl_020authorDetails ON
tbl_020articleDetails.authorID = tbl_020authorDetails.authorID
 WHERE tbl_020authorDetails.authorPhotograph <> ''


 
 
 
 
 
 
 
 #authorFirstName# #authorSurname#
 I was born
in the outer reaches of the galaxy and ever since first seeing my
first book had a desire to write one.#ParagraphFormat
(authorAboutMe)#
 
 
 A list of my last articles
 
 
 http://www.020.com/webs/02005/
showArticle.cfm?id=#articleID#">#left
(articleTitle, 35)#...#articleTitle#
 
 
 
 
 
 
   
 
 
 #authorFirstName##authorSurname#
 
 

I tried to make the join a RIGHT JOIN and it seemed to work but then
will I add extra criteria to the WHERE i end up getting more
duplicate authorIDs.

Any help would be grateful,

Saturday






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219573
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Order by number of articles (count?)

[Adrian Lynch]

"INNER tbl_020articleDetails b"

should be:

"INNER JOIN tbl_020articleDetails b"

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 28 September 2005 22:30
To: CF-Talk
Subject: Re: Order by number of articles (count?)


Hi Andy,

I tried this option out but it was coming up with an error saying
that the query doesn't have a GROUP AS statement.

i then tried going back to your code from yesterday when i was
getting help on the actual cfquery but still couldn't manage to get
it to work.

At the moment i have it as:

 
 SELECT a.authorID, a.authorPhotograph,
a.authorFirstName, a.authorSurname, a.authorAboutMe, b.articleID,
b.authorID, b.articleTitle, a.articleDatePublishedLast
 FROM tbl_020authorDetails a
 INNER tbl_020articleDetails b
 WHERE authorPhotograph <> ' ' AND a.authorID =
a.authorID AND b.articleAuthenticated = 1 AND b.articleSubTypeID <>
55 AND b.articleSubTypeID <> 68
 

The error i am getting is:

  Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]'tbl_020articleDetails'
is not a recognized join option.

Any help would be great,

Thanks.


On 28 Sep 2005, at 21:13, Andy Matthews wrote:

> The Count function goes in the SELECT portion of your statement.
>
> SELECT COUNT(tbl_020articleDetails.articleID) AS totalArticles
>
>  andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
> -Original Message-
> From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 2:34 PM
> To: CF-Talk
> Subject: Order by number of articles (count?)
>
>
> Hi guys,
>
> I'm trying to work out how to order my query by the amount of
> articles.
>
>  
>  SELECT tbl_020authorDetails.authorID,
> authorPhotograph, authorFirstName, authorSurname, authorAboutMe,
> tbl_020articleDetails.articleID, tbl_020articleDetails.authorID,
> articleTitle, articleDatePublishedLast
>  FROM tbl_020authorDetails, tbl_020articleDetails
>  WHERE authorPhotograph <> ' ' AND
> tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND
> tbl_020articleDetails.articleAuthenticated = 1 AND
> tbl_020articleDetails.articleSubTypeID <> 55 AND
> tbl_020articleDetails.articleSubTypeID <> 68
>  ORDER BY tbl_020authorDetails.authorFirstName,
> articleDatePublishedLast DESC
>  
>
> How do I count how many articles there are, ie something like ORDER
> BY tbl_020articleDetails.articleID(Count as) or something?
>
> Thanks for any help,
>
> Saturday
>
>
>
>
>



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219528
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: restricting cfoutput character length

[Adrian Lynch]

Left(myTitle, 15)

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 28 September 2005 13:31
To: CF-Talk
Subject: restricting cfoutput character length


Hi,

I'm trying to do something which i can imagine is very simple but
can't find the function.   When i display a title
#myTitle# i'd like to just display the first 15
characters and if more then put three dots (periods).  I know the LEN
function but i can't work out how to replace the text with dots after
the 15th character.

Any help would be great,

Thanks,

Saturday




Stu









~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219401
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Queries of queries

[Adrian Lynch]

Yup, it came through. That email is just a reminder to trim your posts. Gets
most people the first time :O)

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 27 September 2005 17:09
To: CF-Talk
Subject: Re: Queries of queries


I'm not sure if it got posted as i got a reply saying there were over
100 lines in the email so:


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219349
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Queries oh queries

[Adrian Lynch]

What goes wrong with your joined query?

Look into grouping in cfoutput for the answer to your second question.

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 27 September 2005 16:02
To: CF-Talk
Subject: Queries oh queries


Hi,

I'm trying to retrieve data from two tables in one query, when i was  
just querying one everything was okay:

 
 SELECT authorID, authorPhotograph, authorFirstName,  
authorSurname, authorAboutMe
 FROM tbl_020authorDetails
 WHERE authorPhotograph <> ''
 

But my two table query (join) had a problem:

 
 SELECT tbl_020authorDetails.authorID,  
authorPhotograph, authorFirstName, authorSurname, authorAboutMe,  
tbl_020articleDetails.articleID, tbl_020articleDetails.authorID,  
articleTitle
 FROM tbl_020authorDetails, tbl_020articleDetails
 WHERE authorPhotograph <> ' ' AND  
tbl_020articleDetails.authorID = tbl_020authorDetails.authorID
 

The thing is that I am trying to pull all the authors and their  
articles - but some authors have more than one article, is this the  
best way to do it?

I'm also worried that if i pull the data like in the join above (if  
that even works properly) how do i break it down, ie how do i  
differentiate between getting information for individual authors?

 
 
 
 
 
 
 #authorFirstName# #authorSurname#
 #ParagraphFormat(authorAboutMe)#
 
 
 The titles to go here.
 
 
 


Thanks for any help.  Should I just keep this in two queries?

Saturday

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219340
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: green and seemingly brain dead, please help

[Adrian Lynch]

Nope, try:

FORM["ceilingPaint" & i]

-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 26 September 2005 16:20
To: CF-Talk
Subject: green and seemingly brain dead, please help


Hey there,

In the body of a , this works:  .  Do I need to use the evaluate function to get
the value of that same variable for use in an update query? What is the
correct way to write the  below.

Thank you very much.

Mark






ceiling #i# is defined 


UPDATE Areas
SET CeilingPaint = #form.ceilingpaint + i#
where areaId = #form.ceilingareaId + i#









~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219243
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Damn Queries!

[Adrian Lynch]

In fact, looking at it again you don't need to join on to the
tbl_020authorDetails table. The AuthorID being in the joining table should
be enough. Unless you want a column or two from tbl_020authorDetails.

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 25 September 2005 16:34
To: CF-Talk
Subject: Re: Damn Queries!


Wow, yours is a lot more simple than my complicated convoluted way!
I'll definitely give your one the thumbs up!

Thanks Ade,

Saturday


On 25 Sep 2005, at 16:29, Adrian Lynch wrote:

> This should work:
>
> SELECT f.FeatureName
> FROM tbl_020articleFeatures f
> INNER JOIN YourJoiningTable j ON ( f.FeatureID = j.FeatureID )
> INNER JOIN tbl_020authorDetails a ON ( j.AuthorID = a.AuthorID )
> WHERE a.AuthorID = #CLIENT.authorID#
>
> Ade
>
> -Original Message-
> From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
> Sent: 25 September 2005 16:07
> To: CF-Talk
> Subject: Damn Queries!
>
>
> Hi,
>
> I have a table named tbl_020articleFeatures which has fields
> featureID and featureName.
>
> I also have  a table named tbl_020authorDetails which has authorID as
> a field (as well as other stuff).
>
> I made a 'cross table' which is called tbl_020authorFeatures - this
> table will have rows to establish which authors are authorised to
> write which particular features.  In here the fields I have are
> authorFeatureID, featureID and authorID.
>
> I am trying to write a query which will pull only the features which
> e particular author can write.
>
> At the moment I have it in 2 queries but i wouldn't be surprised if i
> could just have one:
>
>  
>  
>  SELECT authorFeaturesID, featureID, authorID
>  FROM tbl_020authorFeatures
>  WHERE authorID = #client.authorID#
>  
>
>  
>  
>  SELECT featureID, featureName
>  FROM tbl_020articleFeatures
>  WHERE featureID = '#GetAuthorFeatures.featureID#'
>  ORDER by featureName ASC
>  
>
> And at the moment this is only pulling the first feature ID.
>
> If anyone could be of any help i would be grateful.
>
> Thanks,
>
> Saturday
>
>



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219191
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Damn Queries!

[Adrian Lynch]

This should work:

SELECT f.FeatureName
FROM tbl_020articleFeatures f
INNER JOIN YourJoiningTable j ON ( f.FeatureID = j.FeatureID )
INNER JOIN tbl_020authorDetails a ON ( j.AuthorID = a.AuthorID )
WHERE a.AuthorID = #CLIENT.authorID#

Ade

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 25 September 2005 16:07
To: CF-Talk
Subject: Damn Queries!


Hi,

I have a table named tbl_020articleFeatures which has fields  
featureID and featureName.

I also have  a table named tbl_020authorDetails which has authorID as  
a field (as well as other stuff).

I made a 'cross table' which is called tbl_020authorFeatures - this  
table will have rows to establish which authors are authorised to  
write which particular features.  In here the fields I have are  
authorFeatureID, featureID and authorID.

I am trying to write a query which will pull only the features which  
e particular author can write.

At the moment I have it in 2 queries but i wouldn't be surprised if i  
could just have one:

 
 
 SELECT authorFeaturesID, featureID, authorID
 FROM tbl_020authorFeatures
 WHERE authorID = #client.authorID#
 

 
 
 SELECT featureID, featureName
 FROM tbl_020articleFeatures
 WHERE featureID = '#GetAuthorFeatures.featureID#'
 ORDER by featureName ASC
 

And at the moment this is only pulling the first feature ID.

If anyone could be of any help i would be grateful.

Thanks,

Saturday

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Teach yourself

[Adrian Lynch]

Yup, and I'd recommend it.

http://www.amazon.com/exec/obidos/tg/detail/-/0672325667/104-284-8175131
?v=glance

Ade

-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: 09 September 2005 07:37
To: CF-Talk
Subject: Teach yourself


I got hold of Ben Forta's ten minute book on SQL the other day. Is there
something similar for REGEX that anyone can recommend.

TIA!!!


++
Kevin Parker
Web Services Consultant
WorkCover Corporation

p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com

++


This e-mail is intended for the use of the addressee only. It may
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient you
are prohibited from disseminating, distributing or copying this e-mail.

Any opinion expressed in this e-mail may not necessarily be that of the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.

If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217725
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Form Post From ASP.NET to CF not working

[Adrian Lynch]

This doesn't explain the random success of the process, but could the action
attribute of the form be causing some issues?

Can we see some code?

Ade

-Original Message-
From: Caroline Wise [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 20:59
To: CF-Talk
Subject: Form Post From ASP.NET to CF not working


Group,

I have an application that is fed data from a form located on another
server by way of doing the equivalent of a cfhttp post. The problem is
that while there is a server log entry that the post occurred, my
application does not get "hit". For testing purposes I put a cfmail
tag in the top of the page to send me a dump of all form fields
received and when I submit the form I am not getting a message.

But when I set up a test HTML form to submit form fields to my
application, it worked and I got the message.

The odd thing is - the vendor for the submitting form was updating
some form fields last night and early this morning and when they were
testing it then I received email messages with their test values. But,
when I tried their form after I came to the office, no test emails
were generated. I called them and asked them to try the form and they
did -  no test email. They insist they didn't make any changes to
their end since the last time that I received successful test mails.

I agree that it looks like the problem is on our end considering we
have a server log entry, but the problem is - we did not change
anything either, so why did it work this morning and not now?

We have implemented this kind of process several times before with
another vendor in CF and there was no problem whatsoever to connect...

Any light shed on this conundrum would be appreciated

Thanks,
Caroline Wise


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216538
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Request.dsn and flash remoting

[Adrian Lynch]

Where are you setting request.dsn? If it's in App.cfm then make sure that
page is being called when you call the cfc.

Do you run any logic that only works as expected when a browser requests
pages? This might be hampering you attempts.

Ade

-Original Message-
From: Brandt, Chris M. [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 20:11
To: CF-Talk
Subject: Request.dsn and flash remoting


I've got several CFC functions that are utilized by flash... When I have
the datasource explicitly set FR works just fine. When I change the
datasource to "request.dsn", it stops working.



Is there a best practices method for dealing with single location
datasource updating when using flash?



Thanks,

Chris



___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216537
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL/Oracle Indexing a temporary view.

[Adrian Lynch]

Yup, that and the developer edition.

Ade

-Original Message-
From: Anthony Prato [mailto:[EMAIL PROTECTED]
Sent: 24 August 2005 23:26
To: CF-Talk
Subject: Re: SQL/Oracle Indexing a temporary view.


While you have your book open...

is it true that clustered index views are only supported in the
enterprise edition of SQL server?

On 8/24/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Good question! I was just reading about it today while studying for MS's
> 70-229 exam, so here goes nothing...
>
> Taking an example from the book:
>
> CREATE VIEW MyView WITH SCHEMABINDING AS
>SELECT MyColumn, MyOtherColumn
>FROM dbo.MyTable
>WHERE MyColumn = 'Some Value'
>
> Some notes on creating indexed views:
> - The view must specify SCHEMABINDING
> - You must use owner.object syntax
> - You can't use * (ALL)
> - You can't have derived tables
> - No UNION, OUTTER JOIN, sub queries or self joins
> - No TOP or ORDER BY
> - No COUNT(*), instead use COUNT_BIG(*), although I'm not sure if it's the
> use of the * or COUNT() that's the problem
> - No aggregate functions AVG, MAX, MIN
> - The following need also be true:
>- NUMERIC_ROUNDABORT set to OFF
>- ANSI_NULLS set to ON
>- ANSI_PADDING set to ON
>- ARITHABORT set to ON
>- CONCAT_NULL_YIELDS_NULL set to ON
>- QUOTED_IDENTIFIER set to ON
> - The first index created on the view must be unique clustered
> - There after non-clustered can be added
> - Removing the clustered index will remove the non-clustered indexes
>
> Then to create the index:
>
> CREATE CLUSTERED INDEX MyClusteredIndex ON MyView (MyColumn,
MyOtherColumn)
>
> Now how's that for simplicity?!
>
> Probably of no help to you but it's revision for me :OD
>
> Ade
>
> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> Sent: 24 August 2005 22:57
> To: CF-Talk
> Subject: RE: SQL/Oracle Indexing a temporary view.
>
>
> Adrian
>
> Can you share what that SQL might look like, under the hope that Oracle
may
> use the same syntax.  Not a large hope, but hope none the less.
>
> I looked up the Oracle (8i) CREATE INDEX documentation and quickly got
very
> lost on all the variations and convolutions.
>
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
>
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216289
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL/Oracle Indexing a temporary view.

[Adrian Lynch]

Good question! I was just reading about it today while studying for MS's
70-229 exam, so here goes nothing...

Taking an example from the book:

CREATE VIEW MyView WITH SCHEMABINDING AS
SELECT MyColumn, MyOtherColumn
FROM dbo.MyTable
WHERE MyColumn = 'Some Value'

Some notes on creating indexed views:
- The view must specify SCHEMABINDING
- You must use owner.object syntax
- You can't use * (ALL)
- You can't have derived tables
- No UNION, OUTTER JOIN, sub queries or self joins
- No TOP or ORDER BY
- No COUNT(*), instead use COUNT_BIG(*), although I'm not sure if it's the
use of the * or COUNT() that's the problem
- No aggregate functions AVG, MAX, MIN
- The following need also be true:
- NUMERIC_ROUNDABORT set to OFF
- ANSI_NULLS set to ON
- ANSI_PADDING set to ON
- ARITHABORT set to ON
- CONCAT_NULL_YIELDS_NULL set to ON
- QUOTED_IDENTIFIER set to ON
- The first index created on the view must be unique clustered
- There after non-clustered can be added
- Removing the clustered index will remove the non-clustered indexes

Then to create the index:

CREATE CLUSTERED INDEX MyClusteredIndex ON MyView (MyColumn, MyOtherColumn)

Now how's that for simplicity?!

Probably of no help to you but it's revision for me :OD

Ade

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 24 August 2005 22:57
To: CF-Talk
Subject: RE: SQL/Oracle Indexing a temporary view.


Adrian

Can you share what that SQL might look like, under the hope that Oracle may
use the same syntax.  Not a large hope, but hope none the less.

I looked up the Oracle (8i) CREATE INDEX documentation and quickly got very
lost on all the variations and convolutions.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216285
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL/Oracle Indexing a temporary view.

[Adrian Lynch]

It's possible in SQL Server, you can create a clustered index on a view and
then non-clustered indexes(the clustered index is a must for the
non-clustered to be added). Not sure about Oracle though.

I thought it might be of some help to know it's possible on at least one DB
server.

Ade

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 24 August 2005 22:38
To: CF-Talk
Subject: SQL/Oracle Indexing a temporary view.


Can you create an index to a view created with SQL?  I would presume so, but
I am not sure what it would look like.

I am creating a view with the following syntax.  It takes between 1/20th and
1/10th of a second on average to create a view of a few thousand records.


  CREATE OR REPLACE VIEW CREATED AS (
  SELECT
  ...


I then use this view in a fairly complex query to turn values in various
rows into columns.


SELECT DISTINCT
  D_VST_DATE AS aDATE,
  N_LOC_AREA AS AREA,
  (  SELECT
 SUM(TOTAL_RECORDS)
 FROM
   CREATED FOO
 WHERE
   FOO.D_VST_DATE = T.D_VST_DATE AND
   FOO.N_LOC_AREA = T.N_LOC_AREA AND
   FOO.D_DNT_CNTTYP = 'WB'
  ) AS WB, --This block repeated for three different D_DNT_CNTTYP values.
  ...
FROM
  CREATED T
  ...


This works but it is rather slow.  Taking about thirty seconds to process
the above view of a few thousand records.  I would think an index on the
D_VST_DATE and/or N_LOC_AREA fields in the view might speed this up a bit.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216277
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: raw XML text of a node??

[Adrian Lynch]

XMLText refers to text between nodes:

This is XMLText

Use ToString(nodes[1]) and strip off the xml declaration at the top and
you're good to go.

Ade

-Original Message-
From: DRE [mailto:[EMAIL PROTECTED]
Sent: 13 August 2005 20:56
To: CF-Talk
Subject: Re: raw XML text of a node??


Its not my xml.  I'm parsing a feed that I dont have control over.
DRE

On 8/13/05, Ewok <[EMAIL PROTECTED]> wrote:
> Wrap it with 
>
> Eg.
>
> 
> 

RE: file size missing with CFFILE use

[Adrian Lynch]

Can we see the code you're using?

Ade

-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: 13 August 2005 16:10
To: CF-Talk
Subject: file size missing with CFFILE use


Hi all

after upload files to our server 20% that files don't have file size
properties saved to DB. Do you know why CFFILE file size is missing?
Maybe using Java getSize directly could be resolve that?

Cheers

MD



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214867
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: raw XML text of a node??

[Adrian Lynch]

Throw a ToString() in there somewhere, see if that helps.

Ade 

-Original Message-
From: DRE [mailto:[EMAIL PROTECTED]
Sent: 13 August 2005 17:28
To: CF-Talk
Subject: raw XML text of a node??


Hi, This amazes me. It seems there is no function to get the raw xml
component of a node?

See this code




hello










#nodes[1].XMLText#

You can see in the cfdump the html text I want to extract
(hello) but when I go to xmltext there is nothing
there.  It continues to treat it as xml and break it up into
structures.

Anybody know if theres a trick or missed function or do I have to go
to java and see if that implementation is more sophistocated?

DRE
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214866
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SOT: and style="border..."

[Adrian Lynch]

"Am I missing something?  Is there an easier way to accomplish that?"

Yes, get a pen and draw the border on your monitor :OD

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 11 August 2005 21:05
To: CF-Talk
Subject: RE: SOT:  and style="border..."


It actually doesn't work in IE, so it's not even a feature there.

so, to put a border around an entire 'row', I had to put left border on the
first TD, right border on the last TD, and top and bottom on all of them.
That seems kind of kludgey.  Am I missing something?  Is there an easier way
to accomplish that?

Dave
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214643
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cell phone video

[Adrian Lynch]

If you get anywhere with this could you post your findings to the list?

It's always good to know things like this.

Ade :O)

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 04 August 2005 18:51
To: CF-Talk
Subject: OT: cell phone video


anyone know how to deal with 3gp files?  I guess Quicktime can play them
but I'm kinda hoping to find something (coldfusion, java, executable)
that can convert 3gp files to some other format (preferable flv) on the
server side.

Rick




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Number to String

[Adrian Lynch]

I'm sure something else is going on in your code. Can we see it?

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 04 August 2005 21:53
To: CF-Talk
Subject: Number to String


This is making me crasy. I'm doing a bunch of conditional
stuff using CFSET to add multiply a bunch of numbers for
costing. The variables all stay numbers until I add them
together like this.



At that point if the number is greater than 999 the number
adds a comma and turns into what ColdFusion thinks is a
string.

Lee Surma



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213812
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Data driven local maps

[Adrian Lynch]

Google Smoogle, forget Google Maps, what you need is Mapscape! :OD

http://www.mapscape.net/map.cfm

Ade

-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: 01 August 2005 23:40
To: CF-Talk
Subject: RE: Data driven local maps


Google Maps.  Check out the API.


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 3:05 PM
To: CF-Talk
Subject: OT: Data driven local maps

We're looking for some type of mapping software that could plot locations on
local street maps.  Things like restaurants in a city neighborhood, or
lodging properties in a ski resort.  The maps could be Flash (with
mouseovers giving additional location detail, like business name, address
and phone#) or gif/jpg with JavaScript.

The maps would be generated from data in our database that changes fairly
often, but not so often that the maps would need to be generated in
real-time.  They could be generated when locations are added or removed from
the database or perhaps once per day a new set could be rendered.
They'd also need to be generated from only street addresses, since we don't
have lat/long coordinates for any of the locations.

Any ideas for server-based software that could accomplish this?






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213443
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Inserting new record into DB based on new line

[Adrian Lynch]

As a quick thing to check and without seeing your code, try using Chr(13) &
Chr(10), or the other way around, as the delimiter.

Ade

-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: 01 August 2005 12:55
To: CF-Talk
Subject: Inserting new record into DB based on new line


I'm having a hard time trying to write some code and was hoping
someone could give me some ideas on the best way to handle this.

I have a spreadsheet that I need to take info from and dump into a
database table, that's simple enough but in the spreadsheet, a couple
of the cells have 5 lines seperated by a new line that need to be
inserted as 5 seperate rows in the table.

 I was trying to loop through the field as a list with Chr(10) as the
delimeter and do an insert that way but it's just creating 5 records
with all 5 lines in each row rather than 5 seperate records with each
line in those 5 records.

Thanks,
Ben



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213425
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT - MCAD Study books

[Adrian Lynch]

Anyone out there passed or is studying to pass their MCAD exams?

I'm looking to do 70-315, 70-320 and 70-229 and am looking at buying the
corresponding Exam Cram 2 books. Can anyone comment, good or bad?

http://www.amazon.com/exec/obidos/ASIN/0789728974/ref=pd_sxp_elt_l1/103-8280
718-7378259

Thanks.

Ade




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210537
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Quick OT Javascript question. PART 2

[Adrian Lynch]

Yup. Use this notation:

document.myform[colortype].value;

>From the looks of your code, the generated HTML will look something like
this:



asas



asasa



asasas



sasasa



Is that ok for you?

Ade

-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: 14 June 2005 14:02
To: CF-Talk
Subject: Quick OT Javascript question. PART 2


Another question:

In my previous question.. I needed to grab the currently selected option
from a select list.

I can now get the selected value using this code...

var SelOpt = document.myform.colors.options.selectedIndex;
var colortype = document.myform.colors[SelOpt].value;

I now need to get the value of a hidden input that is dynamically named from
the select list value...

Visusally it looks like this...


#name#



I am looking to get the RATING value.
I can get the selected NAME using the code above, but my attempts to extract
the hidden variable have been unsuccessful.

I've tried:

var amt = 'document.myform.' + colortype + '.value';
and
var amt = document.myform.colortype.value';

I'm stumped.. Any suggestions???

Thanks,
Jeff




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209385
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: how to post

[Adrian Lynch]

But posting a message and then being told you can't post via email is
annoying don't you think?

Ade

-Original Message-
From: Aminova, Elena [mailto:[EMAIL PROTECTED]
Sent: 09 June 2005 16:25
To: CF-Talk
Subject: RE: how to post


There is an indication, they send an email out to you, if you are logged
in, but not signed up for that particular list. At least I got an email
when I didn't sign up for the list and tried to post a message.

-Original Message-
From: stylo stylo [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 09, 2005 11:18 AM
To: CF-Talk
Subject: RE: how to post

>It works

Yeah, see other thread. This one showed up after I signed in. Or maybe I
just can't post on the other list. But there needs to be an indication
of some sort if you can't post.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 08/06/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209110
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Naming variables within a loop

[Adrian Lynch]

Try:

FORM["selectrestrictionsite1_#primernum#"]

or:

FORM["selectrestrictionsite1_" & primernum]

Ade

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: 08 June 2005 22:46
To: CF-Talk
Subject: Naming variables within a loop


I am having trouble with this sort of thing:





.



I am getting invalid CFML constuct errors. It does not appear to like:
form.selectrestrictionsite1_#primernum#

The actual form variable names would be:

form.selectrestrictionsite1_1
form.selectrestrictionsite1_2

form.restrictionsite1_1
form.restrictionsite1_2

etc. as it loops through.

What is the best way to do this?

TNX.

Richard Colman
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.5 - Release Date: 07/06/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209037
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Adrian Lynch]

24 times at the greatest depth!! :Oo

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 16:26
To: CF-Talk
Subject: Re: CF vs LAMP


.and it was impeccably indented :)

On 6/2/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> Well, it had comments! ;-)
>
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> -Original Message-
> From: Micha Schopman [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 02, 2005 4:36 AM
> To: CF-Talk
> Subject: RE: CF vs LAMP
> 
> This is true code running in production I had to review once (because
> there was an error somewhere)
> http://www.mschopman.demon.nl/horror.txt

--
Charlie Griefer


"...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed."



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208399
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Adrian Lynch]

Holy crap!

I suppose it could have been worse, it could have all been on one line! :Oo

Ade

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 12:36
To: CF-Talk
Subject: RE: CF vs LAMP

This is true code running in production I had to review once (because
there was an error somewhere)
http://www.mschopman.demon.nl/horror.txt

Micha Schopman
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.4.1 - Release Date: 02/06/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Adrian Lynch]

Not on 6.1 or 7 is doesn't.

Ade

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 1:15 PM
To: CF-Talk
Subject: Re: Application.cfm

e, doesnt an EMPTY application.cfm file barf?

tony
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.3.3 - Release Date: 31/05/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208262
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Adrian Lynch]

Not as such. But you can create a second App.cfm in a sub directory and it
will use that one instead.

Ade

-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: 01 June 2005 18:12
To: CF-Talk
Subject: Application.cfm


Is there any way to tell a page in a directory or sub directory to not
run/inlcude the application.cfm



Christian
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.3.3 - Release Date: 31/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208241
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Figured out the billing>shipping population - here it is

[Adrian Lynch]

A couple of things I'd change. You have 20 references to the same form and
your formatting isn't the best.

1. Make a shortened reference to the form, f. This will reduce the amount of
text/typing and a form name change can be done in one place.

2. Don't indent the large block beneath the one line if statement. It makes
it look like it's part of the if block.

3. Also, space some of your code out, opps, that's three things...

4. Ahhh christ, now it's four... I'm not sure about this but be careful with
variable names like checkbox, I'm sure that one's ok but you might get in
trouble with others.

function CopyAddress(checkbox)
{

var f = document.form1;

if ( checkbox.checked == false ) { return; }

f.s_fname.value = f.fname.value;
f.s_lname.value = f.lname.value;
f.s_address1.value = f.address1.value;
f.s_address2.value = f.address2.value;
f.s_city.value = f.city.value;
f.s_state.value = f.state.value;
f.s_zipcode.value = f.zip.value;
f.s_country.value = f.country.value;
f.s_phone.value = f.phone.value;
f.s_email.value = f.email.value;

}

Ade

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 28 May 2005 18:16
To: CF-Talk
Subject: Figured out the billing>shipping population - here it is


K guys, thanks for your help.

This is my working JS code for auto-populating the ship to inputs. If you
see anything that can be improved let me know.

Thanks,
Will


// function to copy billing address to shipping address
function   CopyAddress(checkbox)
{
 if(checkbox.checked == false) { return; }
   document.form1.s_fname.value = document.form1.fname.value;
   document.form1.s_lname.value = document.form1.lname.value;
   document.form1.s_address1.value = document.form1.address1.value;
   document.form1.s_address2.value = document.form1.address2.value;
   document.form1.s_city.value = document.form1.city.value;
   document.form1.s_state.value = document.form1.state.value;
   document.form1.s_zipcode.value = document.form1.zip.value;
   document.form1.s_country.value = document.form1.country.value;
   document.form1.s_phone.value = document.form1.phone.value;
   document.form1.s_email.value = document.form1.email.value;

 }




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207957
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: but funny just the same.

[Adrian Lynch]

What the heck does your email client/server do to hyperlinks!?! :Oo

-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 22:59
To: CF-Talk
Subject: WOT: but funny just the same.


I’m not trying to start a discussion on this. I just thought you guys might
get a kick out of it.



HYPERLINK
"http://ned.bounceme.net/Tattoo2.jpg"http://ned.bounceme.net/Tattoo2.jpg




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207096
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Anyone know of a more elegant way to do this?

[Adrian Lynch]

You could use Chr(65) though to Chr(90), this will give you A through to Z.

Chr() and Asc() together might give you something better.

Ade

-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 19:34
To: CF-Talk
Subject: Anyone know of a more elegant way to do this?


I'm incrementing a project number, it's an alpha-numeric "number"  (001000A
or 001000AA) if it's a new project I just grab the first six numbers and
increment, if it's an extended project I have to increment the letter with
the next one.

My code works but it's kind of a battering ram approach, is there a more
elegant way to do this?

Thanks

sas












Scott A. Stewart,
Web Application Developer

Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 17/05/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207066
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Crystaltech session invalid error

[Adrian Lynch]

Try String instead of string...

Ade

-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 09:23
To: CF-Talk
Subject: RE: Crystaltech session invalid error


hum, I just ran a jsp page on mine and it wont run
http://www.jamwerx.com/1.jsp.

 If you really think you are on to something I will let u in mine.

~Dave the disruptor~
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.11 - Release Date: 16/05/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Looping over submitted form fields

[Adrian Lynch]

Is there?

If you have for example:





Then on the action page:


query
INSERT 
#FORM["name_" & i]#
/query


Is that what you mean?

Ade

-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED]
Sent: 12 May 2005 17:56
To: CF-Talk
Subject: Looping over submitted form fields


There's a method for doing multiple record inserts from a form, and I've
completely forgotten how to do it

Help

Thanks

sas

Scott A. Stewart,
Web Application Developer

Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206551
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: usability question involving a sort.

[Adrian Lynch]

I wouldn't, it just confuses what should be a simple action. Of course if
the customer wants it that way then change it :O)

Ade

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 12 May 2005 17:36
To: CF-Talk
Subject: usability question involving a sort.


I have data that looks something like this.

Tran   Service   Product   CPT
RBC  004350P9016
FFP  034361P9017
102199 102199  86999
102131 102131  86808

There are contols to sort each column in either ascending or descending
order.  My question involves the blank values when sorting by either the
Service or Product columns.  Is it good, bad or indifferent that when these
columns are sorted in asscending order, the blank values appear first.
Since there can be several dozen rows like this, they seem to be kind of in
the way to me.  But maybe that is just me.  Would it be worth my time to
somehow progamatically ignore these columns in the sort order basically
always relegating them to the bottom of the list?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206546
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: What's wrong with this code?

[Adrian Lynch]

Your code is doing this:



so it looks for the string """. Not as you seem to want, the double
quote.

Try:



Ade

-Original Message-
From: jgeorges [mailto:[EMAIL PROTECTED]
Sent: 12 May 2005 17:29
To: CF-Talk
Subject: What's wrong with this code?


..







..



origtext contains double quotes (") which the REPLACE function does not
convert.



TIA,

Sam
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206544
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Writing Binary Images to Screen

[Adrian Lynch]

Wrap #content# in cfoutputs. What happens?

Ade

-Original Message-
From: Peter Shaw [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 12:19
To: CF-Talk
Subject: Writing Binary Images to Screen


Hi,

I have a COM object that returns a binary image file. How can I write this
to the screen?

My best effort so far - which seems rather inelegant - is:




my attempt to improve on this was to have something like:



in a calling file where imageMaker.cfm calls the COM object and uses
CFCONTENT to return an image/gif type file. However, I run in to problems
with this when I attempt:

#content#

because, of course, we cannot write binary files to the screen.


Is there anyway to do this without having to write the binary info to a
file? Those lucky people over at Microsoft can simply do:

Response.BinaryWrite content

Peter
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206327
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: calling stored procedure error..

[Adrian Lynch]

Whatever variable you're passing to SUBSTRING() is probably empty.

Ade

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 12:16
To: CF-Talk
Subject: calling stored procedure error..


I dont understand this error...

Macromedia][SQLServer JDBC Driver][SQLServer]Invalid length parameter passed
to the substring function.


104 :   cfsqltype="CF_SQL_VARCHAR"
105 :   value="#region#"
106 :   dbvarname="@region">
107 :
108 :   





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206325
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: link validation ?

[Adrian Lynch]

Also, target="_blank" won't validate as strict.

Ade

-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 08:51
To: CF-Talk
Subject: link validation ?


how can I make a link like this validate xhtml?
 http://www.mapquest.com/maps/map.adp?searchtype=address&country=US&add
tohistory=&searchtab=home&address=7513+Grandview+Ave&city=&state=co&zipcode=
80002" target="_blank">map it

~Dave the disruptor~
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206320
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: MSSQL Function

[Adrian Lynch]

Take a look at SUBSTRING.

Ade

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 10 May 2005 15:32
To: CF-Talk
Subject: MSSQL Function


I have a variable like this.. ',6,6,8,2,10,11,'

what mssql function(s) can I use to remove the commas before the first 6 and
after the last number (11) ?
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 09/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206206
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: AV on CF servers

[Adrian Lynch]

"but apparently it doesnt like the js that cfm makes either"

Who does?!


-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 28 April 2005 23:24
To: CF-Talk
Subject: RE: AV on CF servers


I see problems all the time with users not seeing pages correctly and in
every case its been a norton error. As soon as they disable norton the pages
work fine and in a case where I was there and say it happen I looked at
source and it just had an error that started with syn_error, wasn't to hard
to figure that one out.

 Most recently, users using the cfdocument pages at one site wouldn't see
anything and in every case it was norton.

 Draw your own conclusions...

 I stopped using norton because it just doesn't do a good job with viruses
and because it's such a system hog but apparently it doesnt like the js that
cfm makes either.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 27/04/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205022
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Finding "page" in a query.

[Adrian Lynch]

You don't have to, it's available as queryname.CurrentRow.

Ade

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 26 April 2005 23:11
To: CF-Talk
Subject: RE: Finding "page" in a query.



In that case, do you really want to move the user to a page out of sequence?
Aren't they more likely to want to see the next records in the sequence to
potentially edit those?


Good question!  I was thinking of showing them the updated record, as
reinforcement that "yes the record you changed has changed."

But maybe this is not the best way to do this, HMMM.  Going to have to think
on this and probably ask the project lead when she return tomorrow.

Mean while, If I wanted to add a column numbered 1 to Number of Records in a
query of query I'm using to sort by the selected column, how might I do
this?


  SELECT
TRAN_CODE,
SERVICE_CODE,
PRODUCT_CODE,
CPT_CODE
  FROM
variables.CPT_data
  ORDER BY
#sortCol# #sortDir#


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204583
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfqueryparam and null values

[Adrian Lynch]

I didn't quite understand your email, but there is an attribute
null="yes|no" for cfqueryparam. Is that of any use to you?

Ade

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: 26 April 2005 22:02
To: CF-Talk
Subject: cfqueryparam and null values


Are there any best practices for nulling cfqueryparam values?
Currently I'm having to write a cfscript before this insert query that
checks each value and then sets a specific null variable value that is
then called from the cfqueryparam tag, otherwise the query fails.
Problem is, it's a ton of code (inserting a bunch of columns), I'm
feeling lazy (it's 5:01 and I've been at this page all day), and I
think there should be an easier way (why oh why isn't there an
"autonull" attribute for cfqueryparam?).

Anyone?

Pete
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 25/04/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204556
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Stupid XML question

[Adrian Lynch]

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi20.htm#wp346877
0

and the XML and XSLT in ColdFusion MX PDF here

http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html

should tell you all you need.

Ade

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: 26 April 2005 03:14
To: CF-Talk
Subject: Stupid XML question


OK.  First I must confess I don't work with XML hardly at all.  That
will be obvious I guess.

I am using SOXML to convert an xml string into something I can use.



 0425070052843
2001woo
hoo ">



It produces a nested structure (you can view the cfdump for this code
at the url above).

How the heck would I reference individual values in my CF?  I tried

#myXML.ww_javagame.ww_cpid.value# and my error handler just laughed.
What stupid mistake am I making this evening?

--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 25/04/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204421
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Auto-login for trusted users

[Adrian Lynch]

All of the above(below) plus IP maybe?

Ade

-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: 25 April 2005 21:27
To: CF-Talk
Subject: Auto-login for trusted users


I've got the opposite issue...  How can I provide an automatic login for
trusted users?  I know of several methods, but what are the better ones?
Cookie, cert, validate against NT login?
 
 
Constanty "Connie" DeCinko III
Web Architect, Webmaster, Web Developer
Lone Jet Enterprises
Glendale, Arizona
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 21/04/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204354
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Preventing Automated Logins & Registrations

[Adrian Lynch]

I'm sure others will chime in with some answers and I'm sure there are a
bunch of solutions for you to choose from but...

 if you don't mind the delay, what about a confirmation email? Are
scripts that automat sign-ups wise to these?

Ade

-Original Message-
From: Josen Ruiseco [mailto:[EMAIL PROTECTED]
Sent: 25 April 2005 21:11
To: CF-Talk
Subject: Preventing Automated Logins & Registrations


I need to implement a module that prevents automated logins and/or
registrations on a website. You know, the kind where you must read the
letters or numbers off the image and input them before you may proceed.

Has anyone done this? If so, what was the general strategy regarding the
images?

Does anyone know of a module that can be purchased for CF that already does
this?

Any thoughts would be appreciated.

Regards,

Josen Ruiseco
GoMotorBids.com

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 21/04/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204348
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Structures (probably a stupid question)

[Adrian Lynch]

That'll get you an array of structures. One thing to note, unlike this...

myStruct.myKey = "somevalue"

 which works in creating a struct, key and value...

myArrayOfStructs[1].myKey = "somevalue"

 will fail with an error. Hence the need for...

myArrayOfStructs[1] = StructNew()

 before using that index as a structure.

Ade


-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]
Sent: 24 April 2005 16:21
To: CF-Talk
Subject: Structures (probably a stupid question)


I'm trying to understand structures - I understand that they are like the
form scope in that I can access them as myStruct.myVar, but is there a way
to create an array of structures?  I'm thinking it would be nice to create
a structure like:

myStruct.FName
myStruct.LName
myStruct.EMail

And then add people to that sort of like a virtual table that I could later
loop through and add to a real table.

It appears from the reading I've done that one can, but I can't find a
clear example of it.  I'm looking for something will work in CF5 and up.

Thanks,

T
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 21/04/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204165
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: login issues

[Adrian Lynch]

How about logging the user out before they login?

It won't stop them sharing and using the system at different times, but if
one is logged in and then suddenly gets logged out they make think twice
about letting this other user use their login details.

Ade

-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 April 2005 18:18
To: CF-Talk
Subject: RE: login issues


I did in the past implement something like you said about putting a flag in
the DB whenever  a user logs in and not allowing further logins unless there
is first a log off. The problems that came up was that quite a few people
were on dial up and when they lost the connection and logged in again they
were flagged and not allowed entry which created customer service headaches.
And some users lose connections sometimes 3-4 times in a row.

>> From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
>I worked on a site a while back where we had the same problem, users
sharing
>information to login. What I did was to switch their login information to
>their SSN number or credit card number. People are less likely to share
such
>personal information with others. The downside is that you better be sure
>you can protect that information on your end, i.e. hash it. Then compare
the
>hash to the a hash of their entered login info. On top of that use flags in
>your DB to denote when a user logs in and when they log off and do not
allow
>a login to be successful if there is someone already logged in using the
>same info. There are other approaches but this one worked for me and
dropped
>multiple logon attempts almost 100%. Those that keep trying get banned, no
>refund. :-)

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 21/04/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204115
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: More hash on the mailing list

[Adrian Lynch]

You don't use that for anything other than debugging do you? You'll get all
form fields which you might not want. If it is for debugging what's wrong
with ?

Ade

P.S. anyone know what's up with all those funny advertising links appearing
in the archives at HoF? :OD

-Original Message-
From: Andrew Grosset [mailto:[EMAIL PROTECTED]
Sent: 22 April 2005 02:20
To: CF-Talk
Subject: More hash on the mailing list


>Hi guys,
>
>I've got a problem whereby I'm trying to reference my looped variable in an
>SQL statement.
>
>
If I want to check the output of some form variables I output them like so
(notice how the looped variable is referenced: #form[t]):


 
#t#=#form[t]#
 


and as Dave Watts said putting the loop inside the query tag is an option,
personally I think that's the best way and is much quicker to.

cheers,

Andrew.



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: More hash on the mailing list

[Adrian Lynch]

If your form fields are named answer1, answer2, etc. then reference them
like this in the query:

#FORM["answer" & i]#

Ade

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: 21 April 2005 20:45
To: CF-Talk
Subject: More hash on the mailing list


Hi guys,

I've got a problem whereby I'm trying to reference my looped variable in an
SQL statement.




UPDATE tbl_020publicQuestions
SET answer = '#form.answer##i#'
WHERE interviewID = #CheckInterview.interviewID[i]#




My problem appears to be the line SET answer = '#form.answer##i#' - any
ideas how I can get this to work? In my form I had answers put into a loop
(answer1 answer2 answer3 etc).

Thanks,

Saturday
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 20/04/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203897
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Help: GetPageContext().Forward() error!

[Adrian Lynch]

Hi Alex, I trying it on a CF7 shared hosting account I have at CrystalTech
and it worked. A sandbox issue perhaps?

Ade

-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED]
Sent: 21 April 2005 17:47
To: CF-Talk
Subject: Help: GetPageContext().Forward() error!


Help.

When I try to execute a GetPageContext().Forward('index.cfm'); CFMX7 on
Windows.

Here is the errorany idea on the cause and/or fix?

--
500 access denied (java.io.FilePermission
C:\CFusionMX7\wwwroot\WEB-INF\cfclasses\cfindex2ecfm174268981.class read)
access denied (java.io.FilePermission
C:\CFusionMX7\wwwroot\WEB-INF\cfclasses\cfindex2ecfm174268981.class read)
--

Thanks in advance..

--
Alex Sherwood




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How to create query results into a list

[Adrian Lynch]

loop list="col_1" index="i"
loop list="col_2" index="j"
compare i to j here
/loop
/loop

Or check cflib.org for one.

Ade

-Original Message-
From: Chris McCarthy [mailto:[EMAIL PROTECTED]
Sent: 19 April 2005 19:33
To: CF-Talk
Subject: How to create query results into a list


Hi guys,

I've got a database column which is currently storing comma seperated values
(i.e. 1,2,3,4 etc.).  What I'm trying to do is compare each seperate value
to another database column which also has seperated values (i.e. 7,8,9,10).
I'm not sure how to parse those values so CF compares each individual one.
Right now it seems like it's just comparing the first value, or maybe the
whole combination but not going through each value in sequence to see what
matches.

My question is, do I have to pull the data from the columns, set up an
array, use the ArrayToList function, then have it compare?  Is it easier to
just have the query filter it initially?  If so, what is the best approach?
Thanks! :)

-Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.17 - Release Date: 19/04/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203555
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Last ID inserted

[Adrian Lynch]

You "enjoy" using it?! Hmmm, just thinking if there's ever been a bit of
code I've enjoyed using...

 cfpop, no...


 alert(), no...


 cfchart, hell no...


 o, a couple weeks back I had some fun with cfmail! :OD


Sorry :OP

-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 14:40
To: CF-Talk
Subject: RE: Last ID inserted


I enjoy using ident_current.

No problems yet.

Kevin.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203225
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Access query problem in CF

[Adrian Lynch]

Have you looked at the docs for DatePart() in Access? What does it say about
the arguments required?

Ade

-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: 03 April 2005 03:49
To: CF-Talk
Subject: RE: Access query problem in CF


Thanks but it still says too few parameters :(

I'm on CFMX 6.1 with a MS Accecss datasource.

Pat

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: April 2, 2005 19:41
To: CF-Talk
Subject: Re: Access query problem in CF

How about this:

SELECT COUNT(no_stats) AS nb_visite
FROM statistique
WHERE datepart("h",statistique.date_in) = 11

Access has a DatePart function like CF does...

HTH,

Howie

--- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: ---
>
> Hi all,
>
> This query works great in Access but through CF and datasource, it
> says too few parameters, any ideas?
>
> SELECT COUNT(no_stats) AS nb_visite
> FROM statistique
> WHERE FORMAT(statistique.date_in,"hh") = 11
>
> Thanks
>
> Pat
>
>
>





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201289
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: testing....is this thing on?

[Adrian Lynch]

Will's quote of the week...

"Do you have Long Island Iced Tea in Ing-ger-land?"

:OD

-Original Message-
From: Will The Game [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 23:49
To: CF-Talk
Subject: Re: testingis this thing on?


Sorry, not laughing at you.  I sincerely appreciate the insane amount of 
>work you provide for free for us!

DITTO!!
>
>Have a good weekend all, I am off to down a few beers!  Yee-ha, it is the 
>WEEKEND!

Beer? what's that??

Off for a few long islands and codin' for me!


cfset mydrinkofchoice["longislandicedtea"]>


Willeroo! (.netwill)
p.s. I already had a few!
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201242
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54