Re: Image Resizing tags

2001-08-02 Thread Kay Smoljak
On Wed, 01 Aug 2001 14:01:28 -0400, "Pete Freitag" <[EMAIL PROTECTED]> wrote: >The reason the resize creates a larger file, is because most compression >algorithms for JPEG default at 75% where you might have made the file with >50 or 25% Our tag (cfx_pwimageproc) does allow you to specify the co

RE: Dynamic Stored Procedure

2001-08-02 Thread Stuart Miller
>I was wondering if there is a way in SQL on SQL7 to say if this variable is >passed the add a where clause or something.. You can try SQL CASE statements. You will, of course, have to declare the variables you need in the stored procedure. I have found some performance issuses with using dy

RE: Dynamic Stored Procedure

2001-08-02 Thread BT
Somehow my SQL Statement go cut off but we have select blah blah do this order by your momma See what I mean -Original Message- From: Stuart Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 4:03 AM To: CF-Talk Subject: RE: Dynamic Stored Procedure >I was wondering if

RE: Dynamic Stored Procedure

2001-08-02 Thread Stuart Miller
sorry, not quite awake yet... -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:03 AM To: CF-Talk Subject: RE: Dynamic Stored Procedure Somehow my SQL Statement go cut off but we have select blah blah do this order by your momma See what I mean -

RE: Dynamic Stored Procedure

2001-08-02 Thread Stephen Moretti
How about creating a view in SQL Server that shows all the data without the Where clause, then you can just : select your, fields from theview where whatever It'll save you from doing all the joins over and over again in CF and it'll be optimised by SQL Server, all you have to worry about is you

Verity: Searching multiple collections

2001-08-02 Thread Carlo van Wyk
I am searching 3 different verity collections with cfsearch. Two of the collections are indexed from a database and contains articles and staff details. The other collection is a directory collection of files. I want to use one search, and display results from different areas. The problem is: if