Reading Database Value
I have a check box on my edit ASP page. I have a field called MyCheckBox with a data type of bit in an MS SQL database. If the value is 0 in the database then the checkbox will not be checked, if the value is 1 then a check should appear in the checkbox. How do I do this?
View Replies
ADVERTISEMENT
I have written some coding to insert customer details which writes to the database (table name is called cars). On my website if an existing customer enters their car reg then i wish for the rest of the fields to be filled in automatically by reading it from the database, has anybody got any ideas on what coding i should use for this and how i would go about doing this? My coding for insert is as follows: ....
View Replies
View Related
We have a site with ms access backend, hosted remotely with a hosting company. Can we read the tables in the site database within our office desktop app either using web services or some other way? Are there any links to how this can be accomplished?
View Replies
View Related
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.
View Replies
View Related
I am trying to run one of my first ever asp scripts. It is a form I copied from the
w3schools website along with its ASp script, demo_add.asp, both which i have
modified very slightly(variable names for my own database etc).
However, "No update permissions" appears in my browser when i run the script -
this means that there is an error. The problem is i dont what the error is!
The only thing I can think of at the moment is maybe my database location. I
am using IIS are all my files are mapped to a virtual directory within IIS. Should
the path in my HTML file below be to the harddrive location or its location within
the virtual directory? Im assuming it is the hard drive location. Code:
View Replies
View Related
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.
View Replies
View Related
anyone know a simple to use RSS/XML feed getter so i can add external news
to my site?
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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 Related
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 ...
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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!
View Replies
View Related
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 Related
I 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 Related
How 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.
View Replies
View Related
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:
View Replies
View Related
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 Related
i 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
View Replies
View Related
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)
View Replies
View Related
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 Related
Is 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 Related
Does 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?
View Replies
View Related
I could post the various bits of code that I've tried to use to get this to work... but it'd be kind of pointless as I haven't gotten very far with either of them (I've run across encoding problems, and problems where it works on the local machine, but not through ASP. I've tried using an XLT doc and without).
View Replies
View Related
if it is possible to store the URL of a browser window as a variable? For example:
var loc = window.location.href
in JavaScript will store the contents of the address bar as the variable loc.
View Replies
View Related
I've been searching the net for a good example of how to read nodes from a XML file using ASP classic (VBScript), but I couldn't find any. I'll appreciate any explanation on how to handle the nodes, and how is it different from RecordSets. Code snippets of already made XML-reading scripts will be welcomed. I'm attending to use Microsoft's parser - XML DOM.
View Replies
View Related
I am trying to read in an XML file I don't know the node/structure,so I basically just want to load in the file and then print out the entire file on the page through Response.Writes. how do I loop over the nodes if I don't know the names?
View Replies
View Related
I have been assigned the task fo displaying the directory contents of another server on our intranet. I can display contents of directories on the local machine but how do I tell the File System Object to look at a directory on another server/ machine on the network. Is there a virtual path or actual path way of doing it?
View Replies
View Related
I have a web page that waits for a users to enter a number and press ENTER simulating the click on the submit button. The problem is when the page reloads the cursor is not in the textfield on the form.
There will be no mouse hooked up to this PC so I need to be able to have the users type a number 1-5 and press enter and it will go to another page. Is there a way to monitor the keyboard and wait for 1-5 to be press and execute a response.redirect or something of the sort?
View Replies
View Related
Is there a way to read a block of HTML from an ASP page. i.e.
<%
Dim someString
someString = SomeFunction(http://www.test.htm)
%>
View Replies
View Related