Recent content by JonathanC

You can actually modify some parts of the PHP codes if you really want to customize it.

I have a problem with saving a posted file to the database as a text column. I know that array of bytes easily can be saved to an image field to the sql by using the sql parameter with type images. I tried this to a text file by just changing it to text and gives me an error... Public Sub...

That helped me a lot man! Thanks for this post!

When you use <INPUT TYPE=FILE> and open the FileOpen Dialoge Box through clicking Browse... how would you programatically set the default file type (eg. *.avi instead of All Documents)?

Tips: a)Make sure you collect your garbage at the end of a program or procedure. b) allocate resources late and deallocate as soon as you finish using them. c)avoid manipulating recordset after response.write, an sqlrs.getrows assigned to an array and manipulating that multidimensional array...

Check out the following link: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175167 In this reading, I recommend using hidden variable to maintain state. Though its tedious to write, it would pretty work fine rather than using Session or Application variables.

You haven't even asked if they have IIS installed. :)

I have never used params in ADO, first of all its too much code.... how about this... set sqlrs = sqlcnn.execute(myconcatenated_sqlstring) where sqlrs is the recordset and sqlcnn is the connection

Data Environment is very good for tradition client/server applications. Data Environment strong point is ease of development of database applications using windows forms on a two-tier environment. Obviously you wouldn't use this for multi-tier development. Moreover, since our ado...

Please don't use such kind of subject line again. Make it clearer so everybody can get hold of your problem immediately. Anyway, you may begin by creating an ActiveX DLL Project. Compile it and register it through COM+. Call your component using Server.CreateObject.

As a VBER... adding some more ingredients like UML new spices like XML and Web Services... collect your garbage using GD.Collect and wash your hands with SOAP finally cook your recipe with the CLR. you'll definitely sell like pancake!

Can VB.Net create a Pegasus based on a Bird and a Horse? Is multiple Inheritance a .Net Limitation?

Is it possible to install MSMQ 2.0 on the a new domain controller when a MSMQ server is already installed on another domain controller in the same domain? I ask because I am having a problem installing MSMQ on the the new domain controller. It has an error 0xC00E0013. Unable to establish...

Thanks TL, I knew this solution, I was just figuring out if there's a shorter way because I have 15 columns and, though possible, I somehow am thinking twice of doing it like that! But you're the great guy...I guess that's the only option I have so I'll do it that way!

on SP2...create a varchar string of your query using a variable tablename coming from SP1. Execute the string using sp_executesql.