i am just trying to build a table that will put content into 2 columns. Ideally, if there were 20 hits, 1-10 would be in column 1 and then 11-20 would appear in column 2...i just can't seem to figure it out. I had started by getting a recordcount, and dividing it by 2, but things got a little fuzzy after that.
View RepliesI'm trying to pull the contents of a tab seperated text file into a table on my web page. This just seems like something that people must have done before and I don't want to have to reinvent the wheel on this.
Does anybody have or know of an existing script that does this or can anyone help point me in the right direction on how to approach this.
Is there a way to make dynamic columns? I'd like the data from one field to be the column in a dynamic table. What i'm trying to do could be compared to a pivot table in excel.
View Replies View RelatedWhat I want to do is list all of the columns in a table from a MYSQL database.. How would i go about this? I already know about select *, what I want to do is write them all down.
View Replies View RelatedI'm sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can't handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down.
I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn't query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns.
I have a Table with 10 columns and would like to sort this based on columns 2, 7, 5, respectively. I thought my code :
objRS.Open "SELECT * FROM MyTable ORDER BY col2, col7 col5", MyDB, , , adCmdText
should work, but didn't. How do I do that?
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?
View Replies View Relateddbpath = "D:Pure-Flo IntranetdatabaseEngDB.mdb"
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & dbpath
objConn.Open
Set rsSchema = objConn.OpenSchema(adSchemaTables)
Do Until rsSchema.EOF
If rsSchema.Fields("TABLE_TYPE") = "TABLE" Then
Response.Write rsSchema.Fields("TABLE_NAME") & "<br />"
End If
rsSchema.MoveNext
Loop
rsSchema.Close
set rsSchema = Nothing
just a simple example of what i'm trying to do. its supposed to list the names of all the tables in the database, but instead its returning the following error:
ADODB.Connection error '800a0cb3'
Object or provider is not capable of performing requested operation.
I am having to make sites accessible where images are dynamically generated.
'Display the graphical hit count
Response.Write("<img src=""counter_images/")
Response.Write(Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & ".gif""")
Response.Write("alt=""" & Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & """>")
How do I include the width and height attributes in this code?
I have a dynamic value from a recordset that if it is a 0 value I want it to
be hidden.
something like
If Recordset.Fields.Item("CarPark") = 0 Then
value hidden
Else
Show value
I have tried the following commands but they didn't delete the content of a table and they didn't retrun any errors.
Quote: SqlDataSource1.Delete()
SqlDataSource1.DeleteCommand = "DELETE FROM myTable" How do I delete the content of a table then?
.
Any one help me out how to add additional (dynamic content) When we open a mail. Is it possible using ASP.
View Replies View RelatedI have multiple video and audio files that I want to play on my site. They are also multiple sizes. Some are 320x240 and some are other wacky sizes. What I am trying to do is create a dynamic PopUp player to embed Windows Media Player in.
I have a Database where I have put the links and the display text for the video and audio files. I am currently using JavaScript to make my PopUp window.
Is there any way with ASP I can automatically size the PopUp windows to the right size to correctly house my embedded media player? I use ASP to create the link to the PopUp Window and then once the Window is open I use ASP to get the video file, i do the same for audio files.
Dynamic Content - Is there a way to keep information in some main memory pool in IIS so that each thread of execution (each visit to the site) would have access to it. I do not want to hit the db every time a visitor hits a new page on my site?
View Replies View RelatedIn my code to send email from VBScript, I use standard CDOSYS code similar to
the following:
With oMsg
Set .Configuration = oCon
.To = """Admin"" <admin@mycompany.com>"
.From = """Joe Admin"" <jadmin@mycompany.com>"
.Subject = "Hey You!"
.TextBody = "Service(s) have failed!"
.Send
End With
I understand the use of the .HTMLBody property, as well as the
..CreateMHTMLBody method. So I know I can create an ASP or HTML page, and
pass it to the .CreateMHTMLBody method, to get the images truly embedded, so
the email source contains the cid:blahblahblah references to the images,
which is key to getting the email to display properly in web-based mail
clients.
My question is... how do I achieve the same thing (embed the images) that
the .CreateMHTMLBody method does automatically, manually, so I can also
inject values passed from a form postback into the email?
It seems that I shouldn't use the .CreateMHTMLBody method. It seems that I
need to manually accomplish what it accomplishes automatically, so I have
more granular control. But I have found no thorough online resources that
explain exactly how. I have thoroughly looked at all of the SDK information
pertaining to CDOSYS, and I am still in dire need of an example for
VBScript...
It seems that the .AddRelatedBodyPart method is part of the answer, but when
I use it to embed the images and fill .HTMLBody, rather than using the
..CreateMHTMLBody method, I do not see cid:blahblahblah in the email source,
and the images do not display properly in web-based mail clients such as
Outlook Web Access.
I really need some help on this. It would also appear that I am not alone.
I find plenty of questions on this, but no answers. Can anyone help with a
working VBScript example that embeds images into an email in a fashion that
yields the cid:blahblahblah in the email source, for the image references,
that does not use the .CreateMHTMLBody method to do the work automatically?
I have a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML.I want to use the number that is put into the field to generate that number of rows in a table further down in the form.So I am posing this question how would I go about doing this.I am able to use ASP and Javascript (if need be).Or should I start over and code the entire form in ASP?
View Replies View RelatedI have a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML. I want to use the number that is put into the field to generate that number of rows in a table further down in the form. how would I go about doing this. I am able to use ASP and Javascript (if need be). Or should I start over and code the entire form in ASP?
View Replies View RelatedI am trying to add rows to a table dynamically, using JScript. Can I someone
explain, how to add events to the newly added cells/ rows? Following code
does not fire the onmousemove event. Code:
I have an ASP VBScript page with a dynamic table.
Each row contains a dynamic price, a qty field, and a total. The total on each row changes (onChange() ) when a qty is entered (this works fine).
I now need to total up the 'total' fields and put a 'GrandTotal' into a variable for later
Depending on a value in a recordset, is it possible to write the table cell background colour. for example:
If "win" is the value, bkgrd will be "green"
If "draw" is the value bkgrd will be "yellow"
If "lose" is the value bkgrd will be "red"
I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database. I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following:
http://sports.espn.go.com/nba/players/profile?statsId=3282
I am having trouble becasue the stat page is not by the player name but a numbered ID.
I tried using a player search like follows:
<a href=http://www.tsn.ca/nba/player_list.asp?name=<%=(Blair.Fields.Item("IDPlayer").Value)%>&Submit=GO ><%=(Blair.Fields.Item("IDPlayer").Value)%></a></td>
When I do this it only seems to search for the first name.
I have a dynamic table which is checking data from Access database and filling up the table appropriately. In my development environment of Windows 2000, the table displays properly but after hosting (that same source file), the table is not displayed. The error occurs at the following point:
Code:
<font face="Verdana" Size = "2"><td width="70px" height="25px" align="center" <%=colorBG(weekNr,dayLoop,intPeriodStart)%>
</font></td>
The host server is using windows 2003, what could be the problem?
I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database.
I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following: Code:
I have an .asp page that contains a drop down menu, that when a selection is made, reformats the page to one of 22 different .asp pages. When clicked, the drop-down disappears and the options from it are formatted as a list on the left hand side of the page.
I need to format this so the list is in 3 columns, with the secection bold. I think I need about 4 if..then statements, but I've never done this before...here's the specific code, the code for the drop-down is first, then the code for the "quick link" list: Code:
I have a problem to creating one of my pages which is in ASP. wish someone can help me with this problem.
well, I have a dropdown box which allows multiple selection. and this is in the form that send the values of the selected options in dropdown box (which the values are numeric) to the access database.
all of the proccess in send to database is ok and all of the selected values in the datafield on database is seperated with comma like this: Code:
1) I build a Html Table dynamically (Header Row, and then 2 rows with data
All 2 rows have 2 cells: cell(0) contains a delete button (ASP Button),
cell(1) contains a HTML Text box
2) On Form Load and get some data from a dataset and then from it's contents
build the page
At this point the page is rendered and 2 rows are displayed. There is an Add
button that a user can click to add another row to the table. This works fine
and the row is added.
Now if the user clicks the delete button in row 2 the form is posted back, I
rebuild the page, and then in the click event for the delete button remove
the row from the table and the dataset. All appears to be fine at this point.
Now if the user clicks the add button again another row is added, but this
time row 2's textbox has the wrong value. It appears to be related to the
view state. I think the view state somehow is not getting cleared when the
row is removed.
I have a database with a field called test which holds the value 1,2 (1 comma 2). The
value has been added through a checkbox. Now I want to write an SQL statement that
SELECTS both the value 1 and 2. If test had the values 1 and 2 in seperetaed fileds I would write something like:
SELECT * FROM X WHERE test = '1' OR test ='2'
But how can I do this when there is a comma? I want to know how I can check if the value test has the value 1 or value 2 directly in the SQL statment. Is this possible?
Maybe the only soloution is to retrive the values from test and then split them into two
variables and then to the value check later in the code?
how do i count the number of values sent accross the form post seperated by commas ?
e..g 43352352,325324452,235234452,24523454
Using ASP I'd like to modify a string that contains HTML. I need to modify the content (the bit that the users see) but not the stuff in the tags. For example, if I had the following string Code:
View Replies View RelatedI want to display the results from my database in 2 columns.any easy tutorials or article out there? havent found any easy so far
View Replies View RelatedHow do I find out how many columns exist in a SQL Server DB table before displaying the records of that table?
Also how do I get all the column names as an array so that I can seperate each column using the Split function?
I have a small doubt, my access database has been moved to SQL Server. Now I had some columns say [Where NoP] and similar many such columns. Are these columns going to work, since some of my queries are returning error. When i change the column name to say WhereNoP, it works fine, but in that case, I have to check around 300 forms where the column name is mentioned. So any clues to make such column types work.
View Replies View RelatedI want to make a listbox which will show the results of two fields (the ID and the Name) of one table , but the one field (ID) will be the one to pass.
View Replies View Related