Recent content by NormRumac

O.k. I answered my own question... Just put Square Brackets around the database name....[SAMPLES-DATA].

I am trying to execute a basic command to backup my database using the sqlcmd utility that comes with Sql Express 2005. Unfortunately, my database name has a dash in it Database name is "SAMPLES-DATA". When I try to execute the following command, I get an error: SQLCMD -S FILESERVER -E -Q...

Hi. This should be a simple question, but I can't figure it out. I have a dialog box with 2 edit boxes. Intially, edit box1 has focus. However, the user can press TAB, or use the mouse to focus on the 2nd edit box. My question is, how can i determine when the 2nd edit box gets focus, or...

Hi. I need to allow my users to have access to internet explorer, but only to access web pages from one specific IP address. They should not be able to view pages from any sites other than this one (which happens to be stored on a remote server). How can I accomplish this?

Yes, surprisingly this is not the 1st time i've been told to stay away from triggers. I guess it can get kind of messy if one is not careful... Thanks, --Norm

I use one of the tables in my database as a log of user transactions. I don't want table growing indefinitely large, so I was wondering if I can prespecify a way keeping the table fixed at say 100 rows. In other words, once the table is filled with the a 100 rows, the next inserted row will...

donuntman...YOU ARE A GENIUS! That was the problem. For some of the rows, the datearrival field was not input correctly (i.e. Not in the form like 'March 4 2004'). I fixed that and now the query works! Thanks, --Norm

Unfortunately, I get this same error message, even with your statement: "Syntax error converting datetime from character string

I got a problem with an sql statement: In a table there is a field of type varchar. That field ,called datearrival, contains human readable dates such as "March 4th 2004" (no quotes). I want to select all items for which the number of days between datearrival and the current date is > 50. So...

That did the trick! Thanks! --Norm

Several months ago I foolishly named my SQL (actually MSDE) database "my-database". Over the last few months several applications which reference the database with this name have been created. Now that the database has recently gone from "test" mode, to "production" mode, I want to start doing...

Thanks for the help guys. I got it working now!

Also, one more question, if i am going to use DOM and make an XMLHTTP request, does that impose any requirements on the remote webserver? For instance, does the remote webserver need to be running ASP?

Thanks for your help. Looks like I will have to read up on this DOM stuff since I'm totally new to XML.

I want to obtain the value of the exchange rate relative to the Canadian dollar. In other words, from the link above, I want the value (1.308) between the <value> tag listed below: <Country UnitName="Dollar">Canada</Country> <Value InUsd="false">1.308</Value> I don't want to have to load up...