Show Db Table Name
where in i could show in a dropdown the database table name as i would like the whole databse be searched according to a specific table?
View Replies
ADVERTISEMENT
Show/hide Table Using Asp
Is there a way to hide a table using asp?
I would like to 6 radio buttons and if one is selected then a table with further contant/ checkboxes relates to that particular checkbox become visible.
ie. radio button will display table 1 etc.
the table should appear under the selected radio button.
Show Table If Field X Is YES
I have problem to print out a table data only the data witch have the field paid yes..
I used
pi.Open "select * from invoicees where paid like '"&yes&"', "DSN=anitel"
What's wrong
Show Layer Of The Table
I created a link click counter. Now I want to read and show to the public one layer of the table, with one specific number. How do I make to read only one specific "cluster" of the table of the DB? My script already records new entries, the problem is reading a specific cluster. I am using a Acess DB. Simple connection with the following connection code:
<code><%
set conn = createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("contador_clicks.mdb")
set rs = conn.execute("SELECT * FROM clicks ORDER By id DESC")
do while not rs.eof
%>
......
</code>
How To Transfer Records From One Table Of A Database To Another Table In Another Data
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 ....
How To Open A Recordset For A Table Has Space In The Table NAME?
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)?
Table Inside A Table Update To DB
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:
Copying From Table 1 Inserting In Table 2
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 RelatedBookmarking A Position In A Table <table>
Have 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.
How To Get Data From A Table Into A Table Form?
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 RelatedBest Method Of Updating Table From 2nd Table
I 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.
Record Set For Id From Table 1 To Table 2
Hello 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:
If Then Show
is there a tutorial around anywhere that tells you how to change images on the page when a user selects from a select box
View Replies View RelatedDon't Show Everything
I have a database of songs listed as Title, Artist,Description, DiscNo and TrackNo with a seperate record in that format for each song.What I would like to do is search through them for the Description, show only the disc numbers in the results.
This I can do easily. Where I am lost is that I only want each individual disc number to show once. If I moveNext through the recordset, it shows the disc number 15 times per disc. Is there a filter I can add to limit this display?
Don't Want This To Show
Is there any way to input .asp code so that a specific element isn't show on a page? example: I don't want a menu on a specific product page, but I want it on all the others. Is there any code to input into a site wide includes file to implement this?
View Replies View RelatedShow A Progress Bar
I have a ASP application which let user to download their reports in pdf format. I would like to show a progress bar, or change the mouse cursor to a hourglass while the user is waiting for the file. How to acomplish this? In the asp code, I use response.BinaryWrite to create the pdf file directly to the browser. How to detect when the file is ready?
View Replies View RelatedShow Recordsets
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
Show Full Value
I have a query that displays values from a db.
The problem is that the value displays like this:
R 6.5
instead of like this:
R 6.50
How would I get it to show the full value?
Show The USERNAME
ok, well what I have been having some trouble with is to show the person character name like this:
Welcome, 'Username' <-- Here I want it to show the persons username from the database.
How Can I Have A % Or $ Show Up In An E-mail?
I am using a Cdonts e-mail script that e-mails the results of a form to my address. It currently displays the data like:
Amount: 12.00
Percent: 2.00
I need it to say:
Amount: $12.00
Percent: 2.00%
How can I get the $ and % symbols to be included in the e-mail template without getting a 500 error?
Here is what I have:
Body = Body & vbcrlf & "Amount: " & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")
I've tried a few diffrent ways but here is one example:
Body = Body & vbcrlf & "Amount: $" & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")%
I've tried using / before the symbols and "" but everything I've tried keeps coming up with a 500 error. How can I add these symbols to my template so they will show up in the e-mail?
Show First 100 Chars
I know we have this thread somewhere, but I can't seem
to find it now
I want to show the first 100 chars of a string, but
I don't want a word to be cut in half at the end, it must
show the whole word then and go a bit beyond 100 chars.
Show Array
How do you print out all of the contents of an array if all you know is the array name?
FOr example, I am looking at pre existing code that looks like this:Code:
scartItem2 = session("cartItem")
arrCart2 = session("MyCart")
For Z = 0 to scartItem2
cartfields2="&Email=YES" & "&processed" & z & "=" & arrCart2(cProductid,z) & "&quantity=" & arrCart2(cQuantity,z)
What I need to find out is if there are ANY other elements other than cProductid AND cQuantity in this array and what their names would be so I can add them to the code.
I know that I could print out the values of the above by simply doing this:
response.write(cartfields2)
But how do I find out if there's a cFeature or any other element?
Web Browser Does Not Show
i have very strange error.i can not see some of the asp pages on my browser. when i
look from view source, all the source is there but browser does not show anything, just an empty page.
Show The Content
im looking to find out how can i make, when the pointer is over a link or picture without clickin on the link an small textbox(something like that) open and show the content of that link. for example in this forum when you go over a thread you can see the content.
View Replies View RelatedShow Most Current PDF
I have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
JScript Show
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
Show To Currency
I want to show the currency like that xxx.00. In my database, i already set the type of column which i want to show to currency. However, the currency can no be shown as my expect. It only show like that XXX..
View Replies View RelatedShow The Visitor's IP
In one of my ASP page, I want to show the visitor's IP. Who can I do that?
View Replies View RelatedShow Popup
how to show popup windows (html format) and the size is depending on the size of image?
View Replies View RelatedShow The Link
i m displaying only 4 lines of my main news..and after that there is one link more...if user click on this link then the detail of this news will display....but problem is i want to show the rest of content of this news at same place..i maen to say after clicking more it will display my main news content in place of 4 line and more link Code:
View Replies View RelatedShow Message Box
I have some problems with how to show error message. Now I have two asp pages such as page "A" and page "B" and When I click a button on page "A" then the process will check conditions from page "B" ,so if there're some errors it will redirect to page "A" and show error message box.
I would like to know that how to show the message box?
Asp Changes Do Not Show On Clustered IIS 5.0
I have clustered IIS 5.0. It is working on a fail-over clustered model (Active-Passive), with one node as a preferred owner and the other only as a failover. I make the changes to IIS from one node, and then synchronize it with the other node.
All of the data is stored on a shared external disk array. I have around 50 websites. All of them work fine and are accessible. Recently I have found out a confusing problem though. Code:
File Path Show
I have a problem. I tried my best but could not solve is. I have a
page where user selects the folder name from a drop down list. It takes
user to show.asp page, where it how all the files in the folder and
also user can click on them and download them. If I select name of the
folder from the list, on show.asp it shows all the files and their
link.
When I click on the link then most of the file which has long
name and have space in their names wont be hyper linked. For example if
files name is Virus Control.vsd or file name is INCIDENT-ACCIDENT
INVESTIGATION REPORT.htm. If I click on them it will say "The page
cannot be found". Code: