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 would like sort table. The table is createobject method (open a function
and use SAP connection) and the table not use recordset. is it possible sort
table for example or how can i sort table columns.
set objTable = myFunc.tables ("Sales")
objTable.sortColumn="SalesID", Asc
What 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 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 Relatedi 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 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 an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. 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 Relatedcan't seem to get this ADOX code to add columns to existing Access 2000
table what's missing ?
Sub AddTableFields()
Set tbl = Server.CreateObject("ADOX.Table")
set cat = Server.CreateObject("ADOX.Catalog")
cat.activeConnection = conn
With tbl
.Name = "events"
Set .ParentCatalog = cat
.Columns.Append "MaxEntries", adInteger
.Columns.Append "CurrentEntries", adInteger
End With
cat.Tables.Append tbl
Set tbl = Nothing
Set cat = Nothing
End Sub
I have a SQL 2000 table with data I display in three columns. The code
I am using sorts the data horizontally but I need it sorted vertically.
Here's the code I am using. Perhaps somebody can help me find a way to
modify it.CODE
response.write "<table width='100%' cellpadding=1 cellspacing=0>"
if not oMain.eof then
count = 0
do while not oMain.eof
if count mod 3 = 0 then
'there are 3 in the current row, so end the row and start a new
one...
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 Relatedthere are many ways to make this happend but what is the best way of printing sql records in non divided number of columns-say 5 columns? say you got 10,000 names and you want to print it in 5 columns, that is a poor drawing of 12 records in 5 columns:
1 2 3 4 5
6 7 8 9 10
11 12
...every one of this 12 is a name
printing a name + checking if is there some ditails reffered to this name in other table column...
I access an access-table by this SQL-ADO-string:
SQLGetInfo1 = "SELECT * FROM kalender ORDER BY year DESC, month DESC, day DESC;"
Set rsGetInfo1 = DBConn.Execute(SQLGetInfo1)
Now I want to drop all the names of the columns, that is the field names, into a 1-dimensional array (or perhaps some ordinary strings, doesn't matter), but how do I do that? I tried with some rsGetInfo1.Fields.Name() and stuff like that, but the bottom line is, I don't really know how to fetch that property.
Normally I do a query, and loop through the records. Is there a way to loop through the columns of each record?
View Replies View RelatedI have to fix an asp database site, that may or may not have ever worked properly. I keep getting the following error:
"ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal."
I have researched and found that this is happeneing most likely because the script is requesting a field that doesn't exist in the database (maybe a mis-spelling). I can't find the code to display a list of columns in the database.
How can I know the number of columns of the .csv files? I want to import them to the database.
View Replies View RelatedJust like we have Recordset.GetRows() method to retrieve all the rows of the recordset, do we have anything that retrieves only the column values for a specific column from the recordset. I want to transfer all the contents of a column field by doing this into an dynamic array in a single go. instead of using loop statements to fill the array.
View Replies View RelatedI want to display a table with 3 columns only. The cells will be populated with database fields requested from a queryString .
The actual Access field value is either "Y" or null. If a "Y" value is true then I want the Field.Name to be displayed.
Anyway, the table has 40 possible columns so I'd like to limit it to display
only 3 columns: I can generate the field names below: Code:
I have a script that I want to display the returned list numerically in. The database is deciding how to order the list, and is being displayed pretty loosely. Is there anyway I can sort the returned list numerically here? Code:
View Replies View RelatedI have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:
qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.
I have a JS/ASP application that sorts a SQL populated table.
This works great, and sorts the data fine, apart from my currency columns.
It wants to read the data as text as far as i can gather. Ths data in ASP
looks like this -
<% =formatcurrency(RS("income"),2)%>
I have tried changing this to a number (formatnumber) and hard coding a £
sign, yet it still wants to read the data as text, rather than numerical?
How can i get my JS function to read currency or if not, eliminate the
forehand figures. I need the data to appear as a currency, yet be sorted as
a number (rather than taking the 2st digit)if this is a
common problem (sorting currency) and there was a universal solution around
this
I've lurked on here for awhile but I've come upon something I'm having trouble with.
I have a database table of movie titles and I want to sort by the column, but ignore the articles in the title, "a", "an" or "the"... "The Lion King" would be under L... "A Bronx Tale" would be listed under "B", etc.
Does anyone have a function that does this or know of another method? Or am I forced to enter them as "Lion King, The", for example?
Which would be faster?
1) Bubble sort
2) Join Array remove empty delimaters and then Split.
I am thinking the second would be a faster routine wouldn't it?
I have a form that is created dynamically, and all is working fine. But I want users to add an sort order to help list phrases in a certain order.
<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="10">
Phrase1
<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="20">
Phrase2
so on, so forth...
And one clicks on the form, and a SQL statement is executed.
However, when I create the SQL statement,
INSERT INTO table1
(FormId,AdvantageId,SortOrder)
VALUES (<call from form ID>,<advantages>,<advantsort>)
Then it loops to allow the next phrase to be entered. The statement also takes the value from every other sort order value including that ones that are in different lines. Which in result, gives me an error, saying the insert columns exceed that of the available columns in the table.
I'm trying to sort the fso. The file names are named june2004, july2004, august2004, ect... I need to sort them in chronological order starting with the latest one first.
The files were recently created so sorting them by the modified or created date will not work. The only other way is to them by the name of the file. I tried converting name of the file into a date using CDate (formated the file names as July 2004, August 2004, ect...) but it did not work. Code:
region = array("a", "b", "c", "d")
I am sorting in desc order that is d, c, b, a, it works fine. Is there a way to sort them as d,c,a,b? How do I do? thanks.
Code:select* from mytable Order by region desc
Can u help me generate a javascript to sort the options(list) in an asp listbox control?
View Replies View RelatedI have an SQL string that does a search using
SELECT * WHERE Titlename LIKE '%Crimson%' AND Titlename LIKE '%Skies%' order BY Titlename
This gives me all results containing both "Crimson" and "Skies". But I want a result that contains exactly "Crimson Skies" to appear first in addition to the blended results.
When I try to sort rows of records in asp with sql I cant get them coming out right. The column I'm trying to sort has record values such as 63, 254, 98, 7 but when I try to sort them ascending I get 254, 63, 7, 98 but I want 7, 63, 98, 254. Please help because its been annoying me for ages.
View Replies View Related