Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


Ragini Shukla
Reply Me
2 Answer(s)      6 years ago
Posted in : Java Beginners



Advertisement
View Answers

August 12, 2008 at 2:16 PM


hai...
from where u want to search.....i mean from the whole database or from a particular table in the database?


if u want to search from a particular table...
then use the sql command...

SELECT columnname1,columnname2 FROM tablename WHERE columnname1 LIKE 'name%' order by columnname1.


here columnname1 and columnname2 are the desired columns u want to display...
tablename is your tables name...
name is the user typed name.....
then ORDER BY columnname1...
i here suppose that columnname1 is the column for name in the table .so it will arrange the name in alphabetic order....


hope its enuf...
thanks and regards
prashu



August 12, 2008 at 2:29 PM


hai..
that sql Command will return two columns from the table with all the names start with the user typed name.....

If u want to get the datails of the exact name wat user typed....then go for SELECT (the desired columns u want by using comma as seperator) FROM tablename WHERE the_column_for_name= 'USER_TYPED_NAME' ORDER BY the_column_for_name

thanks and reg/
prashu
prashobvee@gmail.com


Related Tutorials/Questions & Answers:
Reply Me - Java Beginners
Reply Me  Hi, This is not correct url please send me again coorect url
Reply me soon.........
Reply me soon.........  Any body plzz help.....how to get d checked details from previous page to current page and den insert into table
Advertisements
Reply me - Java Beginners
Reply me  Hi Friends, Quest:- Tell em what is the difference between java and php, dotnet Quest:- what is the similar point of php and java... Please tell me its very urgent
Reply Me - Java Beginners
=13c222b87273340cf002bfba4ab9d045. please reply me fast its urgent...Reply Me  Hi All, I want to using query string in my page please write the query string in java script and send me and I have a some link
Reply me - Java Beginners
Reply me  If u r not understood my just posted question plz let me know  Hi Ragini, Please specify your requirements in detail. It would be good for me to provide you the solution if problem is clear. And also
Reply Me - Java Beginners
question then reply me...Reply Me  Hi,.. I have a some fields in one form like security and some more fields this fields maintain the table if user click security
Reply Me - Struts
Reply Me  Hi Friends, I am new in struts please help me How to arrange the folder using oracle 10g database where store web.xml file,jsp file,connection file....etc please let me know its very urgent  
Reply me - Java Beginners
Reply me  Hi, There are one form product_master these fields are prod_id,prod_name,prod_opstock,prod_excise,prod_vat,reorder_level,reorder_qty... in the place of vend_name Please write this code and send me its very urgent
Reply me - Java Beginners
Reply me   Hi, I am using this code for session but i am... then adll data would be displaying. so please tell me what is incorrect my code and i want to use session in each page then please tell me that how can i
Reply Me - Java Beginners
Reply Me  Hi Amardeep I am sending database table name,code and db file please insert this data in this table its very urgent.... My... "code too large for try statement" please help me its very urgent
Reply Me - Java Beginners
Reply Me  Hi, Please Help Me using jsp technologies I have a form click the link and open the popup window main page have already a html... understood my problem then please send me.....  Hi friend, Please
Reply Me - Java Beginners
Reply Me  Hi deepak, your sending web application is good (alphabetical searching dropdown menu) Steps:- 1:-searching is good... will be not displayed. please help me how it is open selection of the user its very urgent
Reply me - Java Beginners
Reply me  Hi,   Hi Ragini please specify main problem. where are problem in your code. Thanks
Reply me - Java Beginners
Reply me  HI I m sending structure of table vend_id,vend_name,vend_address,vend_mobile,vend_panno,vend_phone,vend_creditday,vend_tinno... frnd......... again u didnt give me complete details....such as table name
Reply me - Java Beginners
Reply me  Hi, this code is .java file but i am working in jsp... in the database... if u understood my question then then please send me code oterwise tell me its urgent package services; import java.sql.Connection; import
Reply Me - Java Beginners
Reply Me   Hi I am sending some code please check it and solve this code is only insert into the data base please insert data in the database table and reply me fast...I got two error 1 is catch is without try 2 is try
Reply Me - Java Beginners
Reply Me  Hi, For table I have a two table first is sales transaction and second is sales_line sales_transaction fields are comp_id,vend.... * JSP * Servlets * Struts 1 * Struts 2 or JSF? Please tell me
Reply Me - Java Beginners
Reply Me  Hi, I m working in jsp please any information provide the jsp code.not servlet or any other. I m writing a problem clearly...,if u not understood then please tell me Thanks   
Reply Me - Struts
Reply Me  Hi Friends, Please write the code using form element...because i got error in textbox null value  Hi Soniya Would you please explain, in which technology are you creating page? I promise
Reply Me - Java Beginners
Reply Me  Hi Rajnikant, I know MVC Architecture but how can use this i don't know... please tell me what is the use of this ....and also solve my previous problem.... Thanks   Hello Ragini MVC
reply me - Java Beginners
reply me  Hi, user enter vend_id in text box ten open the addform.jsp In the addform.jsp have two button Update and delete addform.jsp is display with fetching data in all text box I m sending code before 5
Reply Me - Java Beginners
Reply Me  Hi, Details structure Using jsp code I m sending table structure and again sending our problem Steps:- 1:-If user input in name text box like a,then display record related to a not b and c(means
hi see and give me reply as soon as possible
hi see and give me reply as soon as possible  Hi Friend, I got path,but it will again ask path error first i was gave index.jsp.It... be send reply soon. Thanks & Regards, N.Ramesh
reply me its urgent - Java Beginners
reply me its urgent  Hi friends I am facing problem in my application in this type please help me i am using database mysql5.0 version...'@'localhost' (using password: YES)" please tell me what is the error....its
Plz Plz reply Me - JSP-Servlet
Plz Plz reply Me  Respected Sir/madam, I am R.Ragavendran.. Actually I got your coding.. But This code is not enabling the user to click and change the image.. I request you to remember the code which you have provided for me
GUI Interface .Reply me with in hour..Its Urgent - Java Beginners
GUI Interface .Reply me with in hour..Its Urgent  Hi ... Now i am doing project for Voting finger print Authentication .. Can any pls assit me.. I... Existing project... Help me
Plz reply me sir Its urgent - JSP-Servlet
Plz reply me sir Its urgent  Respected Sir/madam, I am R.Ragavendran..Actuaaly,I request you to remember the code which you have provided for me using radio buttons.. You have used the following syntax for checking whether
how to pass string array from action class to jsp page? pls reply me.
how to pass string array from action class to jsp page? pls reply me.  how to pass string array from action class to jsp page? pls reply me.   You can use session.setAttribute() and session.getAttribute() methods
reply must
reply must  is it critical to do a software job based on games(java) i know core java & advanced java basics only please give me answer
reply to the mail
reply to the mail  Hi! which jar file needed to be added? Thanks   Question not clear
Reply - Struts
Reply   Thanks For Nice responce Technologies::--JSP please write the code and send me....when click "add new button" then get the null value...its urgent...  Hi can u explain in details about your project
Reply - Struts
Reply  I am sending some coding please chk and let me know if(act==3) { W=0; while(W< (txtcnt4-1)) { out.println("1st Details... debug... if you understtod my problem then write the code and send me...its very
Reply - Struts
Reply  Hello Friends, please write the code in struts and send me I want to display "Welcome to Struts" please send me code its very urgent... and which file need to be run and compile struts without using database
reply - Java Beginners
reply  Hi friends I have a 255 fields i want to insert data in the table please let me know how to insert data in the database please reply me its very urgent
Reply - JSP-Servlet
... Thanks for your fast reply.. Thanks/Regards, R.Ragavendran..  ... the phone and mobile number validation..... and it worked fine for me
Reply - Java Beginners
Reply  Hi amardeep Thanks for reply i know my code is very large....i am sending database table file please chk sequence and let me know USERCODE NUMBER(10) POSTDATE DATE FORMID VARCHAR2(20) LOCATIONID VARCHAR2(20
hi plzz reply
hi plzz reply  in our program of Java where we r using the concept of abstraction Plz reply i m trying to learn java ...   means in language of coding we r not using abstraction this will be used only for making ideas
reply - Java Beginners
reply  Hi Friends, action *.do please tell me... tell me what is main role of *.do please tell me its urgent.....  HI ragini, Please tell me, what you want to do? if you are using simple
Reply - Java Beginners
Reply  Hi Friends, Thanking for ur continue response I know your giving idea but can u send me the code of this problem just example for 20 data
Reply - Java Beginners
Reply  Hi friend I want to use eclipse in my system then send me url of this I have a jdk1.4, tomcat 4.1 so please tell me which version is support give detail how to install
rEPLY - Java Beginners
rEPLY  hi, This is session code i am calling admin_home1.jsp then data will be not displaying its urgent requirement please send me correction Thanks   Hi friend, To display the session
reply - Java Beginners
a coding and let me know its very urgent.If u not understood then tell me
fast Reply - Java Beginners
fast Reply  Hi Friend I want to passing value one page to another page without using session varible....please help me write the code and send me   Hi friend, For solving the problem visit to : http
reply urgently - Java Beginners
Using abstract class and Interface  when to use abstract class and when to use interface? give me answer with real time scenario?  Hello,When to Use InterfacesTwo Important Differences Between Interfaces and Abstract
Reply - JSP-Servlet
Reply  Dear prashu sir, Actually i dont know where to start the image selection process.. I am really struggling to get through it.. If you get the codings please send it to me at that moment itself.. Because i am
reply - Java Beginners
reply  Hi, I am chk insert query please chk and let me know what is incorrect here i am using insert query please chk this StrSqlColm="Insert into FAFORM24GJMASTER("; StrSqlColm="USERCODE,POSTDATE
Reply - Java Beginners
Reply  Hi, This is the admin_home page i give .html extention then data is not displaying and i give .html extention then all data is displaying so please tell me where is incorrect .:: Riddhi Siddhi General
Java Program(Please reply asap)
Java Program(Please reply asap)  Find out the ways in which numbers can be added to get the same result Example:- 10 1+9=10 1+2+3+4=10 1+9=10
Plz chk it and reply again - Java Beginners
Plz chk it and reply again  Hi Deepak, Thanks for fast reply,your application is good,u write this code for user click the view database... will be slow also. so plz help me for this if u understood my question then plz
 

 

 

DMCA.com