I Am Having Trouble With A Database Quary Involving A Variable.

I am having trouble with a database quary involving a variable.

The following code does not work.

Set objConn1 = Server.CreateObject("ADODB.Connection")

objConn1.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/Training2004.mdb")

Set Question = objConn1.Execute("SELECT * FROM '" & Module & "' ORDER BY ID")

The variable Module causes errors. However, if ireplace that line with the bellow line the code works.

Set Question = objConn1.Execute("SELECT * FROM Safty ORDER BY ID")

For some reasion i have to type in Safty, i can't enter it with the Module variable even though it contains Safty as its value.

Any ideas how i could get the quary to work with the Module variable becasue i don't always want to access the Safty database?

View Replies


ADVERTISEMENT

Dataset Data To Variable Trouble

i need to use the returned value from a database in my code. it is not to be displayed on a aspx page. I can connect to a database and return the one value i want using SQL SELECT.....FROM.....WHERE...... condition. this is returned as a dataset.

Is there anyway i can return this value from the database as its real value as there is only 1 record? If not how can i retrieve this 1 value and use it in my code? Do i need to loop through the dataset and return it as a string? I want to retrieve 4 values from 4 difference database tables and them up in my code and then return the total value to a different database table.

View Replies View Related

Trouble Inserting A New Row Into Database

I am having trouble with someone else's code that worked when it was used last, but now it's not. I am new to ASP programming so I not too sure what's happening. Code:

View Replies View Related

Session Variable To Database

Does anyone know how to update a session variable to the database.

I can get the session variable to appear on the screen but I can't seem to get it to be send to the database using a form and hidden fields. Does anyone know how to go about this. What do I need to do to maken it work. I'm using ASP/ VBScript & an access database.

View Replies View Related

Ref Database Field Name With Variable

I have an asp page that has a function that connects to an Access database.
I am using Javascript. Is there any way to reference the field name in the
database through a variable in a sql statement? Code:

View Replies View Related

Updating Database With Variable

Is there any way you can put a variable in the values in an update command?

If oRS("n4") <> 0 then
Response.Write ("<tr>")
Response.Write ("<td>4</td>")
Dim qn4
qn4 = oRS("n4")*intQuantity
strsql = "INSERT INTO report (q1) VALUES (qn4)"
Set oRS2 = oConn.Execute(strSQL)
Response.Write ("<td>Meter box, meter and test block</td>")
Response.Write "<td>" & oRS("n4")*intQuantity & "</td></tr>"
end If

View Replies View Related

Variable Arrays From Database For Select And Span

I am working on a site with MS Access and ASP that needs to have data selected from a listbox, populate several span fields. I can do it with JavaScript but the array data is hard coded, I want the data brought in dynamically from an Access database. Here is my JavaScript code:

View Replies View Related

XML Trouble

I was wondering If there is any way to grab just the viewable text of a webpage
using xml. Not the html, just what the user can see.

View Replies View Related

IIS Trouble

I am having trouble with installing IIS, I tried to do it in my control panel, but it wants the disk, I don't have the disk because my computer came with Windows XP Pro 2002 Service pack 2.

so I went to the microsoft website and downloaded the free download of IIS6. Then when I go to my control panel and Administrative tools it is in there and when I click on it, there is no computer name available.

View Replies View Related

Iframe Trouble

I have a sign-in box that is an IFrame, with a form target of "_top", and
the current (parent) page URL as a hidden field.

If sign-in in successful, there is a response.redirect to the page URL,
having set the session variable LoggedInOK=true.

However, if the sign in is not OK, I want the IFrame to be the target, (i.e.
_self, not _top) to display the error.

Is there a way for ASP to control whether it redirects to _top or _self, as
setting the form target in the Login page requires "pre-knowledge" of
whether it will be successful.

View Replies View Related

Trouble To Migrate To IIS 6

I am moving a ASP website to a new Window 2003 server with
IIS 6, but an error occur for the metadata declaration in
my global.asa

<!--METADATA TYPE="TypeLib" NAME="Microsoft Scripting
Runtime" UUID="{420B2830-E718-11CF-893D-00A0C9054228}"
VERSION="1.0"-->

the error message is

Active Server Pages error 'ASP 0223'

