how one can separate an HTML file from the actual code. For example, if I want to create a printer-friendly version of a page, I don't want to have duplicate data.
So, what is the best way to have an ASP .NET page which just just contains layout and other structural code and have it be fed an HTML file for it to display as the main data.
Can any1 gives me code tht helps me to export data from ASP-Database to any file format (xls, txt, ....)?For an example..there is a site for the result of our college.. its an asp connected to the result DB.. it takes the student number and returns query "name and grades".
What i need is a code (or helping tutorials) tht gives tht asp page the number of student and exports his data, then the sec number and exports his data and so on.
I am trying to plot the days off employees have taken in the selected month visually using the following code. The code below takes a long time to execute typically about 8-15 secs each time. Code:
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be. Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/update.asp, line 111 line 11 is strName.execute I read it might be forbiden characters in the data base field names or spaces... but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any input. My boss wants a data grid or matrix of the top 6 orders with ordered items, and products, for a particular customer and he wants to see it like this:
products down the left side orders across the top number of items under the respective order number column across from the corresponding product.
I hope that makes sense. I have three tables. Products, Orders, Orderitems. I don't even know where to start. Many thanks in advance for any input offered.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
Is there any way that I can store my ASP code in an Access DB and have it display that way? Ideally, I would like to make a page with a text area that I can write and edit code in, and then when I submit it, I would like to view the page that the code creates. The code in the DB would include code that selects from and updates the DB. I would like to do this because I can't work remotely now.
This is the error. Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CLASSDATE >= 6/23/2004 ORDERBY CLASSDATE'.
This is the code.
Code:
strSQL = "Select * FROM WellClass WHERE CLASSDATE >= " & DATE & " ORDERBY CLASSDATE"
I am trying to follow the W3Schools tutorial on the XMLDOM object, and it works fine in a regular HTML document inside <script> tags (vbscript), but I am trying to do it in the ASP tags (<% %>) and it does not work. The error says:
Code:
Microsoft VBScript runtime (0x800A01A8) Object required: '[object]'
I am trying to do something with it and I can figure out what to do!I have created a database that lets realtors track clients, potential clients, and offers made. Here is a link to the database:(URL address blocked: See forum rules) What I am trying to do is create a form that lets a user enter his first name, last name, email, and offer amount into textboxes. When they click send it adds their information to the Potential Buyer table (the primary key is an auto generated number.) The offer table is basically an associative table, containing the following information: buyer$buyerid, client$clientid, and amount. I would like the amount to be added to this table, and I would like it to also add the newly created buyerid. My problem is that well, I have no idea how to do this, as the buyerid is created only seconds before I need to post it in the offer table. Could anyone help me out with this? I'd really appreciate it.
Here's the current code that I'm using for navigation through some pages. MY question is, I want the item "System-Add Ons" to still stay bolded if I'm on a page that's in a subset of "Products" Is this possible?
For example, if a user gets to the page "Monitors," (monitors.asp) I want System-Add Ons to stay bolded....
How can I set up subsets of the "Products" page? Do I have to make a directory and do a test if the page is in the directory "Products" and is affiliated with "Products?" Code:
I Wanna to know that which of below codes related to ADO within ASP (VBscript) is better?
CODE ONE :: rsEduCalender.CursorLocation=3 With rsEduCalender if .State=1 then .Close .Open SQLstr,cn,3,1 End With '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''' CODE TWO:: With rsEduCalender if .State=1 then .Close .CursorLocation=3 .Open SQLstr,cn,3,1 End With
i created ASP page for Online TEST it Consist three pages First Page is Selection of Topic and Number of Questions from List Box. Second page is shows the Questions as per the Selection in previous page Datas from the Database. Third Page is Result Page. But My problem is in Second Page, because all the question are created dynamicaly so that how can i get the User answer I get the question id and correct answer for all the questions. but i need to get the user answer for Result.I attached my code for the second page.
Is there a program or website that will validate my asp pages?Kind of like how html pages can be validated on http://www2.imagiware.com/RxHTML/ and on http://netmechanic.com
this is what i am doing for zip codes i want user to enter zip codes like this
92274 92274-0965
so if the user enters zip code like this 92274 then its right but if he enters zip codes like this 922740965 then change it to 92274-0965 this is what i have done so far so i have got the values of first 5 i need to include a -and then the rest of the numbers any idea how to make this work
I have two tables, raceresultsview and jockeyselections. In jockeyselections, I have jockey names and stableid, for example Pat Day, stableid 1000.In raceresultsview, I have jockey names, and placement. I want to do something like this: select * from raceresultsview where jockey in (select jockey from jockeyselections). This works FINE, but I need to figure out how to grab the stableid, too.Each time there is a match, I want to insert the stableid and placement into the table named winnings.
Heres my for next loop. Basically it is pulling files from a folder. Now I want it so that if it reaches the end of all of the files, that it starts over at the beginning. Any ideas? Code:
Moderator (from admin) will see a list of cities to approve/decline.
If approved, then the city will show up in the search and alert city list boxes.
If declined, then the moderator will be asked to pick an approved alternate city and all postings containing the user-inputted city name will be changed to the alternate approved city name.
The moderator will be notified via email when not listed is selected.
Any one have any ideas on how to build this in ASP? I'm kinda new to this ASP programming thing.
I'm looking for a script that will auto complete the state field when someone enters their zipcode.
I'm currently using http://javascript.internet.com/forms/zip-to-state.html but its kind of out dated and often returns null. Does anyone know of a more up-to-date version or one that is updated regularly? It doesn't have to be free.
This was originally posted to Macromedia forum but maybe someone here can assist....... I am a total Newbie to ASP and forums....trying to begin dynamic site building....purchased almost all Sitepoint books trying to determine if ASP, PHP or which is best/easier......
Simple ASP file failing.......also SMTP e-mail from form
Using Training from the source book - Dreamweaver MX dynamic sites.......but software is actually Studio MX 2004, running on Windows 2000 platform using local Microsoft IIS as testing server.... Code:
I learned basic ASP at a computer trade school where it involved sql. After buying webspace from a host, I later learn they do not support sql, only ms access. I've been using code that deals with sql, but at the same time my database has been done in access.
my host has on several occasions been called to fix server side problems, but now it seems only my code is at fault. it tells me the exact line with the problem, but i can find nothing wrong with it, mind you im not very experienced. im hoping that perhaps you will be able to set me straight with this problem. below is the line of code that is erroneous.