i 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 RepliesI 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 Replies View RelatedHave a database setup and its main purpose is for images. image libraray. There's a few database tables all linked some how or another. The main one being "tbl_img" where images are linked to a project, owner, and have details about that image etc. Im after creating a simple yet advanced in terms of people selecting and searching search script.
SQL server is used for the tables. Hope i make sense. like a libraray I wish users to search on many or 1 criteria from a few available which can then return results. And examples online would be great. I think i could go about it no problem Im just asking for advise and maybe help speed things up if I see early "mmmmmm, i like the way they did that" .
We have a simple html page that contains a long list of documents that users can hyperlink to. The entries are currently in alphabetical order and we would like to implement some type of page search instead of requiring users to go to Edit, Find, and type in the search.
suspect that this is possible. We would simply like to have a SEARCH box at the top of the page and it allows users to search only the current page for words. We simply want something a little more eloquent than the built in IE page search.
I'm building a simple search page, the database connection is fine, but when I hit the search button. I get this error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/sort_search.asp, line 63
This is the line it's referring to:
Response.Write(" <td>" & RecordSet.Fields("Name") & "</td>")
but I think this is the problme, but I just don't see a problem and the database is fine as well: Code:
I am trying to do a simple text search
The Table I am searching is called 'Items' and the Field I am searching is called 'Item Title'
My search sql string is as follows:
strSQL = "Select * From Items WHERE Item Title LIKE '%var2%'"
However I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Item Title LIKE '%var2%''. /showroom/asp/showroomSearch.asp, line 45
Is this error being caused by the fact that the field I am searching has a space in the name? If not, please can someone tell me where I am going wrong as this code seems correct to me.
I'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"
A system I use uses advanced encryption for passwords. It was taken from some sample script and adapted some where. However this was I think intended to be for passwords. So nothing too long.
However the time has come where I need to create a function to encrypt a large amount of text. It has to encrpt a large amount of text but nothing too advanced is needed to be honest. Just so its unreadable because its written to a text file on drive. It has to be a function though then capable of decrypting the encrypted text.
Any ideas ? Again Dont have to be nothing too flash. I mean I had a go at just changing letters to different letters but the function got huge with all the replaces.
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 have 3 fields like these
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=5.00
and i add them up to get the totalcharge like this
Total_charge=Int(membershipamount) + int(Postage) + int(GiftArticles_Amount)
so i get Total_charge=120.00 which is what i want
but when i have like this
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=3.50
i get Total_charge=118.00
does someone know a good site for asp 3.0 interiew questions
View Replies View RelatedI have only begun to look into ASP due to an assignments requirements.I usually code in PHP,one feature in PHP is to be able to do an if.else statement,where if a certain statement is true then a chunk of HTML can be outputted.
Basically I want to be able to do this in ASP to use with a simple authentication system which I will construct.I have just got a fat book on ASP,and am beginning to read through it
I am not an ASP programmer, but I need help with the syntax. I have a simple if/else statement that I need to translate into ASP. Begin Pseudocode
if
{
(id == 1,2,3,4,5,6),
then print "Private"
}
else
{
Print <a href="https://www.mydomain.com/file.asp?ID=<%=rs("ID")%>" target="_blank">Register</a>
}
End Pseudocode
So how do I say this in ASP?
i'm trying to create just a simple upload - fill in a form with the article
title, and description - and select a file - i need to upload that file to
the webserver, and then rename that file to the <% =Sartid %>.pdf
any ideas where to get something this simple from? never done anything like
this before - i'm guessing the FSO will be used?
This code is working partially fine
<%
sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = Server.CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(sch & "sendusing") = 2
cdoConfig.Fields.Item(sch & "smtpserver") = "mail.aws.no"
cdoConfig.fields.update
Set cdoMessage = Server.CreateObject("CDO.Message")
Set cdoMessage.Configuration = cdoConfig
cdoMessage.From = Request.Form("E-Mail")
cdoMessage.To = Request.Form("sendto")
cdoMessage.Subject = "Tilbakemelding fra nettsiden"
cdoMessage.TextBody = strBody
cdoMessage.Send
Set cdoMessage = Nothing
Set cdoConfig = Nothing
Response.redirect Request.form("resulturl")
%>
Well, this works with only some addresses and not others.
Examples:
bjorn@domain.no
b@2.com
will work...
On the other hand:
bjorn.kaa@domain.no
bjorn-kaa@domain.no
won't work at all...
I need to send data from a 'form' on an HTML page to an ASP page.
The ASP page should 'return' a simple HTML page containing
the data from any items submitted, including any hidden items.
A user logs in, then based on their account (username/pass), they are redirected to a specific web address.
I only need 3 different accounts.
Can this be done with Javascript? Or do I need to use a database?
If you can point me to some script that will achieve this I would love it!
I got a small problem that I think you can solve in a sec.I use ASP to tell day, date, month etc on this page:
http://www.aljapaco.com/award/nyawar...rd&val=purpose
But,as the servers is in Sweden and I´m in Sweden to, I see the text in Swedish.
Can anyone that lives in any other country just please tell me if the text is in English when youre not viewing it from a Swedish connection.
IF it´s still in Swedish, how (if) can I make it change to English text or am I stuck with some messy old Java Script??