Recent content by ignoreme

I agree with Tarwin. Based on the stated (loose) requirements, that is the easier thing to implement. "I think there is a world market for maybe five computers." --Thomas Watson, chairman of IBM, 1943

Or you could write some VBA code underneath the spreadsheet that will write to the database. I have done that before. And, you just place an event button on the spreadsheet surface or create a macro that will just run everything you want to the database. Of course, you will have to design the...

Would it because a mapped drive is not physically on your machine? FSO can only see what is physical. Mapped drive links are just pointers to other locations on other machines (via network). "I think there is a world market for maybe five computers." --Thomas Watson, chairman of IBM, 1943

Or you could use Indexing Service (if that is an option...depending on your web server OS). I have used it and it has performed very efficiently and quickly. "I think there is a world market for maybe five computers." --Thomas Watson, chairman of IBM, 1943

Why do have two parameters in the Stored Proc? And if they are required, the ASP code does not appear to pass any values to the proc. In addition, from I can recall from SQL procs you initialized the parameters to empty strings...if that is the case then the first conditions will always be...

I think the suggestion of coordinates is best. Modify the image with all of the city locations and their icons. Then, take the XY coordinates from the OnClick event and compare them to a known coordinate for results. And, to make it easier to the user to not have to put the mouse exactly...

Look at Replication. There are plenty of wizards inside MSSQL. SQL Server has the ability to publish data between two servers. You can setup the rules, triggers, and so forth. Good luck!

Actually, someone already asked a similiar question. I think the answers would be benificial for this person. thread333-908912

Have you tried: strSQL2 = "Select * from tblSubmenuLink where SubmenuLinkID= " & ssi.item("SubmenuLinkID") or if that does not work, try: strSQL2 = "Select * from tblSubmenuLink where SubmenuLinkID= '" & ssi.item("SubmenuLinkID") & "'" See if that works. I think it is your quotes and...

I agree. Using the Microsoft.XMLHTTP option is the best for what is described above. I thought the MS XMLHTTP object was part of the WIN2k or XP Professional server packages? (I assumed that one of the two servers is being used.)

What kind of class is lordoftherings123 taking?

Why are you using CInt in a SQL string? strSQL = "Delete from tblPageContent where MainMenuLinkID=" & cInt(ssi.item("mainID")) & " and MenuLinkID=" & cint(ssi.item("menuID")) & " and SubmenuLinkID=" & cint(ssi.item("subID")) You should not need to worry about type casting when dealing with SQL...

I assume you are using JScript within ASP (based on the curly braces and semicolons. If you put the response.write outside the while loop and you use the same variables, don't you clobber the previous value in each variable after each iteration. Thus, when the while loop finishes, the...

Have you tried running the SQL script by itself (to make sure you are not getting errors)?

I would write them to a recordset, then sort them however you wanted. Here is an old example of one I did. I created a sub and passed to it: Sub FillRS(ByVal objFolderContents, ByRef objRS) ' Start at the beginning objRS.CursorLocation = adUseClient ' Create...