Creating An More Advanced Search
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
Everything i've tried doesn't seam to work.
View Replies
ADVERTISEMENT
Imagine you have a databse memo object with the description of a town.
Imagine if you wanted a peaceful town, you might type "peaceful" in a text
box and then click submit, the query run will be:
WHERE towndesc LIKE '*" & Text32 & "*'
Now imagine if they type "peaceful trees"
How do you get it to automatically check:
WHERE towndesc LIKE '*peaceful*' AND towndesc LIKE '*trees*'
Because it can have one description or the user can enter 5.
Or maybe you want the user to be able to enter key words like AND OR
and use them within the query.
View Replies
View Related
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.
View Replies
View Related
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???
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 %>
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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://".
View Replies
View Related
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.
View Replies
View Related
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'),
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
what's involved in creating an ASP? I need to create a web page where users can check their past history of the account.
View Replies
View Related
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,
Set objRoot = objDom.createElement("projects")
this is the link that would go into projects:
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="semesters.xsd"
View Replies
View Related
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!!
View Replies
View Related
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
View Replies
View Related
How can i create a ZIP file from a folder (full of files) of the server.?
View Replies
View Related
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? .....
View Replies
View Related
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.
View Replies
View Related
I am trying to pass a form value and pull some values from an array. I am getting no errors but no values on this code. Any ideas? Code:
View Replies
View Related
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.
Service1
-produc1
-product2
Service2
-produc1
-product2
-product3
..more
Service3
-produc1
-product2
..more
What is the best way to this...
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
