I'm trying to create a search on my asp form that will ingnore spaces, and, or and replace them with % for a wild card search. now if they type in the box Go Home it will only find Go Home. Right now I'm just trying to get it to take that Go Home and put it in Go%home.This is what I'm using for this field.
pcat = GetParam("category")
if not isEmpty(pcat) then
if not (sWhere = "") then sWhere = sWhere & " and "
HasParam = true
sWhere = sWhere & "e.category like '%" & replace(pcat, "'", "''") & "%'"
end if
Is there any resources (code, samples, snippets, methods etc) anyone knows of creating an advanced search in ASP linked to a microsoft Access 2000 database?
I basically want to query a database from attributes stored, e.g male, height etc using radio buttons and a text input form.Im using Dreamweaver MX and a DSN.
I need to create a Search facility for a website I have done, however it is a mixture of static pages and dynamic pages that pull the content from a database! I have implemented a Search facility before, but this was just for static pages...
This website has possibly 35% static pages, and then 65% dynamic pages where their content changes depending on an id variable, so one single asp page holds the conent for over 100 different records in the database!!
Does anyone know how I can do a search that will search both the static pages, as well as the dynamic content in the database???
I know there are quite a few out there, FusionBot being one that I have taken a shine to, but if not just for the challenge I want to create my own localised search engine that allows me to put search across say 5 - 10 of my web sites.
Now these sites are on different servers and most are not ASP hosted, but as FusionBot seems to be able to index remote sites and then give you a bit of code to query it's own DB, it must be possible to do.
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.
I've created an ASP search engine for a site I'm working on. Does anybody know a good script that will create a log file with all the search requests in.
I'm happy reading / writing data from a database with ASP, I'm afraid I come unstuck when I have to start writing data to loose files on the server. Any help or a link to a good tutorial would be gratefully received.
my company is in need of a shoppingcart that has adavanced inventory management in the admin, i.e. calculates 'cost of goods sold' in reports and FIFO etc. Anyone know of any?
I already have the code which does simple paging [First] [Prev] [Next] [Last] . how to achieve the [...] feature?? That is if there are 1000 pages, I don't want to display the page link for all the 1000 links in one go. I want only the first 10 page links to be shown on one page then display [...] for the user to click and see the next 10 page links.
I have been searching for this feature for a long time but most of them talks about the simple paging only. Useful links and complete source codes.
I have had a project on my plate for months with noone who knew CDONTS enough to help. I do not believe there is anyone better to ask than you. Here's my problem. I use CDONTS on 2-2k servers with the basic SMTP server included with IIS. Because of the corporate firewall I am unable to use this method to send email to an external email account.
What I need to do it use CDO 1.2 and attach to an outlook application on the server which has access outside our network. My problem is every tutorial I find seems to be wrong and noone seems to know how to make this happen.
Advanced DHTML Dropdown List component (Javascript,ASP,.NET,PHP) enhances usability of large dropdown lists with type & select feature. It suggests possible matches for entries you type in the input box.
I need some help with creating an MS Access table using ASP. I'm familiar with "standard" SQL statements, and also with the ASP methodology/syntax for creating a simple MS Access table. However, the table I need to create is a bit complicated, because:
The primary key is a FORMATTED auto number (i.e., if I were to define this field directly in MS Access' "Table Design View", I would put "Acme-"000 in the FORMAT field to create an autonumber that automatically generated a series like Acme-001, Acme-002, Acme-003, etc.)
The first part of this formatted autonumber is a variable. So, with this in mind, how do I write an ASP statement to create a table that has an autonumber field as a PRIMARY KEY, formatted per the above?
URLURLI need help writiing an advanced conditional statement.I want to display an image if two recordset values = 1 or other various number combinations.
This statement works with one, how could I edit this statement to include two recordsets values? Say I want to add another feild say "recent" to this statement and it has a value of 2
Code:
<% if Recordset1.Fields.Item("progress").Value = 1 then ' Adv Conditional Region %> <% end if ' Recordset1.Fields.Item("progress").Value = 1 %>
What I want to do, is in my admin page, where I have all the users details, I want to be able to see when they last logged in, how many times they've logged in, and which user's are currently online? Just so that it can be used for reference, and also as a sort of extra security.
Also, is there any way that I can make the login more secure? At the moment, it only uses Sessions, is there anything else I could do to make it more secure?
May I boldy suggest that a new advanced ASP forum is created (ideally within the "Advanced Development Center", but otherwise as a sub-forum of this forum) for ASP questions and discussions which are more challenging/complicated than the norm? Code:
I am trying to debug an issue with sessions in my ASP 3.0 web application, which runs fine on WIN2K Pro and WINXP Pro, yet fails to function correctly on WIN2K Advanced Server.
My actual application is using sessions to store username, and security level (permissions) for my application. The default.asp page is the login, where these values are set. I have triple and quadruple checked my IIS Settings to make sure "Enable Session State" is checked, and the session.timeout is set to 120.
Now if I remove my application, recreate it in IIS admin, stop and start the IIS services, and run my application, the session variables seem to be saved across the first redirect to my main_menu.asp page. Here I have several menu choices, which are dependent on the session("seclevel") to determine which they can or cannot access.
Here is where it seems my session vars are lost, since when I click on any choice, I get redirected to the log_out.asp page, which abandons the session and returns the user to the login (default.asp) page. Code:
if there is a way to validate email addresses further. For example I just received an email from this person:-
cvx@fcxgf.fgfd
Obviously some fool trying to f**k with my form and send me a test email.
Because an array of countries have different extentions, can I not somehow validate for that?
I guess my validation is picking up on the @ symbol and the fact that some chars are needed before and after the @ symbol and a dot exists. But can we validate this further to prevent me getting this kind of email?
Can anybody point me to a good tutorial/manual on advanced server-side form validation including validation of fields against unwanted strings such as the use of "http://".
i get the ref url that come to my site and i want to convert it to find out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my site was in his resaults and he click on it , in my site i see his link ref like http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words that the user write in search engine.
i am making a forum, im the database i have a row called 'TopicLastPostDate' and 'TopicCreated'. 'TopicLastPostDate' only adds the now() value when someone posts a message, and i can't put the 'TopicCreated' there as well when im posting the topic as it checks if 'TopicLastPostDate' got any data to then add a data of last post in the topic list. can i use ORDER BY on 2 different rows? (both 'TopicLastPostDate' and 'TopicCreated'),
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.
The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
Environment: Development PC: W2K Professional WebServer: W2K Server, IIS 5.0 Peer-to-Peer network
I'd like to create a new asp.net project on a remote server (not on the local (development) machine. I have looked for info on how to do this, but all I can find are instructions on how to create on localhost, then deploy later to remote machine.
So i currently have an asp page that creates an xml document with information from a database. However I need to link to my schema when creating the Root element here,
Im trying to create a string from checkboxes that have been checked, but for some reason its not working
strNumbers = "" for each key in request.form("chkFacility") strNumbers = strNumbers + "" & key & "," intCount = intcount + 1 next
So I want to end up with a string like this '3,12,7.' Instead Im just getting a single number. Am I doing this the right way. Any help wud be just fantastic!!
I know how to use ASP to create and write into a .CSV file on the server, but I have a small problem. Every time I write to the file I am adding new lines each time. I don't know how to wipe the previous contents out, and I thought this is probably a no-brainer for you guys ...
So, I'm looking either to delete the file at the start of the process and start from scratch or
* open the file * wipe all contents from file * write to the newly cleaned file
I have an asp page where i created cookies-for admin and for user. The aspx page reads these cookies. Everything seems to work fine but now i have to create a new cookie if cookie has expired or if cookie is null. Also, i am having problems with the expire because if the username belongs to the admin for example and then i want to change the username that belongs to a normal user the cookie recognises the first (admin) cookie. How do i solve this? .....
I want to create an order form for prints online... I will have up to 200 prints to be selected. What I am thinking is that I will have an HTML Form that has all the 200 thumbnails with a check box next to them. They select the ones they want and push next. Then I would like it to create a set of options for each one they selected.
That basically says the image name then has a check box for 5x7, 8x10 and a text box for the amount for each... I do I create the page what creates these selections and how to I incorporate that into a mail form going to the next page?... it seems like a simple enough idea. Am wondering how the reality of it will be.
I am using asp and access database. I need to create a menu according each member access. In other words, if member login I need to display the menu according to the services the member selected during registration. Each service contains diff type of products.
i have website which provide daily news. we store the news into sql database. i want to create a rssnewsfeed which i can provide to other websitemasters. can anyone tell me the asp code or other where i can create rssnewsfeed from my sql data.
I have a problem. I have a database with 1000 e-mails that i use in my mailinglist. And when i send them mails it takes kinda long since i attach a ..pdf file each time. so i was wondering if there is a way in asp to create a task on the webserver using asp to trigger a script that sends the mails. sure i could use server.scripttimeout but the thing is that i dont want to wait 30 seconds for the page to finish loading. and if there will be 3000 in near future i'll have to wait for a very loooooong time.
anyone know how to create a task using asp dynamically?