Write an exe/dll (which will be better please tell me)..which has code to only control my logic or rather data conversion/manipulation of the raw data recieved thru and .mdb file and then display the exe/dll manipulated data thru an asp page.??
View RepliesI am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM,
and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
there is a JavaScript/ASP function that that will check for new Private Message (PM) Inbox. New PM will be referred as "NEW" in the status field in the database and "READ" for all the old PM.hen there is a new PM, a popup will appear in my page. But I have to press the REFRESH BUTTON before I get the popup ALERT!
Can this be done in AJAX? (Alert me without refreshing the page?)
May I know how to use the ASP to display the data from database in the format of data grid or table? If possible, please provide coding.
View Replies View RelatedI have a database for my users orders, and I what a search for the admin to search for the orders in a specific user and display them in a chart.
View Replies View RelatedI Have a list of groups that are assigned to users. I want to list groups for a particular user in order by name. I want to then have a drop down list that shows all the groups that the user is not in at the moment. Users can then add groups to that user.
How i have it setup:
I have a table that has an id and group name.
I have another table that has id, userid and groupid
Do anyone have any ideas how to diplay it. Keep in mine that the groups have to be in order of the group name. Thats tge part that is confussing me.
I am creating a resource website and pulling from an access databse, I have 1 page that loads with a list of catagories, when you click a catagory the page reloads with a querystring attached that loads only the contents of that catagory.
All of this is coming from the same table in the database, I have an ID column that is shared by the articles in the same catagory.. (i.e. ID is set to 1 for all the items in catagory 1, set to 2 for all in catagory 2 and so on).
I currently have articles in about 6 of 16 catagories. Everything displays fine but if you click on a catagory that has no articles, I would like a message to appear such as "There are no articles found for that catagory". How can I get the ASP script to see that there are no (we will say) entries for ID 8 in the databse, and display the message.
We're working on creating a site that tracks club sports results - we originally created a form that inserts the results into a database, but the folks using it have decided they'd rather enter the information in a spreadsheet and upload it.
what is the best practice for this data - should I write some code that just reads the content of the excel file and displays that on a results page or should I take their data and import it into the database we initially designed.
here is an RSS feed for top stories from a local news station. http://lex18.com/Global/category.as...&clienttype=rss.I need to display this data on my own website. I know ASP, but not XML.I have read some documentation and browsed websites, but I cannot figure it out.
View Replies View RelatedI know this is probably a stupid question, however I'm trying to display the contents of a recordset into columns spanning across the page rather than down the page,
i.e.
CATEGORY CATEGORY2
subcat1 subcat1
... subcat2
And so on. This is a 2 column table that I want to use. But I don't know how once one column is long enough then go across to the next column and fill that column with the remaining data. I know its simple if you have go down a page, but can't figure out to go across.
Someone asking me in the PM yesterday. How did I managed to display data in 3 cols & rows i.e category,sub-cat, search result and form in CSS table-less layout?
I have use it in my site article,freeware,recipe,link directory,lyrics,template and games section. I was able to display the data in 3 cols and rows using CSS layout. It took me quite a while to figured it out. In ASP, you should know where the loop start and end, otherwise the div container stack up each other. I was thinking of writing a tutorial with sample code in ASP. Maybe next time.
My next project is to convert Maxwebportal and snitzforum into CSS layout. To see an example, visit my site and go to this section of the site: article,freeware,recipe,link directory,lyrics,template and games. These pages are CSS table-less layout.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a recordset that returns company names, their are duplicates, sorted
by company name.
sCompanyName = ors("company")
How can I show only one company name from each company and display nothing for the next name if its the same in the previouse row,
COKE $2.14
$2.16
$2.16
PEPSI $3.13
$3.11
$3.12
FANTA $1.26
$1.26
I want to display a system maintenance notification on my webpage using a splash screen. I got the code for splash screen from Dynamic Drive and added it on my web page. Now here is my problem. I have created a table in my SQL database with these two fields, Flag and Description. I am trying to connect this splash screen to this table.
This is because-if the flag is set to 1 the splash screen will pop up and display the data in the description field on the splash screen and if it is set 0 the screen will not pop-up at all. Two things I am having trouble with-
1. Displaying the data on the splash screen. I made the connection to my db but can't get it to display it on my splash screen.
2. How to make the splash screen pop-up only if the Flag field is set to 1.
displays content IF several conditions exist or display's nothing if it doesn't?
Basically, in english this is what I'm trying to do:
IF a record exists
WHERE session(userID) = idByUserID in 'notes'
AND
WHERE userID = idAboutUserID in 'notes'
THEN
display from the record fieldnames 'LastUpdate' and 'note'
ELSE
don't display anything
I have a page that shows the skillsets our analysts are on here. We have 10 skills, each one a different recordset to pull their data, so the page takes a while to load (7 seconds). What I was wondering if its possible to do is just show the heading (the name of each skillset), but when clicked on, a response.write of somesort would show the cell underneath and then pull the data.
Hopefully it makes sense what I am saying, if not i'll try to post something up.
How to use the for loop to display all the data in database? For example, displaying the data that start with "a".
View Replies View RelatedHow i display DATA from Browser to Text file.In my web page there is a script that fatches data from this URL: http://www.rediff.com/rss/newsrss.xml and display data on the web browser.now ,how i get that displayed data from the browser to a text file.
View Replies View RelatedI try to find the best small exemple to display data from excel to asp (connection & code). But only asp.net exemples in microsoft.com.
View Replies View RelatedI would like to know if you can display only certain data into a field between commas or any other symbol without using the curshort feature. For example. I have the following.
Part, A3472, Desc: Controller: Price$ 45.00
I just need this out of it in a single form field.
A3472
I cannot use the cutshort feature because my part numbers are different lengths.
If i created three different type of table. Inside these tables, they might have the same key field's name. Example:
Table A - ExecNo, Month, Year, CustCode
Table B - ExecNo, Month Year, DestCode
as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.
where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.
I tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:
<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>
And it does not displays the data.?
I am trying to display some data in the text area from the database.
I want the data to be displayed in this format in the text area:
Name ph1 ph2 address details
But i am not able to display data in text area.any ideas or examples??
i need to display a data on the web from the miscrosoft sql server base on the user who have log on to the web.
name : <UserFullname>
id:<UserID>
profession:<UserProfession> ..
I currently have the following code to extract data and display in a table.
-Sample code ---[Ranges from 1 to 205] #20 is displayed below]]-------------
Dim ticket20, sql20
Set ticket20 = Server.CreateObject("ADODB.Recordset")
sql20 = "SELECT * FROM routingdata WHERE ddate = #" & Session("today") & "# ;"
ticket20.Open sql20, db, adOpenForwardOnly, adLockOptimistic
While Not ticket20.EOF
Response.Write "<font size=2>" & Ticket20("20")
ticket20.MoveNext
Wend
ticket20.Close
There is 200 plus cells that it need to display - so it takes a long time to display the data. Is there a better code to extract all this data and faster ?
There is a search engine in my system where i have to key in the student's number. n search for the student's complete information from the database.
n then i have to display the student's info at the same form where i did the search. how to do this using asp n dreamweaver MX.
I have 3 fields in a table that need to have math functions. Field 1 x field 2 = field 3, then total by customer code and display on a page. How can this be done?
View Replies View Relatedas i enter text in the textbox i want to narrow down there result in the box below that has all the listing of the products. i.e as i enter 'a' in textbox it will filter all products starting with 'a' then if i enter 'b' as second character it will show onlythose products that are starting with 'ab'... so how could i do that.
View Replies View RelatedI have an MySQL query that counts the number of clients that have been added in the last week.
strsql = "SELECT COUNT(visitorref) As no_visitors FROM visitors WHER datediff(curdate(),date(loa))<="&weekday(date())-1&" AND client_count IS NULL"
This works fine for Monday through Friday. But, I want to change the week etaphorically speaking! ) to run from Thursday to Wednesday, so on a Tuesday it'll show the count from last Thursday to the Tuesday.I'm gradually beginning to think I can't do it this easily anymore and just can't figure out what I want the datediff to equal.
i ussually use www.domainname.com?uid=1111 .this one use request.quarystring right?so, what is the logic to change to www.domainname.com/1111
View Replies View Relatedi was building a internet based search engine and heard of fuzzy search algorithms.
Can anybody give fuzzy logic search algorithm for string search.
how can I display multiple access data on hyperlink in ASP?? For example like I click on Monday link it will only display all the informaton about Monday and click tuesday will only display tuesday information on same page.
View Replies View RelatedThis is just a test before i apply to my system. I have a student:
Table: Pelajar
pelCode : 1001 (datatype: Number)
pelName : Michael Lee (datatype: Text)
countryCode : US (datatype: Text)
Table: Negara
countryCode : US (datatype: Text)
countryName : United States (datatype: Text)
i want to display this student's country name in the dropdown list as a selected country name and at the same time, populate all country names in the dropdown list. but, i can't make it. i saw the selected country name is country name that at the 1st row of table Negara ......