Search results for query: *

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 :-)

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...

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...

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'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 = "D" if shows up correctly but the one from the...

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...

I need an underlined text as a link. HREF does that, but I need to save some vars first. I'm doing this by using the HREF to call the screen again with action specified but I lose the variable values... So I tried the below BUT they don't come through until a POST... <a...

For a display I want to break my values up so three are displayed per line. I currently have: <tr> <% count = 0 while not rs.EOF if count /3 =1 then %> </tr><tr> <% end if %> <td><% rs.Fields(&quot;Name&quot;) %></td> <% count = count +1 rs.MoveNext wend %> </tr> which works fine on the first...

I'm writing from a csv file to a table. I've got the split on comma working fine EXCEPT when my users have a comma within a field. In this case the field is actually delimited by ,&quot; and &quot;, rather than by , , But I can't figure out an efficient way to do this... using regexp I can...

Hi all I'm uploading a CSV file. So I seperate the rows on commas.. which is ok until someone enters a comma in the middle of a row (its text so its valid). I heard rumour (but can't find the thread again) that Excel uses a slightly different Char as its delimiter (thats why Excel seperates...

Hi All... I'm wanting to check for invalid email addresses. the rules I have so far = SELECT Count(*) FROM FileName where Email Not Like '%@%.%' or Email Like '%@%@%' or Email Like '%.' or Email is Null or Email like '% %' (theres a space in there) and this catches most of them. I'm just...

I want to run 3 update queries in a row over the same table on the same field. ie update Trial set Prob = 'D' where Condition1 = true update Trial set Prob = 'E' where Condition2 = true update Trial set Prob = 'F' where Condition3 = true If a record has both Condition1 and Condition2 true...

Hey.. I'm looking at FileSystemObject for the whole CSV file -> sql thing. Haven't delved deeply yet but thought I'd ask for opinions ... I want to upload a CSV file and create a table from it. I can do this using enterprise manager and import data. Is there a similar 'easy' way in ASP or do...

Hi there... I'm a newbie to VB.. and I recently had to change asp code into VB so that I could schedule it to run everyday. Well it works in most cases.. but I'm still ironing out a few errors. I've got a log function after the main portions so I can usually figure out whats happened.. but I'd...

Can someone please explain this to me... I'm wanting to access some of our databases with a vb script and the code that does it currently in ASP = UserID = Application(&quot;DBLogin&quot;) Password = UserID = Application(&quot;DBPassword&quot;) but I can't for the life of me figure out where...

Enterprise Manager for Sql Server 7 Return all rows gives : Query Designer encountered a Query error : Unspecified Error. Yet select * on the same table through Query Analzyer gives the correct data.. does this ring any bells? My DBA has just gone home for the day..... Thanks :-)

Hi All... I have a 'Notes' entry field on my screen and my users will be able to enter: don't forget to brush your teeth We all know that SQL doesn't like the single apostrophe in don't... but is fine if you do: Notes = Replace(Notes, ', '') which gives: don''t forget to brush your teeth now if...

Hi there. I want to : 1) read through a database table and return all rows 2) for each row display (on the screen) a checkbox and input textbox ie. cb NAME inputbox cb NAME inputbox cb NAME inputbox cb NAME inputbox 3) be able to see what checkboxes are ticked and values of the textbox on that...

Man I'm loving the dates in my code. Issue 1: I'm in New Zealand and we format our dates dd/mm/yyyy Issue 2: IsDate doesn't seem to work! Issue 1: faq333-3194 shows me how to set the locale... so I set it for NZ and that displays 28/03/2004 but when I try to enter that as a date it ...

Hi.. again this has got to be easy but RingTFM isn't helping... I have a DateEntered field in my database as: m/d/yyyy hh:mm:ss I want to take that date, strip the time and add a number of days. I've tried using (thanks bgaines72) FormatDateTime(DateEntered, vbShortDate) but that changes it...