Reading In Specific Value From Table
I'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:
View Replies
ADVERTISEMENT
I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid.
Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.
View Replies
View Related
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 Replies
View Related
Is there any way of using ASP to read the names of all the tables within my database?
View Replies
View Related
I 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 .....
View Replies
View Related
I was able to alternately change the rows colors, but this time lets say I have 10 records in a table taken from my database. How do i put colors on rows where value(certain value from a field) is lets say greater than 10?
Like for example I want to highlight only those student number greater than 10.
View Replies
View Related
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 ....
View Replies
View Related
I have a program that needs to rely on the date for Sundays on a given month. Here's an example:
Today is 3/18/2005 (Friday). When a user logs into my page, I need to grab the date that the past Sunday fell on (3/13/2005)
If the user logged in on 3/24/2005 (a thursday), I would need to grab 3/20/2005 (that sunday)
Any ideas in vbscript?
View Replies
View Related
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies
View Related
I am working on a college project which has a user area and a page where only a user can access their information and no one elses.I am trying to do a select statment to read specific information from a field without reading any other users info.
The code below is for a drop down menu for payment months i have stored in a database...
Here is what i have got so far...
Code:
Set oRs = Conn.Execute("SELECT [Payment_Period] FROM wages WHERE [Staff_ID]=" & staffid" ORDER BY [fullname]")
View Replies
View Related
I am looking to find out how to grab a specific content on a particular Website and put it on my Website. Of course, I will get permissions before doing so. Any ideas? I have found a sample ASP script that shows how to grab the entire page, but certain sections of the page.
View Replies
View Related
I need to execute different asp programs based on different values of a parameter. For example, if the user inputs ID of 1, program1 needs to be executed automatically, if user inputs ID=2, program2 needs to be executed in the background automatically. How do we do this in asp?
View Replies
View Related
I'm then going to use the answers in my select statement to pull data from the database.
Heres what i have now:
sql= "select * from assistancerequest where datein >= Date() - 7"
heres the problem with it:
it gives no errors but when it shows my output it shows wrong data.
Example:
27/08/04
28/09/04
28/09/04
29/09/04
this is some of what i get. as you can see it counts back 7 days, but its not working because this is from two different months! so it looks like its only checking for the days and not the month. does any of this make sense?
View Replies
View Related
i want to check item before insert new item. let say resID = 1052. before that, i have inserted item which is prodNumber = 100 for resID = 1052. then, still at resID = 1052, i insert another item, prodNumber = 100.
then an error message will come out. but if i insert item, prodNumber = 100 but for resID = 1047, suppose there is no an error message.
that means the sql conditions are at current resID and prodNumber.
View Replies
View Related
i need to connect to sql with different roles. is there any way for do that without passing users or passwords in the connection string?
View Replies
View Related
Does anyone know a way to find out the numeric value of a day of the week for a specific week, I am trying to display week periods from Mon-Sun. Ive toyed around with is but can seem to come up with anything.
View Replies
View Related
I have a feeling someone can answer this very quickly, but Im having problems. Basically Im trying to get the rate variable which will be either a 0 - 10 inserted into the appropriate row. I want the variable filename to match up with the matching filename in the database and then insert the rate variable into that filenames rate column. Hope I didnt confuse you to much.. Code:
View Replies
View Related
I want to get data in a specific format. For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
........ ........
....... .........
how it could be possible.
View Replies
View Related
I have a script which creates an array by doing this:Code:
strInputValue = "this will be split into an array"
arrMyArray = split(strInputValue)
This produces an array of 6 (UBound(arrMyArray) = 6).
Is it possible to remove part of the array, so that "into" for example will be removed, such that UBound(arrMyArray) = 5?
View Replies
View Related
im a bit of a rookie and i couldnt find anything using search,how can i have a statement which selects only the records which contain data.
Code:
sSQL = "SELECT * FROM VIEW_COLLECTION " &_
"WHERE (BusinessID = 20) AND (Parentid = " & objRScats("CategoryID") & ") " &_"ORDER BY CollectionName"
Thats what i currently have. This is for the page navigation - and i dont want a those collections that do not have any data to be diaplyed - but i do not want to delete these records altogether just yet.
View Replies
View Related
If Request.ServerVariables("URL") renders
/myserver/mywebpage.asp
How can I just return mywebpage.asp?
I can use the RIGHT function, but I'd like for it to work on any page,
regardless of the length of the page name. I'm looking for a good example of
using a combination of MID, LEFT, RIGHT, etc to get certain parts of
strings.
View Replies
View Related
I want to get data in a specific format.For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
.. ...
... ....
how it could be possible.
View Replies
View Related
I have a few ASP pages that go out and query a database and return data that meets a requirement. For example I have Department hyperlinks in a Nav bar that select just the records associated with that department. The returned records are placed in a table to be viewed. In that table I have a field hypelinked to a PDF image. 100+ records could be returned.
How could I place a hyperlink, or check box, in one of the fields that would select that specific record and display the data on another ASP Page. What I am trying to get at is when I get the returned set of records, being able to click ONE of them and display that information as well as any associated images connected to that single record.
View Replies
View Related
I have a string like this - 203_4_54_3_12_43_0_204_3_23_43_0_2_2
How could I count how many "_" there are in the string?
View Replies
View Related
i have a remove user and change password script written, but the only thing they are missing is the actual text file editing part. i have the file open because i have read it, but how can i delete a line that matches with 'OldLine' and put 'NewLine' where it was with a couple of lines of code?
View Replies
View Related
I would like to collect financial data from the stock exchange into the asp web page.
Complete daily results are in txt format on a fixed URL. Soo far I managed to pull the data on my web page, but now would like to select only specific rows. Unfortunatly the rows are not fixed, but each one has a 4 digit code on the beggining.
So I would like to create asp code which would select n rows from txt page based on specific code on the beginning - for example 0020. In the SQL would look like this one SELECT * FROM file.txt WHERE the beggining of the row = 0020
Is that possible in asp ?
View Replies
View Related
This might be i bit complicated, but i'll explain this to the best of my ability. I have a txt document with the following content. PHP Code:
Blue<br>7<br>2. Green <td align="center" class="normal">3. Light Blue </td><br>8
How would I go about creating something that reads the text file, and only outputs the text without the html?
View Replies
View Related
I have made a secure website which you can only get access to with right username and password. On this webpage I have some links to some pdf-files, but how can I avoid people from getting the file if they are not logged on first? As it is now they can
easily get the file if they just know the exact URL-address, ex:
www.website.com/dir/file1.pdf
If people type the URL above I would like them to be redirected to the logon-page first.
I can't use components or MS-Access database, so I'm looking for another solution.
View Replies
View Related
I use an access database and vb.net
The code is :
dim dtraw as System.Data.Oledb.oledbdatareader
OleDbConnection1.Open()
dtrav = OleDbCommand1.ExecuteReader() ' oledbcommand 1 is an sql
query
DataGrid1.DataSource = dtrav
DataGrid1.DataBind()
OleDbConnection1.Close()
That works geat but what i want to do is to take a specified value from a
datagrid (for example the third row of column productid ) as a sting.
View Replies
View Related
Let say I wanted to get an IP address of a machine called mybox. How can I do it in ASP?
View Replies
View Related
Is there any way to disable certain functions in the browser when someone is looking at certain pages on your site which would disable the user from being able to print, view source and save? I learned the no right click trick here earlier, but users can still click file print or save or source.
View Replies
View Related
I have the following code:
If ad_expiration_date (date() + 90) then
ad_expiration_date = (date() + 90)
else
end if
What I want to happen is if the ad_expiration_date entered by the user is beyond 90 days from today's date, the Expiration Date should be today's date plus 90 days. If the entered date is less than 90 days from today's date, leave it as entered. The code isn't working correctly, all dates entered are getting converted to today's date plus 90 days.
View Replies
View Related
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)?
View Replies
View Related
