Recent content by bitrot

Nice catch man, nice catch... thanks.

I wrote this function, and it is supposed to return a string that contains a nice looking table so that we can print it. However, response.write just prints out "False". Anyone run into this before ? Function categoryTables() response.write("categoryTables()") 'arrays DIM mfgArray...

Thanks, for your help on the efficiency bit. Works Great A+

FUNCTION setManufacturers() Query = "SELECT DISTINCT manufacturerNameSTR AS Category " &_ "FROM manufacturers WHERE (manufacturerNameSTR IS NOT NULL) " &_ "AND (manufacturerNameSTR <> 'Gift Certificate')" SET RS = SERVER.CREATEOBJECT("ADODB.RecordSet") SET DB =...

I am trying to use getRows so I can close the recordset quickly, I dont need to iterate through the whole thing, I'm actually trying to avoid that at first. I just want a copy of the one columns data stored in a regular old array, not a multi dimensional one.

I want to copy an individual array out of what is returned from getRows with my recordset. How do you copy to a single array from a multidimensional array ? I have tried stuff like. tempArray = multiDimensionalArray(0) '0 being where the array I want is stored and I've also tried REDIM...

yeah, I was stumped.. I just did it the wrong way and said forget it. It wasn't economically viable to waste more time on it. So much for code reuse in this situation. :sigh:

I mean, another syntax error, related to the recordset. I pulled the SET command and the Database connection out of the class and they all worked.

It's only on this page, and only inside this class. If I comment out the offending line, it gives me the same "syntax error".

Here is the offending code block... I get the following error. I don't know what is syntactically incorrect about it though. Thanks In Advance. ---------------------------------- Error Number -2146827286 Error Code Error Description Syntax error ASP Description Category Microsoft...

We are normalizing and redesigning our databases at work. We came across the idea of holding content in the database, but this content would need to be parsed before it is displayed. Basically we want to hold part of an ASP page in a field and then be able to query it. Will asp parse the...

I finally figured out the problem. The include file was included after the opening <% tag. So it wasn't getting inserted and parsed correctly. Thanks for your help though.

I am working on a cart system right now. I have finished the Control Layer and I am in the Visual Layer or my coding. But here is my problem. In the Cart.asp(This is the Visual File with the HTML formatting) I include Cart_Code.asp(the control layer of the design). In Cart_Code.asp I...