Creating A Search Facility
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
ADVERTISEMENT
i have provided company listing option, from where manufacturers/exporters can add their company. also there is search facility, so that user can search by products or company and get the information. initially the search result shows only company name, when user click on comapny name the detailed company information will display. now, what i want to do is:
there is a field in database called comp_web
when user click on the company website link, comp_web will increment by 1.
View Replies
View Related
I'd like to know if it is possible to have a click facility in an email which once pressed forwards the contents of the email to a website
The user who uses this facility is then asked to enter the email address to forward the email. I want to implement such a facility so that I can capture the email address of the one to who the user fowards to
View Replies
View Related
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
View Related
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
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
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 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
I'm doing a gallery and I need to make some thumbnails of the images, but yeah...I don't know how, especially since I can't access the server to install stuff. And to be honest I wouldn't know how to install them in the first place (linux server)
Now...the best solution I've come up with so far is to send a string to another webserver that runs on a decent platform and use asp.not to make the thumbnail and then link it from there...would be a pain in the butt though, so if anyone has some good advice then I'm all ears (even if the advice is to give up, tbh)
View Replies
View Related
I'm pretty new to the whole concept of Server Side programming and am currently developing some important elements for a site I have made with Classic ASP programming. One of the things my employer wants me to develop is a Server Side script that will allow a report in PDF format to be generated online to customers who make use of the tools.
View Replies
View Related
I need to format each row being returned in a recordset as
a hyperlink. One of the fields being returned is the
subject of a message that my hyperlink will show. When
the hyperlink is clicked then the ASP page loads further
message details of that link. Does anyone know how to do
this?
View Replies
View Related
I have the following graph (see atttached file) and was wondering if it would be possible to create this graph by using ASP and how easy it would be. If it is possible could someone give me a few links to sites where I could get some code to start me off.
View Replies
View Related
Is it possible to create a folder using a virtual path? This is for a site on a shared hosting server.
View Replies
View Related
First, how can I get asp to create a table in en existing DB that is an atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58 as the name. Along with this, I need to copy the fields from table temp, into the above DB. Can this be done?
View Replies
View Related
I get a "-2147467259" error (unspecified error) when I try to instantiate an
object on my web page. the object is in registered in the Component
Services and when I test the component manually by a VB app, it works fine.
My web site virtual directory security settings allows me to execute scripts
(if that helps).
View Replies
View Related
I am currently pulling records from my database and exporting them to rtf.
My problem however lies in formatting the data in the rtf. More specifically with putting the data into a table.
Does anyone know how to control the width of a table when generating a rtf?
View Replies
View Related
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
View Replies
View Related
When creating a new profile, I want my ASP page to look at a Social Security Field that is being submitted and compare it to the database to see if that Social Security Number already exists. How can I do this? Can I create a filter in the database itselft?
View Replies
View Related
i have a website and i want to create a hieracial site map e.g.
main
>sub section 1
>>subsection 1 page1
>>subsection 1 page 2
>sub section 2
>>subsection 2 page1
>>subsection 2 page 2
in my database i have 3 tables .. 1st is called tablemain which contains 2 fields the section name and the section id.. 2nd table is called tablesub which which again also contains 2 fields a section name and id .. the 3rd table is called pages and contains 3 fields a maincatid a subcatid and pagecontent field.
my question is how would i query these tables and loop through to create a hieracial structure for a site map.
View Replies
View Related
