Search results for query: *

James, Thanks for the response. This developer has made it so the tables are named dynamically. So there will be no contention if the SP is run by multiple users.

Thanks for the reply bhuninghake. That is a good article but not quite what I am looking for. I am looking for something that says that if you use real tables instead of temp tables of table variables for temporary work that it is a very bad thing.

I am having difficulty explaining to a co-worker why the use of real tables, instead of temporary tables or a table variable, for temporary use (just for a stored procedure) is a bad, bad thing. Could anyone here give me ammo.

Can someone please tell me why this code (it is a function that has a parameter xmlstring): Dim objWebRequest As HttpWebRequest Dim oRequest As WebRequest objWebRequest = CType(WebRequest.Create("https://anon:6442"), HttpWebRequest) objWebRequest.Method = "POST" objWebRequest.ContentType =...

I am not sure where ADO questions should go hopefully here is okay. I have a SP that is returning 5 tables. I am trying to utilize the multiple recordset feature of ADO. Below are some code snippets: My Connection string: Provider=SQLOLEDB;Server=SOMEIPADDRESS;Initial Catalog=DATABASE;User...

Skip, I've a question now. Are you saying that using "" will catch the null values or are you saying to use the "" in addition to the isnull test?

I have been using activePDF at my job. I find it fairly straight-forward and simple to use and install.

I am unsure of where to ask this. I guess since the implementation will be in ASP im landing it here. I need some form of percentage based decision making algorithm. What I am going to do is have a set of percentages in a SQL database....based on those percentages there I want to do something...

(shots in the dark) try the IWAM account as well? Throw group "everyone" on the DLL just to see if it will work.

If you would like to NOT use the global/session recordset consider using the getrows() method of a recordset. It can create some fun 2D arrays but you wont have to requery the DB with each page change.

whats the error?

Wow. I have been pondering how to do that off and on for weeks. I was thinking so much more complicated. Thanx Drex gold star for you!

Make this a little more clear. I use a textfield to do this, so when I say pulls it back out I mean when then script re-populates the text field with the text containing the &_nbsp; or &_#160;

I have a script which will take a text file in any text format and input it into the Database. When I use it for HTML or XSL files and use the &_nbsp; or &_#160; it puts them into the DB fine. When it pulls them back out the browser does it job and converts those to spaces. However I would like...

Wow..I uh need to read posts, or just not reply to them when I am half awake...[dazed] *Points to Tarwn's post* What I posted is not even ASP script runnable.

After Reading the above here's my guess: Using the CDO.Sender property does not allow the following SMTP format: "Display Name" <recipient@example.com> Using the CDO.From property DOES allow the above.

just a simple test to see you could set it the permissions to the everyone "user". also try: wshell.run("%comspec% /c c:\bat\test.bat", ", 0, True)

If you wanted the name resolved from the IP address you will have to utilize some kind of reverse DNS lookup. Try here: http://www.asp101.com/articles/jason/reversedns/default.asp

Connecting IIS to a SQL Server (MSDE) requires that the anonymous IUSR account be granted access to the database\tables. This is easily performed using SQL Server enterprise manager. sp_addlogin will create a user/password for a SQL Server using SQL Server Authentication. When you use the...

Why can you not use SQL Server login?