Hi: How can I rename the file being uploaded using ASPSmartUpload? I can set the other parameters ok, just looking for the syntax to rename the file. E.G. User uploading GIF file. I'd like to rename the file 'test.gif' ******** <% Dim mySmartUpload Set mySmartUpload = Server.Crea...more >>

I've only used SQL Server until this latest project, and the only option is Access. I've read some things here about how Access just isn't as good as SQL Server, and I agree, but other than scalability, what other things should I look out for? Please note there this is for a church, and perhap...more >>

I am trying to present a list of links on a page (Form) where each link opens a different picture gallery. I have the Form page which contains the links, a Gallery page, and several include files. Each include file displays a different gallery. Clicking on a link submits a value identifying the ...more >>

Greetings, I have a table called locations which holds 9 store locations. I am at my wit's end trying to format these like this: centered City Name(named once) store store store store next, etc. Here's my dilemna: Some cities only have 1 location, some have 4, some have 3. I do...more >>

Hi, I've created a web application with Visual Interdev and I've added Microsoft XML, version 4 in project's references. A META tag has been successfully added in global.asa: <!--METADATA TYPE="TypeLib" NAME="Microsoft XML, v4.0" UUID="{F5078F18-C551-11D3-89B9-0000F81FE221}" VERSION="4.0"--...more >>

Hi Folks, In a nutshell... I have 6 pieces of info describing products in an array which is carried between asp pages in session arrays. e.g. localcart(x,i) For... localcart(ProdID,i)=ProdID localcart(Size,i)=Size etc.. Loop then.. session("cart")= localCart (to carry...more >>

If we use GET protocol, we can use either Request("controlname") or Request.QueryString("controlname") to get the data entered by the user. But if we use POST protocol, we MUST use Request("controlname"), and Request.QueryString("controlname") won't work. I think Request("controlname") means Req...more >>

I want my application to maintain a directory tree based on months and years, e.g.: 2004 January file file file February file file ... Anyone have some FSO code that would do something similar to the foll...more >>

Has anybody used the UPS tools for calculating shipping and if so how did they go about it? I have seen the articles on 4guysfromrolla but that appears to be using xml component to get the data from the ups site rather than using the developers tools provided by UPS. I am just not sure the bes...more >>

My function versus the Int(DateDiff()) approach Here was the code used ... then the results By the way, my function and aspfaq.com's calculations are equal (and correct for that matter). <% Function yearsOld(birthDate) Dim currentDate, monthDayComparison, addYear: currentDate = Now...more >>

In ASP page, there is a "SELECT ALL" button, when user click it, it will select all checkboxes. I am not sure should I use client-side code to do that? the following is my approach but it didnt work. <script language="JavaScript"> function selectAllCheckBox() { //alert(document.addzone.c1.val...more >>

I use the following SQL command in my ASP webpage... SELECT DISTINCT CarList,CarListID FROM Model My problem is that I would like for "CarList" to be distinct and not "CarListID". How can I fix this problem? ...more >>

When the ASP statement end with a _ character, then the next line cannot have comment ' character. Is that correct? Since I encountered the following error: Microsoft VBScript compilation (0x800A0400) Expected statement sqlStmt = "insert into TimeSlot (WeekDay, BeginTime, EndTime) VALUES...more >>

In ASP page, if we want to retrive the number of rows in database: should we use recordset object? Since this is not update, insert, delete, or select statement sqlStmt = "SELECT COUNT(*) from table1;" Set objRS = Server.CreateObject("ADODB.RecordSet") objRS.open sqlStmt, strConnect...more >>