I need to provide the search feature on the companys web site. I have read one of the threads here that this can be accomplished via Google. I can't locate the thread anymore. Is it possible? could you please point me to the right resources?
View Repliesi have a text field that the user can input a keyword to search on. i want it to search two fields in my database: productName and productDetails. can someone tell me the sql i would have to use? I know it would be a mixture of using the WHERE and LIKE commands.
View Replies View RelatedI'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ... heres some code :
I've noticed changes to the forum, for instance... the addition of a "time spent on forums" and user-post "bar" thingiemabob
...And on the front-page I'm presented with a link to "View my warnings"
Which is obsolete, considering that I don't have any warnings (oh, I'm such a little angel!)
Any news or admin care to comment on this?
Where do you think I can get just this feature alone in ASP?I just need this feature and not this whole forum. Any other similar product I can use or try?
View Replies View RelatedI am very new to ASP and I am trying to add an existing script.I have an open source shopping cart and I want to add real time shipping rates from USPS.
I have a username and password for the USPS server,but I am having trouble figuring out where to place it. Also if someone as a script to send and recieve data from the USPS server that would be great.
I have a website which requires login. The login function works fine, but I want to display this message when someone is logged in: "Welcome, Firstname Lastname". Here is the code for login.asp: Code:
View Replies View RelatedI have a login feature but i want to be able to let users from different tables to log in. The data base is Access and the code is from DreamWeaver MX.
The computer recognises that there are two tables. However i get the message:
Microsoft JET Database Engine error '80004005'
The specified field 'userID' could refer to more than one table listed in the FROM clause of your SQL statement.
/members/loginform.asp, line 21
This is the code:
i want to have this feature implemented on a framed page: a two paged frame with:
frame (a) containing a textbox and submit button
frame (b) dispays the url entered in the textbox
i have no idea how i'll program the textbox to accepts urls and open the link in the target frame.
I would like to insert a calendar into a webpage that shows the current date and really needs no updating, fro mthis calendar i would like to select a date from it and have that date inserted into a text field, in all there will be 22 text fields (but for now its probably best to concentrate on one).
The reason being i would like to give the user of the website access to change dates in a table in access. The dates can be calculated from the first date entered into the first text field like so:
All dates will be 7 days apart. Ie if the firsat date is 1/7/04 then make the second 8/7/04 and the third 15/7/04 etc 22 times.
I'm building my ASP pages using dreamweaver 8 and some code that I learned along the way.
Can anyone tell me how can I sort (or order) the records in a table just by clicking on any of the columns?
I have an email program, that I wrote for my newsletter. When I send my emails, I am getting more and more bad emails. Is there a way to have an auto remore feature that will remore the email from my database?
View Replies View Relatedthe database works is it checks over a database and verifies the username & pass with code. Then the user enters the site and there's a seperate table to keep a record of when users log in and log out.
Well basically I'd like to know if and how I could apply a filter using asp code? I'd like to filter out everything but <%Session("name")%> (which displays their username) so that user logged in can view their own records.
I am creating a message board in ASP, and I want to create a login feature where you can view the site without being logged in as a registered user, or you can be logged in and use more features.
What is the best way to go about doing this? Should I use cookies, or should I just try to create a login feature using VBScript and Database values?
how to provide the feature for ploading files from a website? i want sum people to b able to upload their files to my server from website, and I am going to read these files later on for ifferent application. am using ASP and vbscript for my applications.
View Replies View RelatedI was wondering if any one had any advice for adding on an all ASP file-upload feature to a form. To start I only want to upload JPGs to a folder (max 2 per form) and then write the path to these images along with the form information so the images can be displayed later on.
View Replies View RelatedI have a simple add/change/delete feature going on. I have a products table that I'm selling mock products from. I have a column named category, which users either select baseball or basketball from the radio buttons on a form. I can't figure out how to make this work. I'm implying that the code is working, the record is adding to the database, just not the category field, and when I display all the fields out of my database onto a html page the category field is blank. Below is the code I have.
<tr>
<td>Category:</td>
<td>Baseball<input type="radio" name="category" value="baseball">
Basketball<input type="radio" name="category" value="basketball"></td>
</tr>
Then I dim out a strCategory variable and set it equal to the request object "category"
I just wanted to know if anyone can tell me how can I give my website visitors the feature of "FRIENDLY PRINTING" through IE. Code:
View Replies View Relatedi 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 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:
I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
View Replies View Relatedi have a database with 5 tables,
on my web site i have a search bar..
i wana link that search bar to my tables so..
when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
I was wondering if there was a way to search pages using ASP or ASP.NET.
I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?
how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.
View Replies View RelatedI have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
View Replies View RelatedNeed help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah
How to write my code so that even if its not End of record, it will still search my db?
In short : I want the db to be able to search under 2 circumstances : EOF and not EOF
How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.
I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
I'm make a search and I want to limt the results to 10 and have a next button.
View Replies View RelatedWith Index Server I can search web pages stored on our servers. Is there any
way to programmatically search web pages on the web ?
I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.
This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code: