I need to open recordset and select one record based on some value?
I need some script which will select random record based on the some percent or some number from 1-10, for example.
Its banner rotation system i have made, and it select randomly record, but I need some percent or some number(1-10) for selecting recordset based on that number.
banner1 10
banner2 70
banner3 40
...so every will be selected based on value from DB.
I have to output a recordset using paging. suppose by setteing: rs.PageSize = 100
The records has two fields: firstID and secondID. The recordset is ordered by firstID in reverse order, then by secondID in usual alphabetical order:
strSQL = "SELECT firstID,secondID,body FROM Forums "
strSQL = strSQL & " ORDER BY firstID DESC, secondID ASC"
rs.Open strSQL, connStr, adOpenForwardOnly, adLockReadOnly, adCmdTableDirect
The problem is that when I output the current page I DO NOT WANT that the subgroups of records which have the same firstID will be able to be in DIFFERENT pages...
I want that the number of records in every page will be >= 100 , unless the first subgroup of records in the current rs page that have the same firstID field, is larger than 100 : in this case I want that the current rs page will include only this subgroup of records.
I am doing a page where users will be able to key in the information in a form. However, whenever I tried to insert recordset & insert record, the page will be undisplayed and will be giving me this error: Code:
View Replies View Relatedit appears that my ISP is blocking port 1433 which means i can no longer connect to my sql db on the web. had been using an access project or another program called WinSQL. so i'm forced to go with a web-based solution and i don't really have time to build one from scratch. the host this site is on still hasn't installed the .net framework so i have to go with a classic asp solution.
View Replies View RelatedI want to do on my site and if anyone can tell me it can/can't be done that would be great. If it can be done, is it difficult or is there already code available and I can just *plugin* the info that pertains to my site? Code:
View Replies View Relatedi found a flash based mp3 player for my myspace that pulls the playlist from an xml file. my question is this... i want to be able to change the playlist (add, delete songs, change play order, etc...) without having to change the xml. here's my idea and i'm not sure how exactly to do all of it, but let me know if there is an easier way.if i create a db that stores the information i need (filename, song title, and track number) i can create an html form that will allow me to change the track number (i know how to delete and add songs). my question is how to i update the xml file at the same time it updates the db. in other words, how to i send the data in the db to an xml file.
View Replies View RelatedHow ca I write a asp page that will handle web based Install? Is it possible
or I need to go for some 3rd party Software for this, If Yes what is the
Best to use with ASP?
My requirement is: I have one Software that I wanted to install in Customer
PC directly from Webpage instead of allowing the user to download the
Software and Install.
I have dynamic weather on my site based on the users' zipcodes, but the feed takes much too long to load; therefore I would like to see if it is possible to query a site for a temperature only based on zip, and then use an "if...then" to display 5-6 different gif weather images. I know it can be done... www.dogears.net does it. Or if anyone out there has a good source for dynamic weather and or movies that can be used
View Replies View Relatedi want to develop a small application which will generate a list of
product from a database based on a user web page contents. something
like google adsense but not that extensive. any help or resource
available?
any guidelines. i want to use ASP , access or SQL server .
in short a script page, when called, read the contents and search a DB
for products and diplay it .
I have been mostly frequenting the PHP forums but now my job makes it necessary to get my hands dirty with ASP.
I am trying to find a Forum Software (Open Source or Commercial, doesn't matter) that has all the bells and the whistles. The following are some of the major requirements:Integration with existing Site and DB (including migration of data from current forum)
Ability to apply the look and feel of the site (if various parts of the Forum can be broken down to components/panes/boxes/windows that can be included in other site pages as well as customisable through CSS)
If anyone knows of any software that meets these requirements, please do let me know. Additionally, if you have experience in using that software, your opinions on it will be much appreciated. Currently I am going through some forum's that I managed to find through searching in SitePoint (ASPPlayground, Snitz, Web Wiz Guide, IdealBB). If are experienced with these
I am working on a script for a client that will switch a web element every Monday at 0:00:00 time. I have the entire website finished, however I now need to add a VBScript that will rotate between elements ONCE on every Monday.
If I am being too vague, here is an example:
<img src="puzzle1.jpg" />
I now want to rotate through puzzle1.jpg, puzzle2.jpg, puzzle3.jpg up to 12, then start again (a loop), but only make this change once each week on Monday mornings. So, this week it would be puzzle1, then starting Monday, it would be puzzle 2, etc.
I hope I am being clear enough, if I could provide further code, I would, but I am unsure as to how to start.
I currently have a web-based email for my site for users. Is there any way that I can make this so that it can be accesable from Outlook Express? It would have to call the database for the emails.I would need it written in ASP.It also needs to be free!
iis runs on win2k3.i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements
I'm looking for asp functions that can do the following:Based on the Month (& year) given I'd like to find out:
1.) The # of days in that Month
2.) The day of the Week the 1st falls on.
preferably in ASP, but perl would be better than nothing. I have seen one vers which connects through telnet - this isn't what I'm looking for. I'd like it to send html to the client, and hopefully support for logging in and updating high scores etc.
View Replies View RelatedSo far I've only found one, and the site for it is down.
View Replies View Relatedlike we can put php based forums in our web , so is there any asp forums available for ur web.
View Replies View Relatedi was wondering if anyone could tell me how to run code once based on date. I have an application that i want to update a database based on the particular month. Any ideas?
View Replies View RelatedAs creating folders after a form submission is quite easy (as pointed out in my last post - thanks again) I was wondering If it was also possible to create a new permanent ASP page based on a template .
All that needs to be changed is the title of the page and the file name. However the new page must be a copy of the template (only with these changes in it.
I really need a Classic ASP based Tree Script in which we can add,edit,delete parent,child or sub-child name from the tree
View Replies View Relatedi'm looking to select records based on date, the database
stores the date as mm/dd/yyyy time am/pm ie: 08/11/2004 2:42:28 PM and
unfortunately the field is called date
this much I know if i want to select based on date:
select from table where [date]=
it's my understanding that i need to put the name of the date field in
[] in order to prevent it from confusing it with functions etc...
however my problem is this
how do i get it to select records from the month of december i have
tried [date]='12/*/2004' and [date]='::12/*/2004::' and many other
variants that i have read about on various web sites, but it never seems
to work once again the answer is probably not as complicated as i
believe it to be,
Does anyone know of any ASP-based newsgroup reader (probably based upon
ASPNNTP)? I'm looking for a full-featured reader that I can host, similar to
Google Groups.
Time is changed and you see almost all ruling companies in INTERNET are using AJAX Based applications. Something that is named CallBack Event in ADP.NET 2.0.Here in this topic i want to start introducing step by step an AJAX-Based application development.
The target is implementing a professional AJAX Grid in ASP. So at the end of this continuous tutorial i will put the source code free. Be in touch to find out how AJAX concept improves our ASP applications.
am trying to redirect users based on time using following.It sends no matter what to first url.Code:
if now() > 23 or now() < 08.00 then
response.redirect url1
else
response.redirect url2
Its something simple but I just cant get to grips with it.
I need to redirect based on a param and here is what I am using:Code:
If Request("catid") = "9" Then Response.Redirect "ClassCatRealEstateSales.asp"
my guess is that there is a syntax problem, I am not getting an error because I have other lines that will catch blank ids and the like and redirect to a main page and that is working.
Is it possible to write a web based text editor? For example, is there a way to edit an asp file using an asp file? Here is what I have so far but instead of displaying the asp code it just displays the output html, Can I display the asp code so I can edit files without being at my computer and not using FTP?
Here is the current code:
Code:
<textarea name="editor" rows="35" cols="120">
<!-- #include file="default.asp" -->
</textarea>
I have a MS SQL database on a server which is [ublished on the web (ASP pages) I need to give the user a button to click on it and print a stored procedure based report. I dont know how to generate the report in ASP ?
View Replies View RelatedI got 2 ASP/Javascript based WYSIWYG editor scripts which have insert table functions. But aftyer placing the text or Image in the table it is not possible to set the table boder 0. If set this first, as you know I am unable to view the coloms. If there any why we can bring the table outlines(like in front page or dreamweaver?).
View Replies View RelatedI have multiple domains all pointing to the same generic dynamic webpage. Depending on the domain used, I want to query my database and retrieve certain display settings such as certain graphics, background colors and so on. What would be the best way to do this without using any redirects or Request.ServerVariables(*"http_referer") or anything like that? Is there any way it can be done server side or something really completely transparent to the visitor.
View Replies View RelatedI'm trying to figure out how to debug a very simple COM object I developed
in VB. I'm very new to VB and ASP so I have a lot to learn.
That said, I found what I thought was perfect article which covers this:
http://support.microsoft.com/defaul...;en-us;299633#2
However, I'm running on Windows 2003 and at step 4c) I don't have an
"Internet Service Manager" but rather "Internet Information Services (IIS)
Manager". OK, fine, I assume the name changed. Code:
i want to implement a guestbook on my website hosted on IIS.
i have created the form already and what i want is a page returned (after submission) saying thanx as well as showing the comments on it.
the fields i have chosen: name, email and comments.
i do not want it to be database connected but rather a file (txt) connected guestbook.
I am trying to create a system where an ASP page asks a question from a database, for example:
Is it an animal, vegtable or fruit? Dependent on the users answer, the next question asked would be based on the answer, for example:
If animal is selected the question would be: Does it have legs? If fruit is selected the question would be: Is it round? And so on. Does anyone know how this can possibly be done?
I am making a web-based proxy server, and I need to make it so that it can download a webpage, and modify all of the links inside it (so that it can proxyfy all of the links, rather than the browser downloading the files from the original website).
So far the first bit is fine, but I still need to make my script modify all of the links inside the given HTML file. I know I can do it, but it wouldn’t be the most effective way of doing it. Does anyone have any suggestions on how they would search through an HTML script, and locate links?
So far what I am doing is searching for anything that one of these at the beginning of it:
href=
src=
background=
And I am changing the text that comes afterwards (thus modifying the link). But for many reasons, this is a really bad way of doing it.