We have some ASP code in a database, say something like
Code:
<%=session("strFirstName")%>
If we ever call that, instead of resolving to the value of the session variable "strFirstName", it shows the whole line of text "<%=session("strFirstName")%>".
The question is, how can we get code like that in the database to generate on the page along with the rest of the ASP code
Does anybody have code to add a "Database Last Updated...." line on your webpages that are generated from an MDB? There is simple ASP and javascript for 'page last updated', but the code that I have found just detects the time when the page was generated, which is every time the page loads since it is querying the database.
Im looking for code that queries when the database was last updated, then displays that info on the page.
i just wanna a simple code for ADD, Find, EDIT, REMOVE asp code to manage a simple database contains only products name and its details and picture to be viewed in web site. is there any?
I have a two pages. The first is a data entry screen (which saves the form data to a DB) and the second page displays the text that was inputted on the previous page( pulled from DB). Is there a way to insert <%=date()%> into one of the text areas and have it be processed on the second page when that text is pulled from the database?
I downloaded an online quiz application from the Internet. The application works fine but and after I answer questions, it does not produce any results and display it on the screen. It gives an error message saying the database is read only.
I think there is a problem with reading the database to retrieve the correct answers. It is an MS Access database. But I don't know what it is and how to solve it.
I'm showing page contents text coming from database, normally the contents are plain text or in html formatting... it works fine.. but I want to add ASP code within page contents, as well... i did try but it dispalys ASP code as it is in the output...
is there any way to execute those asp code lines coming from database...?
How to create a database paging with the code i have. im trying to do database record paging, im not quite sure how i had tried couple of open source code but cant not get it to work with my code:
Can anyone help me find a code for Database Paging? I have seen some of it but its very hard for me to read, its too advance. Need to have a code with beginner to intermediate level.
i have built an interface for template making. i am using a simple form with a text area and submit button to save the code, i want to show in a template page, into the database. I also use the same textare to view any code saved to the database for a specific page.
THE PROBLEM - i have to save a
response.write("<textarea..............></textarea>") the minute i paste it into the textarea it saves it fine but shows it wrong as if once it reads the </textarea> in my saved code the main page 'closes' the main textarea . i.e. the rest of my saved code is shown as part of the page - and its not pretty!
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.
I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before 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