Contact: Tel: 2726 - New Media Systems, 1st Floor South, Queens Walk '#' is part of the URL. It represents the anchor in the page. Therefore, the browser will not consider anytihng after '#' as the sraech part of your URL. You will have to encode the '#' and then in your servlet decode it before generating your where clause. Cheers, Charles Amar Das <[EMAIL PROTECTED]> on 11/01/2000 03:39:48 PM To: [EMAIL PROTECTED] cc: (bcc: Charles Chen/YellowPages) From: Amar Das <[EMAIL PROTECTED]>, 1 November 2000, 3:39 p.m. How to resolve the # sign [Scanned by Yellow Pages PostMaster] One of my servelet generate the following line based on a query on the database. http://www.stgeorgeconsulting.com:8000/servlet/hossservlet1.TableMeta?tn=SPILL#EMP_BAK The TableMeta servlet takes input table name (tn) and query the database for column names for that table. But due to the presence of '#' sign only the part precedding the # sign goes as table name. So, instead of a where clause as where table_name = 'SPILL#EMP_BAK' I receive a where clause as table_name = 'SPILL'. How can I escape the '#' symbol. Thanks, Amar ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
