try this , (but you'll need an unique id):
select * from table t1
where
t1.id in (select top 1 id from table t2 where t2.number = t1.number)
union
select * from table t4
where
t4.id in (select top 1 id from table t3 where t3.number = t4.number and
t3.id not in (select top 1 id from table t2 wh
A faster technique would be to select each line directly in the SQL query.
Like here:
SELECT
'"' + RTRIM(CATEGORY) + '"' + ',' +
'"' + RTRIM(newc2) + '"' + ',' +
...
'"' + RTRIM(C_Alias) + '"'
AS line
FROM table
the query will n
Hi,
IE will never be convinced to set HTTP_REFERER from a window.open() call.
But you can do this trick:
popup
use ONCLICK event and then use the same name for TARGET and window name,
and of course the same page to be opened.
This is working in both IE 5 and NS
HTH
-Marian Dumitrascu
Try to use PreserveSingleQuotes function:
.
WHERE messages.parent = 0 AND messages.active = 1
#PreserveSingleQuotes(KeyWords)#
.
Marian
> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 8:27 PM
> To: CF-Talk
> Subject: SQL Qu
This should work:
select p.text from pages p where id = #id#
#Evaluate(DE(getinfo.text))#
Thanks
Marian Dumitrascu
> -Original Message-
> From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 4:38 PM
> To: CF-Talk
> Subject:
I had this problem once when I used CF4 with IIS4 with Integrated Windows
Authentication and no Anonymous Access and for form using
ENCTYPE="multipart/form-data". After i switched back to anonymous access
everything worked fine.
- Marian
GYRATE Internet Solutions
242 West 30th Street
14th FL
New
Try:
Marian
> -Original Message-
> From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 4:35 PM
> To: CF-Talk
> Subject: form to session
>
>
> Is there a simple way to take the values submitted from a form and setting
> session variables with the same name... e
7 matches
Mail list logo