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" .
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.
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
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.
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 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 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
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?
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??
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:
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?
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:
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.
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:
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")
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
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?
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)
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.