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.
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.
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.
Is there any way by using ASP with MS access to retrieve a specific data from a table and when i retrieve i want to show me the data without repeating the same data or duplicating data and i want instead of this to count for each item how many row is there in a the table ....... loooool i know that most of you will tell me to re-explain what i want to say again ... ?
For example i had three rows in the table ... and those rows are the same with 4 attributes ... what i need is to retrieve those rows in the website .. but instead of showing three rows it will show me one and next to this row i want to put 3 which is the number of the rows in the table that are the same and if i have any other rows it will do the same ...
Database procedure's condition -
IF i_as_on_date >trunc(sysdate) THEN
Database(oracle 8.1.7) date formate - dd/mm/yyyy
webserver data format (IIS5.0 hosted on win2k server) -mm/dd/yyyy
purpose - how to pass date's so that it both work in syncronised manner? can you write code of getting data format of webserver through asp page?
I have a DB field (Access2k) with a field who's data type is "currency". If I do a plain ol'
numberVariable = rs.Fields("price")
the data is not formatted (ie: $9.50 becomes 9.5)
Is there a way to format the value in ASP, or to bring the field's data type over when querying a DB?
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I've written many pages that emails the content of a web form, but the data
formatted very nicely. Is there a way to have the content of the submitted
form data via email in XML?
I have 2 table, tblCart and tblItem.
The structure for tblCart
CartID
Date
The structure of tblItem
ItemID
CartID
Name
a Cart containing several Items, it's one-to-many relationship.
I want to display Every Cart with the items in one webpage (ASP or PHP).
It would appear like Code:
i get some data from a session variable.(the session variable gets this data from another page).I want to display the data in a formatted manner.
View Replies View RelatedIs this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I just want to ask if it is possible to output the data from "DataGrid" in MSWord or MSExcel format. If yes, How to achieve it?
View Replies View RelatedI will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be displayed in a
3 * 4 foramt, like many of the professional sites would do (actually
rows and columns can be any number of rows and columns) All the
examples that I have seen, show data displayed in a top down format.
I need to allow user to save dataset to their computer in Microsoft Money
format. I searched internet for help on this but found nothing helpful. I
also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If
you will provide the steps yourself, please be very explicit in what you
provide.
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View RelatedI have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
if there any asp or vb functions that can convert any audio format files to vox format.
View Replies View Relatedhow to format date in MM/DD/YYYY format in ASP?
View Replies View RelatedI 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.
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?
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 RelatedI 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]")
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 RelatedI 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 RelatedI'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?
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.
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 RelatedDoes 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 RelatedI 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 RelatedI 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?
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.
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:
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.