XMl Tree Using Database Query
I am trying to create a xml tree using sql server 2000 and asp 3.0 i am looking for a code for it .
View Replies
ADVERTISEMENT
SQL Database Query
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work
Query Database Table
I have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies View RelatedPerforming Database Query
i'm confused about perfoming insert, update and delete operations in a database. I know that to only use SELECT statement you would create a recordset and use it but for all other you need to use Command or Connection Object.
I'm confused because in some books/articles they create and open a connection and perform insert/update using that. in others they say to use Command object instead. which one do u use when?, why?.
Query MySQL Database Using ASP.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
Query Database, Column 'ID'
The following code works fine doing a query in the db and return the data with the link ...mes.asp?month=X (where X is a month and mes.asp is the name of the file that this code is in...)
I have a ID column in the database and would like to know how to catch data from ID.. i have tried without success, dunno why but the code comes with a error in the line "rs.Open sqlStr, data_source"... Code:
Updating Database Query
i have this shopping cart i'm working on and it keeps giving me this error and the original code is on the bottom. Code:
View Replies View RelatedDisplaying Database Query.
I am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
Ajax Database Query
im using ajax to load different pages of code into containers on one page.. i have checked my code.. and things SEEM to be named correctly.. and i know the db is workin because it populates the drop downs properly.
so if you could do this form me.. choose the first radio.. 'london postcode' and proceed from there.. when you click the get quote that error comes up.
ASP Database Query Doubt
I need to know the syntax to achieve the following.
<%
Dim Year_Value_Num = 1999
Year_Value_Num = 1999
rsUsage.Open "Select AuthorLastName,ReceptorName,Year from TblAuthorInfo where Year > Year_Value_Num ", strConn
%>
The database access works fine otherwise But if i attempt the above code i get the error.
Cancelling Long Database Query
I don't excactly know whether this is an ASP, webserver or SQL-Server problem:
I have an ASP with a search form. By clicking the submit button it redirects to my result.asp page which initiates a database query that takes pretty long (up to 4 minutes).
Now if I push the cancel button in my browser because it takes too long and want to open another ASP page in that browser window I just get the "page loading" bar until, it seems, the query I initiated before has finished, and then shows up the wished page.
What I think is, that the webserver is waiting for the the command:
set rs = db.Execute(sql_search_string)
to be finished by the SQL-server and does'nt respond to other page requests (but only in the same browser window) until the recordset is filled with the information from the SQL-server. Code:
Using The Like Operation To Query Access Database
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
View Replies View RelatedQuery Database, Display As Hyperlink
I am using ASP with VBScript. I want to query an access database username
field, and display the output as a hyperlink on an a webpage.The webpage
will display all records. I then need to be able to select a given
record(hyperlink), and display all of the fields for that record on another
webpage so I can execute some code against it.
Can anyone point me to some sample code so I can get an idea of how to
accomplis this?
Search MySQL Database Query
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
Asp Database Pull From A Query Not A Table?
it possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?
View Replies View RelatedASP Search Using Query In Access Database
I have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias.
NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in...
Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
Select Query Database Error
I have created a query and everytime I try to run it I get this error:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162
This is the query: Code:
Fill Table With Database Query
I want to retrieve a large number of rows from my database (Select SomeColumns from myDatabase)and then to fill a table with the retrieved data. What can i do?
View Replies View RelatedSending A Query To A Database On A Link
I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
Can I Use A Query Stored In An MS Access Database From An ASP Page?
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
Updating A Database :: Operation Must Use An Updateable Query
I have a form and when you click submit it is supposed to open up the database add the stuff from the form to the database and close the database. The problem is i am getting an error that says this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/getInfo.asp, line 35
this is line 35:
objRS.Update
Retrieving Data From Database - Query String?
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
Decision Tree Using ASP
im required to develop a simple expert system, like an animal guessing game where the questions, answers and rules are stored in the database. But the problem is i dont know what is needed to design the database and how it relates to each and other.
View Replies View RelatedMenu Tree
is it possible to have an asp menu tree? or possible to swap an inc though a link click
View Replies View RelatedTree View
I actually want tree view which can dynamically display
all the child nodes(undifinte) dynamically.
Need A Tree Script
I really need a Classic ASP based Tree Script in which we can add,edit,delete parent,child or sub-child name from the tree..
View Replies View RelatedFamily Tree
if i want to make or build a Family Tree ,, which programming language i can use to do it ? and put in web site ..
View Replies View RelatedTree View In ASP
how can i built a tree view component in asp then tree view node values are get from data base. if any one know pls explain, how it possible?
View Replies View RelatedDatabase View Form Populate (query Issue)
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View Replies View RelatedCreating A Directory Tree With ASP
I'm looking for script where I can enter the location of a folder and a directory tree(folding list) is displayed containing all subfolders and files. I want to select a file from this directory tree and delete it. I can't seem to find what I want on the net.Can someone shed some light, please?
View Replies View RelatedASP Based Tree Script
I really need a Classic ASP based Tree Script in which we can add,edit,delete parent,child or sub-child name from the tree
View Replies View RelatedAny Samples On Tree Manipulation
Looking for sample code in asp or asp.net which uses two trees the left hand tree having all levels and leaf nodes and the right hand tree containing only levels.
Buttons in the middle to "move" levels or nodes around, add new levels, rename levels or delete levels.
Everything working off a table with parent/child type relationship.
Folder Tree Security
I'm creating a tree menu that uses FSO to read folders, subfolders and
files. I'd like for each folder to have capabilty of being either Level
1,2,3,4 or 5 security. The 5 Levels are my security levels with 5 being
Admin.
I'm looking for any advice on how to go about this. I was thinking of
creating a hidden text file within each folder and storing the folders
security level in it, then let asp read the text file as it builds my tree
and display the appropriate folder icon representing Level 1,2,3,4 or 5
security.
Anyone go a better idea? Perhaps an XML tree