TypeLib Not Found

/LM/W3SVC/1/Root/myweb/global.asa, line 4

METADATA tag contains a Type Library specification that
does not match any Registry entry.

View Replies View Related

Trouble W/ Checkboxes

I'm writing an Online registration system for my friends new business.
I'm trying to incorporate checkboxes so when a person checks on 3 or 4 checkboxes and hits the Submit button I can
pass the information of what they checked_on to a new page.
When I get to the new page I would like to update a database, based on what they checked_on on the previous page.
I'm not sure how to do this.
I'm not sure how to pass the information.

View Replies View Related

Recordset Trouble

Ive got a script here that searches using info from querystrings. it's just a snippet from the other lot. Code:

View Replies View Related

Cpshost.dll Trouble

using PWS on test machine (NT4 workstation SP6) and everything was fine but cpshost.dll was used in the website we're maintaining, so I idiotically installed it from a Visual J++ disc. now the website works fine but when i navigate to 127.0.0.1 nothings happens. I've checked directory browsing is enabled but still nothing happens!

I'm aware that cpshost.dll was never meant to be used on NT workstations but as I said before the upload functionality works fine, it just seems to have screwed the directory browsing up - and also the code document.referrer equals nothing.

View Replies View Related

Trouble With Rss2html.asp

I am primarily a front-end designer and not familiar with ASP beyond
breaking up pages into include files. Recently, one of my freelance
clients wanted to display an RSS feed from his blog on his site. I did
some research and found the rss2html.asp script. I chose this over a
javascript solution because those scripts apparently don't affect
search engine rankings.

I implemented the script and it was running fine until about a month
ago, when the site and sometimes the server running it started to
crash. The ISP and the blog company the RSS feed originates from blame
the script. Bytescout, who wrote the script, says that it's probably
the feed that's causing the problem. The RDF version of the feed
validates as RSS, but the ATOM one has specs that are too new for the
validator to parse correctly. Code:

View Replies View Related

Connection Trouble

I keep having trouble connecting to my database I am running windows xp pro and Access 2000

Error Type:
Provider (0x80004005)
Unspecified error
/test.asp, line 60

It keeps bringing up the above error message sometimes it works fine then other times it dosen't has anyone had any similar problems.

View Replies View Related

Interesting Trouble

i'm working on access db the problem is when i enter date in d/m/y format it wrote db m/d/y format but this happens only with small numbers i.e if date 04/09/2002 it become 09/04/2002 in db but if it is 24/09/2002 there is no problem.

View Replies View Related

Function Trouble

I've narrowed down my error to one particular function. It looks as if the function may not be receiving the variable that is passed to it.

The error message is:

error '80020009'
results.asp, line 21

Line 21 is: Code:

View Replies View Related

ASP XML SelectSingleNode Trouble

I'm having some trouble parsing an XML document I'm getting from my company's bank in response to a XML document I'm sending. Both docs are transferring fine, and in fact if the transaction in the document I send is accepted (valid credit card), everything parses perfectly.

The prob is when the transaction is not accepted by the bank server (invalid credit card), and the document that's returned to me has different tags. Code:

View Replies View Related

Trouble With Session In Global.asa

I have started session("visitorID") in global.asa in order
to keep track of how many users are on our site at any
given time, trouble is I can't seem to call the session
while on another page.

As I am relatively new to asp I'll post both the setting
of the session and the call to it on the other page below Code:

View Replies View Related

Trouble Passing A URL Through From An Access DB

I am attempting to pull a value from my database and insert it into an ahref tag.

However I keep getting the following error..

Microsoft VBScript runtime error '800a01a8'
Object required: ''

Below is the code I am trying to make work..

<th width="25%" height="34" scope="col"><div align="center"><a href="cat_detail.asp?<%=(rsLastCatalogUrl.Fields.Item("txtCatalogUrl").Value)%>"><img src="../../../images/layout/buttons/button_backtocatalog_off.gif" width="100" height="30" border="0" /></a></div></th>

This is the SQL statement I am executing to pull the field, which is meant to be the last record inserted into the shopping cart by a particular individual. Code:

View Replies View Related

File Uploader Trouble

I am having trouble with my file uploader. I do not program a lot of .asp and its a bit confusing. As well, I just took over the development on this webpage so the code is not my own.

The file uploader worked before but now that I have the webpage put to a test site it doesn't. Would this be a reason why I cannot upload? i am also having trouble accessing the database, which makes it even harder for me to see whats hapening to the file.

When I upload it says that it uploaded successfully but when I see the webpage the photo isn't there. Would you like to see the code for the uploader?

View Replies View Related

Trouble Deleting Records Via SQL

I have this list of records (from an Access DB) and would like to use check boxes to delete 1 or many records. I think there is something wrong with the SQL though, cause the records are not deleting when the form is submited. Code:

View Replies View Related

Having Trouble Breaking Loop

I'm trying to break this loop for 4 different contacts to be inserted into the system.

For new inspections I want to be able to search the DB for the Owner, User, Contractor, and Cert_Recipient for new boilers the certificate will be mailed to the contractor which will be the Cert_recipient first.

then for annual inspections I want to be able to search for Owner, user, and Cert_Recipient for annual inspections I will have to search the DB for either the owner or User as the Cert_Recipient

For some apparent reason I can't stop the search, it keeps going thru the loop. I must be missing something. Code:

View Replies View Related

Dynamic SQL Query Trouble

ive been trying this for ages and various ways have all failed! please can some one show me the correct way to achive what i am after!

the ASP code looks like this: PHP Code:

View Replies View Related

Trouble Reading From TextArea In ASP

I am trying to put together a little ASP page that lets you paste a block of HTML in a text area then, at the click of a button, convert it to Javascript document.write statements (including any concatenation, switching of single and double quotes). A really useful tool! Code:

View Replies View Related

Array Trouble In IE & Firefox

I recently started testing my work in Firefox and noticed that when I am looping through an array where I say for example: Code:

for i=0 to ubound(myarray)-1

--work with the array values here--

next

I get the following results:
Firefox works with all items in the array EXCEPT the last one
IE works with the entire array.

View Replies View Related

Trouble Calling Functions

I'm having a little bit of trouble.I have created a form where I accept peoples information.at the bottom of the form I have a submit button that I want to have execute a function or procedure that I created in VB script.the problem I have is that it execute the function even before the client has clicked on Submit.

View Replies View Related

Bug/Issue/Trouble Ticket

anyone knows of a free Bug/Issue/Trouble-ticket tracking ASP application.

View Replies View Related

Trouble With URL To Microsoft Templates

I want a URL links to .dot and .xlt files on my websites. But when users try
to save them it triggers built in template functionallity to save it as .doc
or .xls instead.

How can I publish MS templates and make sure the users get the .dot files
instead of doc files?

View Replies View Related

Trouble Installing (testing Asp)

anyways, after i installed IIS (i'm running XP SP2) everything seemed to go good, until i tested ASP, i get a 500 error / page cannot be displayed.

but this is the real error
-2147467259 (0x80004005)

i have no idea what this means, and i did a bit of a search on google on this, but i didn't find anything helpful - so i ran a search for asp forums and this came up - so here i am.

in case you want to know, my web server is running (i CAN see html files via the localhost url) but asp just won't go (i'm trying to view the default asp file) and i have no idea what's wrong (i DID restart my PC, and all services that might be related to anything internet are turned ON)

View Replies View Related

IIS5 To 6 Migration Trouble

We are poised to migrate about 600 ASP sites from a single IIS5 server to a new pair of IIS6 servers. However, it appears that all files with includes like:

<!-- #include virtual="../../includes/file.asp" -->
will not work on IIS 6, it returns ASP 0126, include file not found.

We have enabled parent paths, but I can't find any documentation that suggests that IIS 6 handles include directives differently than IIS 5. Has this in fact changed in IIS 6? We are trying to avoid a huge and messy "search and replace embedded text" exercise.

View Replies View Related

Trouble Populating SQL RecordSet

I'm trying to develop an SQL request that will give me back the full contents of the table 'bbs', appending two COUNT()'s from the table 'topic' to the end of the recordset.

The condition of the COUNT()'s should be that bbs.forumnum = topic.forumNum. Therefore if row 1 of 'bbs' has a forumNum of 1, then the append data should COUNT how many rows in 'topic' also have a forumNum of 1. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved