I've got some bizarre behavior going on with my ASP code below. For
some strange reason (and I'm a newbie to ASP so it's probably obvious
to others) I can't display all the rows of data from the query. As an
example, the Problem Solution column doesn't display and unless I
comment out another column. Or if I move Problem Solution and it make
ithe first column, then the Root Cause won't display. Code:
how can i show data column wise from database in asp
for example i have data like some names that i want to show like this format
Name1 Name2 Name3
Name4 Name5 Name6
Name7 Name8 Name9
....... ...... .......
please tell me how can i do this
I am trying to build the code that will add a specific column's column where something = something
Example
ID Name Amount
1 Bill 10.00
3 Ted 15.00
1 Bill 25.00
1 Bill 35.00
4 Jude 5.00
In basic word terms, this will describe what I am seeking:
SUM(amount column where ID = 1) ..... answer would be 70.00
I am already connected to the database and can pull out one specific field in a column, just can not add that column.
how can i show data column wise from database in asp. for example i have data like some names that i want to show like this format:
Name1 Name2 Name3
Name4 Name5 Name6
Name7 Name8 Name9
I have a 3 page set that searches a database for users, displays the user information in a form and updates the data in the database. The first 2 pages work fine, the third page doesn't. What is annoying is that these pages are a copy of another set of pages that edit news articles (basically the same thing) and they work perfectly.
This is ASP with SQL and VB Script.
Quote: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '6, 6' to a column of data type int.
/d1intranet/useredited.asp, line 72
So this message is saying that it is unable to UPDATE the field 'UserName' (which has data type INT) with the variable in the SQL code which is default as VARCHAR. Here is line 72: Code:
I have a classic ASP page which links through to an ASP.NET 1.1 page.
Basically there is a hyperlink on the classic ASP page that opens the ASP.NET
page in the same window. I can then go back to my classic ASP page by
clicking on a link on the ASP.NET page. It all seems to work seamlessly,
apart from 1 end user. What they find is that if they click on the link and
open up the ASP.NET page, then go back to the classic ASP page, all the
classic ASP cookies have been emptied out, yet the session info still
remains. They are running on a Windows Server 2003 machine with IIS 6. I've
tried to replicate it here, but as yet have been unsuccessful.
I am having some problem with this code and need some different eyes, i have a drop down and when u select the value from drop down u see the results.
it works till here perfectly, i have also done paging so if select the Id from drop down page is refreshed and u see the records, i have set up to view 20 records on a page:
if there are more then 20 records and i go to the second page then i dont see my drop down: can someone tell me whats wrong with the paging Code:
I have some page content stored in an Access DB. I want it pulled from the db and posted to a .asp page. I am using Dreamweaver to create a simple query and to display the data. If the data is just plain text it will display. However, if I enter any HTML (even entity references) the page still renders but the text will not show up. I don't get an error or anything. Everything else works just find but the text does not show. If I change the content in the DB back to plain text it will show up again. What the heck is going on? Anyone have any ideas? I need it two display with the HTML as this is part of a small CMS for a client.
View Replies View RelatedMy website uses cookies to persist a certain amount of data on the client. However, occasionally the cookies will disappear or be set to an empty string for no discernable reason. It does not happen in our development environment at all, but does happen in our production environment. We looked at all the likely settings and they were identical on both the production and live servers.
We set the cookie domain properly and the cookie path.
Has anyone seen similar behavior? And if so, what did you do about it? What IIS settings should I be looking at? Could it be a service pack that was installed on one machine but not another?
I have a site that works fine for days, then suddenly, I start getting ASP 0115 errors with an indication that session variables IN SEPARATE SESSIONS have disappeared!
First, for background information, I have a customized 500-100 page that sends the value of various session variables via email to my support site. On the home page of the site, the FIRST THING that is done is a Session variable is created that saves the Session ID. I see an ASP 0115 error thru the email, with NO value defined for the session variable that SHOULD contain the Session ID. After the first error, I see more of them.
I am calling a subroutine when I click a submit button. In the subroutine I grab values from text boxes and validate them. If it all works then it goes to the Update page.
Well my validating works but when it calls the Update page I am using the Request.Form to get the values from the form to update/insert into the database.
Well if I do an update it updates all the fields as empty. If I try to do an insert is says it can't insert NULL into the Primary key field.
Now most of the time the Primary key field is a list box and I don't touch it in the subroutine. Still why are all my values disappearing when I call the subroutine??
So I guess that is it. When I validate a forms values, them same values are no longer available on another page through Request.Form?
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI have a csv file that I'd like to be able to add a column to. Specifically, I want to take the first 6 chars of the filename and add it to each row as a new column. e.g.
Code:
whatever.csv 'before
1,2,3,4
whatever.csv 'after
1,2,3,4,whatev
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 RelatedHow do you get the description of fields in an Access database? I really need this and can't find it anywhere....
It would also help if someone showed me how to get the datatype and other info (like if it's a Yes/no or True/False field).
What is the resource/doc for this so I know where to look before asking from now on?
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -
Code:
Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:
View Replies View RelatedI need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
View Replies View RelatedPretty basic but I cannot figure it out.
Column:
FULLNAME (lname, fname)
Needs to be
FNAME
LNAME
Should split at the comman.I already have all the columns created; just
need to SQL command to make it happen.
I am trying to access a table in a SQL server using ADO in ASP. It works fine in the rest of the site. Here is the code:
View Replies View RelatedIf I have several fields:
a | b | c | d | e
and the original SQL = SQL & " ORDER BY a ASC ".
I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).
do I need to place an "if/ end if" in the sql or do I put some statement in the paging?
example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v
to
a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w
I have a SQL query that produces a table which displays account numbers and the amount owed on those accounts.
the page that displays that table is written with ASP. Does anyone know how can I highlight the rows in the table where account numbers have more than 7500 dollars in amount owed? Code:
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
View Replies View RelatedI have an asp page which the user enters a time(e.g. 12:21). I need to insert this time into a SQL Server DB, which has a smalldatetime column.
I have tried everything I can think of (such as CDate, TimeValue, FormatDateTime etc) to convert the time string, into a valid time. However, the insert always try to insert a datetime datatype (e.g. 12/12/1899 12:21:00).
I am trying to process the insert through ado, eg:
objRS.AddNew
objRS("Field1") = strText
objRS("DateField") = dteValue
objRS.Update
I use this code to dynamically create a column in a table...
strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
conn.execute(strSQL)
This will create two text columns. How can I create some YES/NO columns
instead of TEXT columns?
Is there a way to have a piece of repeating information display in multiple columns like a phone book? I need to display a list of contract numbers which will link to the actual contract.
There is no other information to display and it would be better if I could display 3 or 4 columns on the page like a phone book. Hope that makes sense. I am using Dreamweaver and it's and Access db if that helps.
I use this code to create a table dynamically.
strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
conn.execute(strSQL)
This will create two text columns. How can I create some YES/NO columns instead of TEXT columns?
Is it possible to get a db's column names not the data inside the columns just the columns names.
View Replies View RelatedI've searched high and low in this forum for an answer to this one. maybe someone knows where it's at.
Let's say I have a page that is displaying fields from the database. There is a column of numbers, that at the bottom of the page I would like it to display the total of those numbers displayed. Is there an easy way to make this happen?
I want to save the details of phases. On selecting a phase, there are 3 columns, task ,start date, end date in a row. Next to it, a button'Add task' is displayed. on clicking this, another row appears below. When i click submit, the data is saved if the following condition is truw: The end date should not be less than start date. how do i retieve the data of all the rows.
View Replies View RelatedHow do I print the name of all columns in a table?
View Replies View Relatedi need some quick help from who has dealt with this before. I am trying to add a column to the db using form input for the column name.
I can add it as any datatype however i need it to be a Yes/No checkbox column. What is the script required to achieve this?
heres my code:
SQLadd="ALTER TABLE Models ADD COLUMN `" &namef& "` BIT"
conn.Execute(SQLadd)
I read somewhere i have to use BIT but i only get value 0 and not an actual check box.