User Profile

Collapse

Profile Sidebar

Collapse
nehashri
nehashri
Last Activity: Jul 3 '07, 03:44 AM
Joined: Jan 9 '07
Location: mumbai
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • nehashri
    started a topic retrive link in paint

    retrive link in paint

    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...
    See more | Go to post

  • 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...
    See more | Go to post

    Leave a comment:


  • nehashri
    started a topic open search result in text file

    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...
    See more | Go to post

  • Jared

    thanks I did it through java scripts and its working fine.

    neha
    See more | Go to post

    Leave 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
    See more | Go to post

  • 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...
    See more | Go to post

    Leave a comment:


  • nehashri
    replied to how to code multiple Submit buttons
    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.......
    neha
    See more | Go to post

    Leave a comment:


  • nehashri
    replied to how to code multiple Submit buttons
    hey thanks a lot the code is working perfectly.....t hankyou again
    take care
    regards
    neha...
    See more | Go to post

    Leave a comment:


  • nehashri
    replied to how to code multiple Submit buttons
    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...
    See more | Go to post

    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...
    See more | Go to post

    Leave a comment:


  • nehashri
    replied to how to code multiple Submit buttons
    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 = "?"
    ...
    See more | Go to post

    Leave a comment:


  • nehashri
    replied to how to code multiple Submit buttons
    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...
    See more | Go to post

    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...
    See more | Go to post

    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")...
    See more | Go to post

    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...
    See more | Go to post

    Leave a comment:


  • hey Jared

    i was trying the codes til now now my code is working with
    Code:
    strSQL= "SELECT * FROM Drug_Name, Chemistry WHERE Drug_Name.Drug_ID = Chemistry.Drug_ID AND Drug_Name.Synonyms LIKE  '%" & strSearch & "%'"
    and few changes with ASP codes too...
    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'...
    See more | Go to post

    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 & "%' "
    but the result is same only empty tables comes and no information.... .what im thinking is that ASP codes is not working over here or SQL query is not taken in to account........ well im sure of...
    See more | Go to post

    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?????
    neha
    See more | Go to post

    Leave 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")
    ...
    See more | Go to post

    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") &"' "
    when i use this code the result is not shown at all
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...