Simple Search
Have 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" .
View Replies
ADVERTISEMENT
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 Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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.
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 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
View Replies
View Related
does someone know a good site for asp 3.0 interiew questions
View Replies
View Related
I 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
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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...
View Replies
View Related
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.
View Replies
View Related
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!
View Replies
View Related
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??
View Replies
View Related
does anyone know of a good place to find code samples for ASP Simple Upload. I can't seem to get to the original site.
What I need to do is upload the file and save the path and some other info into to a database.
View Replies
View Related
I have a stylesheet switcher which store the user style preference in a cookie, however how do I modify the following to use the default stylesheet of “styles.css” if there is no cookie on the users computer? Code:
View Replies
View Related
Ok how do i update based on 2 Where options
i know this is wrong but i don't know how to do it.
strSQL = "UPDATE [Job Contract Assignments] SET currentassignment = 0 WHERE cnum= '" & cnumqs & "' "&" WHERE currentassignment = -1"
SQLconnect.Execute(strSQL)
View Replies
View Related
can someone tell me whats wrong with this code.i applying the style in right way
Code:
<tr style="background-color: #386cae; color: #000000; a:link {color: #000000; font-weight: bold;}
a:visited {color: #ded9dd;} a:hover {color: #000000; font-weight: bold; decoration: underline;}">
View Replies
View Related
i have a shopping cart type system where a user adds items to their cart, and as they are doing this, i have a textbox for the user to enter the quantity of the selected item they want!i want this textbox to be max. 3 characters in length (for asthetic purposes!!) but no matter waht width i make it, it is always displayed much bigger(longer) than i want! So how do i force this
textbox to be no more than 3 characters in length?
View Replies
View Related
I want to display a message if the submit button was pushed on the same page.
<% If Request.form("submit") = "Submit" Then
Response.Write "Your photo was successfully uploaded."
END IF %>
The action of the form is the same page. Code:
View Replies
View Related
I want is to have my asp code test if it is the first time the page has loaded. If so it will need to skip my validation info, if not then run the validation code:
View Replies
View Related
I've agreed to help a friend with a free project and everything was going fine until they got some free web space from another friend. It's running on windows and everything is ASP. I have never been near ASP and I really don't understand much. I use PHP/apache and even then it's only tinkering.I was hoping to find a simple script I could plug in and use as a contact form and one for a mailing list (both form to mail type things). But I can't. I've eventually managed to find a couple but I coulnt'd make any sense of them or get them to work.
View Replies
View Related
I have a form that only has one check box in it for active / inactive. This form is when viewing a member record. My 2 questions are:
How do I get the checkbox into the form showing the state that it is in the database? - I can get a check box to show, but can not get it to show ticked / not ticked according to the database Code:
View Replies
View Related
I have a database (*.mdb), which I can connect to, query on, and return results from in ASP. Now, I want to do some ADDs,UPDATEs,and DELETEs.... but I get errors executing my SQL... What's the trick?
PS My connection (thus far) is this, and works.
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider="Microsoft.Jet.OLEDB.4.0"
Conn.Open Server.MapPath("myDatabase.mdb")
View Replies
View Related
I have this little flash movie on the main page of a website and I want to set the cookie so that when user first enters the site, the flash plays but when the user browses around and goes back to the main page, the flash movie won't repeat again ... kinda like ........ they can only see the movie 1 time when first entering the site but after that they won't be able to see it again unless they clear their cookies from their computer
View Replies
View Related
how can get simpleaspuploader for free.
View Replies
View Related
I am trying to add my numeric fields together to produce a total. Does the following make sense to anyone? Code:
View Replies
View Related
I'm currently creating a site that involves people with very little computational skills, proficient only really in word processing, submiting various technical documents to be uploaded to the website.
Because of the generally well-structured outline of these technical documents, I am going to store them in either a relational database (such as MySQL), or in XML form, or both. However, the problem is that most of these documents all ready exist in MS Word (.doc) format, and the documents to come in the future will also be created using Word by the aforementioned people.
I am going to make a simple, online content management system using either PHP or VB.NET (dosen't really matter to me), and I want these people to be able to upload a Word document, and have my CMS script automatically convert the .doc (or rtf rich-text, whatever's easier) into a simple, straightforward xml, similar to DocBook or something (not like Word 2003's incredibly complicated xml). Does anyone have any recommendations on how to go about doing this?
View Replies
View Related
I need to know the equation to pull back the sheet name of the sheet i am working on in excel ....
View Replies
View Related
I want to do a simple hit counter but my problem is I don't want to open a database everytime there is a hit. (I'm afraid this will give me problems with the server if too many people hit at once.)
I thought of doing it with files but I want others to be able to see the hits without ftp access.anyway to use javascript to call a stored procedure(in this case at least the page won't fail if the db is too busy)
View Replies
View Related
I'm trying to make a loop but can't get it right.I'm trying to loop through a HTML table with one row and five columns and search for a specific value, but since tablecells are not objects I don't understand how to do it.
View Replies
View Related
