Recent content by sergeiY

Thank you guys I will look into this red-gate tool looks promising. Thank you Sergei

Hi I need to make a lot of content (not structure) changes to one SQL Server2000 DB. Later on I would need to push these changes to production DB. What I was thinking I would do all my changes to db contents and then will compare new db to back up and somehow script all the changes and then...

Hi I posted this question in ASP forum as well but didn't get any responses yet so I am reposting it here: I need to make a demo version of my ASP/MsAccess Application. I want to be able to give it away to people so they can install it use it for some time let's say 30 days and then it will...

shaddow thank you for your responce given tight timeline I had to abandon this solution and do it a quick way ... Sergei

Hi I need to make a demo version of my ASP/MsAccess Application. I want to be able to give it away to people so they can install it use it for some time let's say 30 days and then it will not function or will pop up a message or whatever ... My application written in classic ASP and...

Hi I am trying to do the following: Set objXml = Server.CreateObject("Microsoft.XMLHTTP") ' Opens the connection to the remote server. objXml.Open "GET", "emailOutput.asp", False ' Actually Sends the request and returns the data: objXml.Send it gives me an...

I worked it out myself :)

Is it possible to write a regular expression that will validate lenght instead of value ? I need to check that length of passed in value is greater than zero or its length equal to zero. I know how to search for a specific value but don't know if I can check for length... I need it to be a...

clarkin You deserved a star for this one. I have to admit I had to face this issue for quite some time and never had an elegant solution for it. Well done! Sergei

clarkin you did it again :) Thank you. I should've looked at your answer in my other thread I see answer for this question :) Sergei

DreXor, What did you mean by: 'Reformat dates as necessary or use Session.LCID to you needs What is Session.LCID ???

clarkin your idea to use strngs for dates is really good I'll defenetly take it on board Thank you Sergei

Hi I have this annoying problem with ASP/SQL flipping month and day in dates... I've got a stored proc that expects 2 date params and I have an ASP page that executes it here it is: Set Cmd = Server.CreateObject("ADODB.Command") With Cmd .ActiveConnection = strConn .CommandText =...

excelent ! Thank you this works NO problemos!

Hi I need to generate a list of dates between 2 dates for example: 1/7/2003 2/7/2003 3/7/2003 ... 30/7/2003 it's trivial right ? here is my code and I don't know why I am getting these results: 01/07/2003 7/2/2003 2/8/2003 <% Option Explicit Dim startDate, endDate, currDate, temp...