im trying to set up an array of database records. i want to be able to display all information but only display the request numbers once for each number...while displaying all seq number's associated with each request number. ex:
right now, it works so that the request numbers are printed out for each seq number....i've marked the section of code where the problem is being caused...i think it's in the way im trying to set up the array. Code:
I trying to set an array inside a loop with the variables of the loop. It seems to loop throught once then it will throw the following error: Microsoft VBScript runtime error '800a000d'
Here is my code:
<% 'outputquery session outputs fine Dim edit_contents_array total = UBound(session("outputquery"), 2) For i = 0 to (total) 'set edit array edit_contents_array(i,0) = response.Write(trim(session("outputquery")(0,i))) edit_contents_array(i,1) = response.Write(trim(session("outputquery")(1,i))) Next %>
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array with a variable that has an integer value but I can redimension one this way. I haven't see any information that tells me if this is a requirement, although it appears to be because I get an error if I try it.
Ex.
Dim b b = 10 Dim a(b) ' this errors out but Dim a() ' this Redim a(b) ' works
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
I am creating an edit facility for an online showroom which I want to output the contents of a database record into a form so it can be edited and updated by the user. Two of the form fields are text boxes of type="file". When I try to output the value of these filenames to the text boxes they don't appear.
I have tried outputting these in a normal text box and they output fine so it is obviously a restriction when outputing to file type text boxes.
I am currently having problem with parsing .asp files when I tried to type http://localhost/iisstart.asp file with my new IIS local server.f I tried to open .html with my localhost server.. it is working properly, example: http://www.localhost/postinfo.html
I suspect it could be because of my firewall or the way I setup my IIS local webserver was inappropriate.
Does anyone know about setting up IIS on WinXP? I have it installed but when I try to use it, it asks for a username and password, and I dont know what the username and passwords are. Any ideas on how to fix this?
I am not able to set cookies with the domain name on a Windows 2000 server with IIS 5.0. If I use the IP address it works. I have another machine running IIS and I configured them together.
i'd like to make asp page which will run on my computer and other users can connect through the internet on it ...it's a simple one asp page. .. the thing is i don't know how to setup ASP server ... anyway ... Code:
I have a dropdown box in my ASP page, which the user can select multiple values. I can read the values out and save them to my database, but how do I make the selected values appear selected on a page when the user goes back to edit/update page?
Have tried the following JavaScript.... document.frmAccom.selAccomType.value=1,3; document.frmAccom.selAccomType.values=1,3; ?? Doesn't work
How do one set the HTMLDirectionality of a Page that is using a Master Page. Normally one would have set the 'dir' attribute of the <html> tag, but one cannot do that on the Master Page.
I am making a small ASP script to track users from an email marketing campaign. Basically the email is sent to subscribers, then when they click on an offer they are sent to a third party provider. Right now we can track how many users open the email, and how many visit the site, but we would like to track conversions. The third party will only provide stats via referer. Is there an easy way in ASP to set a referer to a custom url during the redirection?
I have not used ASP before. Are there cookbook instructions for how to set up an asp directory structure. It is not clear to me how I must mark directories (virtual or physical), so they will all be considered to be part of the same application.
I have no idea what would cause this because my system setting is set to English and all of my other programs that use the date and time are doing it in English but my ASP seems to be giving me the date in Italian For example..
WeekDayName(WeekDay(Now())) = venerd́ instead of Friday.
Is there anyone out there who can set up a relatively easy shopping site. I will need it for selling music cds. This would be for about an inventory of about 2500 titles, which I have in .csv text format or MS Ecxel or MS Access but it should be database driven and easy to be maintained by a non-techie.... I was thinking of mals-ecommerce (oscommerce, I hear has been somewhat difficult), or some other ones that I've seen out there, like ezstores.net, comersus.com, cactusshop.net, or www.alanward.net/acart Thank you very much, and please ask questions, as I am sure there is something I probably left out.
I just want to know what are the setup needed to run my web page without logging in to the server? Im using Windows NT 4.0 as my server and using IIS 4.0 and Micorosoft Transaction Server.
I have this large include file that will change based upon the page that includes it. Is there a way to make the include dynamic, for it to know which file is calling it and use variables based on that file?
I'm trying to use CDO with ASP. How do I set the value the user types in to be a variable that I can use?One specific of this is I want to have a text input for the user's email address. The value the user types in will be stored as a variable (hopefully, if this is possible). I assume it would be something like this:Code:
I've just developed an asp.net website with SQL Server 2000 database. I wish to host it on my own pc. My computer specs are:
AMD 64 3500+ 1G DDR RAM 250G HDD 18MB Buffer ASUS A8V Delux MB Windows 2003
I was going to install IIS as webserver.what other software do i need and what else i have to set? for sure i have to buy a domain name and redirect it to my ip address.
I am trying to learn new stuff using asp. That means I am downloading a lot of examples and looking at them. Sometimes thats all I do is look and compare his/her code to my attempt but also sometimes I need to see a working demo. I find I am replacing the path a lot. Is there a faster way to do this.
can Create a txt file with paths in them and use that to get paths from. It would be differant if I was using the pages but I do not evan have a webpage yet just iis setup on my home comp.
I am having troubles with configuration. What do I add to "httpd.conf" file in Apache, in order to execute ASP files and get everything working? Where do I then put ASP files?
I haven't ever used ASP on a web host but will most likely be shortly with a members area and was just wondering if someone could answer these questions. Do I have to have the ASP files in a certain file and with the database?
Do I only need to have the asp files or do I need a file like adojavas.inc like if I am using in on my local computer with a web server?
In the following piece of code what is the highlighted red piece of code doing?
Code:
<% Dim strSQL, strSQL1, objRs, objRs1 strSQL = "SELECT * FROM tblLOCATION order by fldLOCATION" strSQL1 ="SELECT * FROM tblOCCUPANTS order by fldMAX_OCCUPY"
Set objRs=objConn.execute(strSQL) Set objRs1=objConn.execute(strSQL1)%>
Am i right in thinking that you are setting the recordset to hold the results from strsql from the database that you are connecting to.
I'm a VB/SQL programmer, but not familiar with WEB programming or the Microsoft products for this. I'm trying to set up a development workstation to create and test .asp files running server side VBScripting.
My PC has Win2k Pro and Visual Studio Enterprise Ed. Does anyone know what other software I need to install in order to have a development Web Server?
