How would I insert this code into a .HTML document rather than a .ASP document.
<%
Set MyFileObj = Server.CreateObject("Scripting.FileSystemObject")
Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath("content.txt"))
WHILE NOT MyTextFile.AtEndOfStream
Response.Write(MyTextFile.ReadLine & "<BR>")
WEND
MyTextFile.Close
%>
Works fine in .ASP but not .HTML.
I'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg £ for £.y . when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg £, rather than showing the original value, eg £.
If for example I put a space between the '&' and the 'pound;', eg & pound; then this will cause me problems because the user will think that they have to a put a space in or they file it with the space, which means the HTML code won't work any more. Is there a way round this?
I have a problem. I have ASP code and Javascript code. Now, I want to access ASP code inside javascript code. Here is the ASP code:
View Replies View RelatedDoes Anyone Know How To Add HTML into An Access Database? I Am Building A Blog And Have A WYSIWYG Editor. I Get An Illeagle Character Error When I Try To Put HTML Into The Database.
View Replies View RelatedI am trying to set up a staff update page for a local school and have set up a database to record it. I know the database works because I can populate it and display the content. When I went to write the insert statement I get an error that i am unsure how to solve. This is the statement. Code:
SQL = "INSERT INTO staff(first,last,email,position,phoned,job,thedate ) Values " & _
"( '" & first & "', '" & last & "', '" & email & "', '" & position & "', '" & phone & "', '" & job & "', '" & thedate & "')"
i am creating message board like software ..
if some user wants to put following code..
=====================
article_inst = "INSERT INTO articles (con_id,cat_id,sub_id,tlevel,title,brief,descripti on,link,ins_date)"
article_inst = article_inst & " VALUES ('" & conid & "' , '" & catid & "', '" & subcatid & "', '" & tlevel & "', '" & title & "', '" & brief & "', '" & desc & "', '" & hlink & "', '" & dt & "')"
con.execute(article_inst)
=======================
it contains single codes which if i try to insert it gives error
how to solve this.
I have a problem with my INSERT query, I have tblDueDates, tblClient and three main forms.……..but I get errors when trying to insert payments. I have tblClient and tblDueDates and 1.frmDueDates, to insert and display the due dates for the payments ,
2.frmPayDateList in order to display the Due Dates of all clients in a list according to their due dates and 3.frmClientsPayedrecord, to see the payments of each client after the user clicked on the ‘payed’ button on the 2.frmPayDateList form. Form frmDueDates and frmClientsPayrecord are linked to tblDueDates.
But I get an error when clicking on that ‘payed’ button on the frmPayDateList. I use an INSERT query to insert the payments into that one table tblDueDates and also it should avoid duplication with this query and it’s where clause!!!!
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
I am designing an Interactive website that uses MySql. At the moment I have just designed the Login pages for users. However to do this I have a Login.html page and a Login.asp page. The values from the html form is posted to the asp page which checks the details against the databse and redirects the user acordingly.
However I would like to have just one Login.asp page where this is all done in. I have tried simply putting the html code into the asp page but the problem is that as soon as i run the login.asp page (on IIS), the asp code is also run. How can I change this so that only once the user clicks on the submit form button, only then the asp code is executed?
My website is currently made up of HTML pages and residing on a Windows server.
Currently converting them all to ASP, that is going from .html extensions to .asp (besides adding funking asp functions)
My pages have all being indexed by Google, so wouldn't risk loosing good ranking with Javascript redirects, so I tought using this would solve the issue, for example, on a file named thatpage.html
<SCRIPT LANGUAGE="VBSCRIPT" runat="server">
Response.Status="301 Moved Permanently"
Response.AddHeader "Location", "http://www.mywebsite.com/thatpage.asp"
</SCRIPT>
Wherever where I insert it, in the head, in the body, before the DOC, it's not working, will have to resort to javascript? Will I have to put a link in the html page leading to the asp page? Wouldn't like to have user click agin to be led to the .asp version?
I'm looking for asp or java script that encrypt html
code. That it will confuse some surffers that trying
to steal content.
I have creating a simple ASP guestbook using an Access Database, is there any of disabling HTML code so that visitors cant post HTML in the guestbook entries?
View Replies View RelatedHow do you put an asp code inside an html tag?
This is not working:
<a href="contact.asp?subject=Question about group
<%=(Recordset1.Fields.Item("group_name").Value)%>">Send a message</a>
I am actually putting above info in an Access field. People would be able to send me email through a form in contact.asp and I want the subject line reflect which page they came from.
So, when my search returns the result I need one of the fields to be clickable and show the customer's info for the clicked customer.So, lets say we make the ID clickable.
So, my HTML has to look like:Code:
<input type = "submit" value="sqlrs("ID")">
How do I construct that in ASP since, using " in strings ends it and same with Response.write methods.
is there any way to indent HTML code inside a simple textarea?
View Replies View Relatedim using some wysiwug editor called htmlarea to add some articles to the DB through textarea (something like that we use to add threads) but when the html code contains a link for example it gives error coz of the the ("") in the html tags .. it's something like this Code:
View Replies View Related,I need to call a URL, receive the raw html in my VB Script code and parse it
to retrieve a value from a cgi generated web page on a remote Apache Web
server.
What is the best method to accomplish this in ASP 1.0?
I have a page which has a header finding out some variables from request.querystring and other places. Later on in the page in what is normal HTML code I want to use the variable but am having to do this:
<%
response.write "<A Href='" & shopurl & "' target='_blank'>Shop</A>"
%>
is there any way i can just have the line with the variable being interpreted without having to go into a code protect and write the line out with code. Something like this:
<A Href=%shopurl% target="_blank">Shop</A>
How is it you should format your ASP code to that when viewing the resulting
HTML text from the browsers "view code" it looks nice with line breaks?
I have a e-mail function in serverside VB, how would i put html code in the body variable so when email is recieved it looks like html page in the body. right now it just shows up as text in the body of message,
<html><head></head><body><table><tr><td>one</td><td>two</td><td>three</td>
<td>four</td></tr></table></body></html>
There must be a way because i get emails with html ?
inserting dynamic page code in .html page? i.e. i would like to insert a code which will display links. where my homepage link extension is .html. if it is .asp it would have been very easy. and also i would have worked fine. but now the problem is the homepage index file extension is .html.
so if i insert the code it is not displaying the links. i tried inserting the code in a separate file and saved as file.inc and gave the link from home page <!--#include file="file.inc"--> but still the link is not showing and not working.
i have a database and the asp file. my database will have one table, a user table, with various fields like username, password, name...age.. all i need is the html code to make a simple form such as
Welcome to the add user page:
PLease enter a username (input box)
Please enter an email address (input box)
finally a submit button.
i then want the variables to run a 'signup.asp' file which i have, and be placed into a database.
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies View RelatedI have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
I'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
i need to include the html inside another html, though it might appear simple, the catch is this, my one html is in one server and my another html is in another server.I cannot read the html and stream it as it has images and their path gets changed when i do that.
More over i donot have any control over the html which i am going to include all i have is a url http:abcxx.htm whose content i want to show in another asp page. The technology is ASP (vbscript and javascript).
Our graphic designer has just finished redeveloping our website. On the
site, we use SSL to secure the area where a user enters their personal
information to order items from us. (we do not do many transactions - maybe
1 per day...) We are a log home mfg company so they would only order plan
books, maybe a video etc...
When the user clicks "Submit Order", we want to encrypt each data item
(because of new legislation governing customer personal info etc...) and
write a record to an access db. From here it will be imported into our
Customer DB leads database...
I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in
many ways...
Does someone have a good ASP script for encrypting data? And, if so, is it
fairly strong encryption?
Also, is there any trick to writing an "insert" SQL script in ASP or is it
exactly the same as I would do in VB or Access? Maybe someone has an
"insert" script handy they could pass along including the command to
actually execute it?
i have got a data base which contain more than one tables
one for student one for teacher and one for books
i make a fourm to read the input from the user Code:
Code:
mySQL="INSERT INTO products (sku, youtube, description, details) VALUES ('" &pSku& "','" &pYoutube& "','" &pDescription& "','" & pDetails& "')"
call updateDatabase(mySQL, rstemp, "insert1")
that's shortly the way i'm inserting new records.
using mysql and asp functions.
The prob is that inserting only one record every time.
if i got data for 3 records how can i make it at once
to add 3 new records in some given order into the db
What is the best way to see if a record has inserted correctly into the datase in ASP?
Also, how to tell the user what the error is.
I am inserting like this with the ADO command object:
Dim sInsert, objCmd
set objCmd = Server.CreateObject("ADODB.Command")
sInsert = "sp_ADS_Insert_Driver_General_Data "
on error resume next
With objCmd
.ActiveConnection = oConnEnergy
.CommandText = sInsert
.CommandType = adCmdStoredProc
.Execute , , adExecuteNoRecords
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.
Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
When the following code runs it produces no errors but doesn't give proper results:
sql = "INSERT INTO TableName (Line1, Line2, Line3, Line4) VALUES ('" & lines(0) & "', '" & lines(1) & "', '" & lines(2) & "', '" & lines(3) & "')"
Response.Write(sql)
SET RS = Conn.Execute(sql)
lines() contains nothing but strings and is never empty.
The Response.Write(sql) shows the proper values going into the proper locations.
However, only Lines(0) actually populates the table. Line2, Line3, and Line4 never receive any values despite the SQL showing the proper syntax.
i have this insert statement that is giving me trouble, the problem is with expiration_date field the error i'm getting is:
Syntax error in date in query expression '##'.Code:
SQL_Insert = "Insert INTO TableName(ColumnX, ColumnY, ColumnZ, ColumnZZ, ColumnXX, ColunmYY, Expiration_Date) values ('" & _
ColumnX& "', '" & ColumnY & "', '" & ColumnZ & "', '" & ColumnZZ & "', '" & ColumnXX& "', '" & ColunmYY & "', #" & Expiration_Date & "#)"