hi
i have made a small project in asp. here it retrives the image link (the images are stored in a seperate folder and the path is stored in access -in text datatype)from MS-Access database and shows as a link in the browser......
now when i click on this link (in the browser) the image appears in the same browser....but i want this image to open in MS- Paint instead of netscape itself.....is there a way to about this
plzzzzzz...
User Profile
Collapse
-
retrive link in paint
-
hey Jared
i am trying the drop down for some other search.
but before that i need to do one thing.The search that i had done eariler the (synonyms one), now once the results are displayed in the browser i want to have an option for the user to save the result in text format or view result in text format. i have started a new thread for this but i still wanted to ask you hence i wrote in the thread hope you dont mind me repeating... -
open search result in text file
hello
Can any one please help me in the following.....
I making a database with Access and ASP. I have created a search option where I have a text box and a submit button. the result to this search is displayed in the same page.
all i want is a option where user can choose between printing the results in the same page or in a text file....
the result is in tabular form and i want the format to remain if not table it self... -
Jared
thanks I did it through java scripts and its working fine.
nehaLeave a comment:
-
navigating radio buttons to another asp page
hello
can any one please tell how to navigate or redirect radio buttons in a asp page to another asp page by vb script...
i have four radio buttons when one of the them is choosen and submit button is click it should redirect to that perticular page..
thanks
neha -
hey Jared
thanks for the free English tutorials last time.
I thought you understand these small short forms so I was Writting that way. I will make sure to write correct english next time. SORRY
well I am not a computer person. I have to write or make this database for my marks and it is important. So please excuse me for my silly Questions.
in another example as to what i want to do is as follows...Leave a comment:
-
well this is good if i have 1 text and 2 or 3 sumbitts. but if i have 3 textboxes and three submits then......this type of thing is not working......ca n you guide me how to go about.......
nehaLeave a comment:
-
hey thanks a lot the code is working perfectly.....t hankyou again
take care
regards
neha...Leave a comment:
-
sorry line 8, 9 and 10 are not correct.....i was tryin something ven these lines i left as it is and as per line 7 im calling Query String....what u mean is i should call form?????
is this method correct?????? i mean all i want here is to write same kind of code here...
and do i have to close and open SQL connection each time i mean for each button????
neha...Leave a comment:
-
no no no no i think u still didnt understand..... .see here, there is no text box ok... i mean user dont have to type any thing.......now oral, Intravenous, Cutaneous are not fields but it is data of a field named administration
ok to be more clear c i have 2 tables Drug_name n Chemistry.... ok....... Chemistry has a field named as administration (which has the data such as oral, Intravenous, Cutaneous etc.,) each drug...Leave a comment:
-
ok now this is the code.....Code:<HTML> <BODY> <% Actionvar=Request.QueryString("actionvar") strURL = Request.ServerVariables("URL") strSearch = Request.QueryString("search") strseffect = Request.form("seffect") strtgroup = Request.form("tgroup") strmechanism = Request.form("mechanism") btnID = "?"
Leave a comment:
-
hey merseyside....
no i have not solved it........i need 3 diff text box n 3 diff submits in a table form......by clicking a submit it should retrive data of that perticular name (in text box )from the database.....i have tried using it but it works only for the first textbox and sumbit....
now im trying to divert the 2 other submits to other page and excute....but i still have prob.....but yes thanks for been conserned if u...Leave a comment:
-
hey Jared
hmm sorry my Q was not straight.
well along with the search v have been discussing i also want a search that has a drop down menu. when a user selects a menu from the list and click submit it should show the data of that perticular menu. here i dont want to search for a perticular drug but all the drugs having that info should appear.
lets say.....in a list (drop-down) there are oral, skin, intraveneous, etc...Leave a comment:
-
Jared
Thank you so much for your help thanks
well some how i figured out y my strsearch is empty the code for strsearch was written wrong now i am getting exactly what i needed......... .my code is working perfectly well
thank you
but 2 more things
1. can u plz explain me what is - Replace(strSear ch, "'", "''") used for?????? and how is request.QuerySt ring("search")...Leave a comment:
-
hey jared
i tried using the SQl as above and didnot use % with single quotes.......bu t with that the following error is coming
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'Drug_Name.Drug _ID = Chemistry.Drug_ ID AND Drug_Name.Synon yms LIKE %%'.
/MyWeb/mylogin/test3.asp, line 29
also with the sinle Quotes around...Leave a comment:
-
hey Jared
i was trying the codes til now now my code is working withCode:strSQL= "SELECT * FROM Drug_Name, Chemistry WHERE Drug_Name.Drug_ID = Chemistry.Drug_ID AND Drug_Name.Synonyms LIKE '%" & strSearch & "%'"
now im getting information from 2 different tables. but there is still a thing that is it is showing one 1 match per query ie., if i type 'aceta'...Leave a comment:
-
hi Jared,
well i have changed my SQL codes as u told
Code:strSQL= "SELECT * FROM Drug_Name, Chemistry WHERE Drug_Name.Drug_ID = Chemistry.Drug_ID AND Drug_Name.D_name LIKE '%" & strSearch & "%' "
Leave a comment:
-
is my ASP code to retrive data after the SQL query is not correct????? how do i retrive my queried data in a tabular form then?????
nehaLeave a comment:
-
Jared
thanks for the help
i am very much sure that this is not case sensitive... to retrive data from the same table i have used almost the same coding and it worked perfectly alright....
this is the whole code i am using
Code:<HTML> <BODY> <% Actionvar=Request.QueryString("actionvar") strURL = Request.ServerVariables("URL") strSearch = Request.querystring("search")
Leave a comment:
-
hi Jared i have tried your query with changes in name but there is some error comming which i am not able to makeout
the following is the sql i am using:-
Code:strSQL= "SELECT * FROM Drug_Name, Chemistry WHERE Drug_Name.Drug_ID = Chemistry.Drug_ID And Drug_Name.D_Name = '" strSQL = strSQL & request("search") &"' "
...Leave a comment:
No activity results to display
Show More
Leave a comment: