What is the Now in the xmlhttp.Send(Now) line ? I suppose it should be xmlhttp.Send() ...

You can try this solution. But this is only OK for little tables, as it allways results in a table scan. If the column au_lname contains ',' , you have...

In the order by, you can only use column names from the first select. In pubs, this would work :

select au_id as ID,au_lname,au_fname,phone from authors

union all

select au_id as URN,au_lname,au_fname,phone from...

Simon,

I am not usre I understood the request, but here is some code :

set nocount on

go

--exec sp__droptable 'dbo.sample'

go

-- set up a test environment

create table dbo.sample

(

 EntryDate datetime not null,

 Name varchar(10) not...

My mistake ... I  did not see it was javascript ... Try this :

<%

var to = Server.CreateObject("ADODB.Recordset");

to.ActiveConnection = MM_s4r_STRING;

to.Source = "SELECT newdate, news FROM dbo.news";

to.CursorType = 0;

to.CursorLocation = 2;

to.LockType =...

<%

var to = Server.CreateObject("ADODB.Recordset");

to.ActiveConnection = MM_s4r_STRING;

to.Source = "SELECT newdate, news FROM dbo.news";

to.CursorType = 0;

to.CursorLocation = 2;

to.LockType = 1;

to.Open();

var to_numRows = 0;

%>

<%

Response.Write "&news=" & Server.URLEncode(to.Fields.Item("news").Value)

Response.Write Server.URLEncode(to.Fields.Item("newdate").Value)

%>

<%

to.Close();

%>

I think it should be

Response.Write "&news=" & Server.URLEncode(to.Fields.Item("news").Value)

Bert

Thanks ... just found a little problem. The parameter @Doing is declared as @Doing varchar(512). It should be @Doing varchar(4000), as it is used to contain the posted...

I am not sure what you mean with 'it only returns rows that has duplicate course codes'.

Can you give a DDL of the table and some...

OK ... it was just only an exemple .. You can play with the rowcount and the waitfor values ...

Matt,

in my opinion, the real problem is the definition of 'first row of Consignees/Shippers table for an id'.

Once you can define what is the 'first row', you can use...

You can not use select .. from @var. But you can use execute @procname. I would suggest to use a temporary procedure to do the select. To have exec() and...

I would add a waitfor, to make sure the server is not occupied all the time ... I use this technique a lot. It also helps to avoid a...

I recently wrote a stored procedure I use to post data to an URL and retrieve the result. The procedure posts data as is done by a html...

I do not understand why you need it in a variable to do the insert.

You can do something like this, using the temp table :

create table email_engine

(

 to_address...