Search results for query: *

Thanks for the feedback! select, is a mistype I do mean select I've tried the query in query analyser and it runs fine.... But 1) I'm not sure how to view the results of a recordset except field by field and 2) I think the AS part might not do what I'm expecting... I wasn't sure whether to put...

Hi.... I create a Recordset with a "select, a.x, b.x as y from table1 a join table2 b on a.c = b.c" then I want to display both x and y but although response.write(rs.fields("x")) works fine response.write(rs.fields("y")) doesn't. any pointers? Thanks :-)

Ok... I got it wrong. Apparently it was a copy and rename within the database, and that was easy with the import data function! SQL sister I would have used backup and restore if it was between databases... Thanks :-)

Ok. I fess up. I had duplicated the variable but forgotten bout it and in my hurry... anyways... its all beautiful now... Thanks Heaps! :-)

Hmmmmm Thanks for your reply.... I'm under a time constraint so I ended up just looking for it and removing it if it exisited... I could save them to a table to return to their rightful owners?? Thanks again Beth

Hi. I'm using SQL Server 7 and need to copy the contents of one database to another. (I'll rename a couple of the tables afterwards). Is there a good way to do this? I don't even know what to search under (though I have tried!) Enterprise Manager gives you a copy option.. though ?? knows what...

SubjectL = request(&quot;subject&quot;) Dim ObjNewMail Set objNewMail = Server.CreateObject(&quot;CDONTS.NewMail&quot;) objNewMail.From = FromName & &quot;<&quot; & SendFrom & &quot;>&quot; objNewMail.To = SendTo objNewMail.Subject = SubjectL objNewMail.Body = BodyText objNewMail.Send but its...

Hi All My subject line (standard send mail form) is either populated from the calling program or filled in by the user. It appears fine and I've checked that the calling program doesn't add the comma... but as soon as I request it(ie press send) there is a ', ' at the front of the subject...

Please accept my mondaymorningitis apologies. Of course things don't work if you only use 1/2 the code.... Thanks all!!

Small prob with CInt. It doesn't assign a value if it overflows... it just errors :-( Current thought is to define the variables in a file and use them. Any better ideas appreciated Thanks :-)

the CInt way looks good. When I get to go back to that project I'll test it out.... Thanks :-)

Yes I plan to do the validation first and all in one hit... but I want a 'non hardcoded' way to do the check... can I look at the defn of the field and return its size? Thanks :-)

I thought there might be a way to do a cast to convert.. I think thats why I used this forum... Can I move to the ASP forum? It'll have to be in the ASP code before the insert statement that is currently failing... any ideas? Thanks :-)

Hi all... I have a screen field that accepts any char (Can't change that portion) and saves into an Int field. I check with IsNumeric(fieldname) to make sure it only has numeric data. Then I realised that a number like 3214123456 won't fit into the Int field as the largest size is...

I need to update Table1 with Table2 values... the only link between the tables is a field called Email. I need to update 200 records and I want to do something like update Table1 set field1 = select a.field1 from Table2 a, Table1 b where a.Email = b.Email but of course that brings back too...

Don't Worry Found that I'd set MonthDay to Char 10 rather than Char 1 varchar could have handled this but Char pads out the blanks and &quot;M &quot; <> &quot;M&quot; :-(

I've just finished testing my code on one machine and have moved my files across to another server. I have a field in a table (just added and populated) called MonthDay. Its populated earlier and If I assign the value as in MonthDay = &quot;D&quot; if shows up correctly but the one from the...

Cheers for this... I needed to save the details of the popup and then close the window so I used: <% if LCase(Request(&quot;Action&quot;)) <>&quot;&quot; then %> <SCRIPT LANGUAGE=&quot;javascript&quot;> window.close(); </SCRIPT> <% end if %> at the start of the html stuff :-)

It assigns records that aren't in the TempData Table but are in the Recipients Table to Null. I'm going to blame this on bad data in my trial database and try it :-)

I'm going round in circles here :-( I'm updating the Name field in my database. And I want to keep a backup incase something goes wrong (the format needs to be changed) So I have table: TempData with fields 'FirstName', 'LastName', 'Email' and 'Tmp' as my backup and table: Recipients with...