I am trying to access 2 tables on the same ASP page. The problem i am having is that cos there is only 1 Select statement 1 cannot read another table. I think you can do this. I have added my code if its any help.
View RepliesI'm trying to read in a specific cell, and am having problems. I have a table of contact information, in which each contact has a user_id that defines where there information is.
At login it stores their user_id into a temp variable that is used to define where to find the information for each contact. I can read in contact information for the first row but anything below that I cant seem to grasp.
Im not sure how to tell it to match that temp variable with their user_id and read in the user_name. the temp variable is user_ID. Code:
Is there any way of using ASP to read the names of all the tables within my database?
View Replies View RelatedI am writing a asp code that can take values from user in html form, process it and display it back in some kind of report.
the problem i m encountering is that I have a field which is numeric and I want to compare it with tax-table like for example:
if value in field is 6 then I have to look into table in pdf file (tax table form 1040ez) to compare it with the value and then write it to appropriate field. the problem i m facing is that it's in pdf and also the data is so large (4 pages in pdf) that i don;t know how tocompare it .....
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Could somebody please help me out with this? I have been researching it all day and can't figure it out.
All I want to do is put some info from this XML file (staff.xml):
<staff>
<employee id="1">
<name>John</name>
<job>Janitor</job>
</employee>
<employee id="2">
<name>Mary</name>
<job>Accountant</job>
</employee>
</staff>
into an ASP page. I already started an ASP page:
<html>
<head></head>
<body>
<%
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load("staff.xml")
response.write("<p>")
'I NEED TO INSERT THE FIRST PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE FIRST PERSON'S JOB HERE
response.write("</p>")
response.write("<p>")
'I NEED TO INSERT THE SECOND PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE SECOND PERSON'S JOB HERE
response.write("</p>")
%>
</body>
</html>
That's all I have in the ASP page because I am having trouble with it. Could somebody please help with it real quick? I'm sure it's very simple, but I am having trouble learning the XMLDOM thingy.
anyone know a simple to use RSS/XML feed getter so i can add external news
to my site?
I got a little piece of ASP code to read from a remote url, which is expected to be an xml, like a RSS feed, and echo the content out to be processed by downstream xml processor. The code is like this:
<%response.ContentType="text/xml"%><%
Response.Buffer = false
Dim objXMLHTTP, xml, url, text
Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
url = Request.QueryString("url")
xml.Open "GET", url, false
xml.Send
text = xml.ResponseText
Response.write(text)
Set xml = Nothing
%>
Using firefox, I get the request.responseXML object back from the code above, works fine. But in IE, the request.responseXML is returned null, but request.responseText did show the entire xml file.
My question is how should I make change to the above code to let IE honor the request.responseXML object? I gues the xml is somewhat ill formatted and IE can not recognize it as an xml.
I have an ASP classic site that needs to add the option of reading an XML file send back from another web site and parsing it into a multi-column HTML table. The server is Windows Server 2003. Can anyone direct me to where I might find more info on this?
View Replies View RelatedI have just created a cd based demo web with FP2000 under XP pro. The disc plays back fine on the XP machine, but when tried on a WIN 98 machine it doesnt play, and I get " G: is not accessible Device not ready" when I try to read it in Win Explorer. The disc is a 48x speed 700mb CD-R. Is it too fast for the older machine?
View Replies View RelatedHello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
am trying to create a login page for the first time, I have a login page, validate login page and if the password is correct it takes me to the first page.
I have customized this code someone else created,but what I have a problem with now is I need to log who submitted that data and that is why I am trying to read UserName cookie so I can later match that data.
This is the error I get which is telling me that it is reading the cookie since this is the UserName I am logging in with
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'boxhill'.
but I can't see what is wrong, and there is not much out there for this kind of error.
So I can login successfully but now i need to read and dispaly that cookie and then insert the value of the cookie but,but don't worry about that now, just trying to give you the full picture.
So this is the code for reading the cookie ...
i was wondering if any one could give me some info on how to get mp3 ID3 tags in ASP?
I've seen it done, but don't really have any idea how,
just looking for info like song lenth, bitrate, and so on.
I have a function in ASP and I want to read a DIV tag. Any ideas? I know
the syntax but when I apply it, doesn't work.
What is a good method to read a file that is hosted on another server. I really want to echo the code found between a "<PRE>" and "</PRE>" tag found in the source of an externally hosted file. How should I go about this? I am somewhat new to ASP, but am confident there is a way.
View Replies View RelatedI have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.
I've got a league standings file that gets uploaded as an xls file. To display the contents, I'm not sure what the most efficient way is:
1.) Import the xls file into a database every time the file is updated
2.) Read the contents of the xls file using OpenDataSource or OpenRow Set
3.) Something I haven't thought of yet!
I've to got a login script, but in the middle of the verification script, I'd like once the vify has been ok'd to look for a sql file, that has insertion data in it, once the file has been found the asp code must read and carry out the sql command (insert the data in the access db), once done the sql file gets deleted. Code:
View Replies View RelatedI have to upload one excel file. In that excel file I need to check the availability of data in particular cells and also the worksheet name. If the data is not available at particular cell, say for eg: $F1, an error should be thrown to user saying that the data is manadatory. How to do that? How to read the particular cell in ASP? If anybody knows the code, please send the same.
View Replies View RelatedHow do you read a variable that you've declared on one page
For example
I've declared
dim x
x=23
then i goto the next page. I can't seem to access it.
How do I get access to that variable that has been defined in the previous page.
Im having a bit of trouble with taking a csv file and sperating each row with a "," because we all know that csv's are serpated by cammas, my problem is the rows are getting messy because say I have for the first Collum "Toy, Really fast", it will seperate the collum name because of the , Is there any way I can remove these or whats the best way.
Heres my code right now: Code:
I am developing a web page, in that i have to get user's photo from user and insert it in to database. how to upload this photo from local drive to my server
View Replies View Relatedi dont know that is this right to put the question in this forum or in html forum.
anyways, the question is how can we read/find the value of title tag of html page using asp or any scripting langauge.if any one has idea, please do share
I cannot figure this out for the life of me. All the tutorials I've gone though give code (and from what it looks like, wrong code) with absolutely no explanation?
My ultimate end is to read the xls file into a mysql database.. but I need some method, way or idea of actually doing this. Presently the data is an a .mdb database (so I can save it to different formats) but I cannot use the .mdb itself to upload the info (server disallows reading and writing from .mdb).
I've looked all over and there is no detailed method of doing this (all I really need is just the basic code for connecting to a .xls sheet (excel sheet) and then reading the data from a line and displaying it on the screen (there is no present tutorial that explains that, least that I can find)
I need to read from a weekly email and extract the contents of that email then convert them into HTML. I do not have control over the email that is being sent but do have control over the email account the notice is sent to? So to explain everything I need to take this email and post it onto a site, I can do it manually everytime but am looking for a way to let the script do it?
View Replies View RelatedIs it possible to display a doc file within an ASP page and have it show the header and footer of the page?For example,in ColdFusion you can use cfcontent to display doc files, however any html on the containing page doesn't show.I was hoping that with ASP, it would show the HTML of the page that reads the doc file.
View Replies View RelatedDoes anyone have any experience of using barcode reading software with ASP applications?
I have an ASP-based application where Serial No's are entered manually. The users want to move across to a barcoding system so Serial No's can be picked-up automatically.
I have no experience in this area... Are there appropriate tools out there?Can anyone give me a few pointers?