Hi all .... Im working on search function for an app and have built a pretty decent thing go except one thing.
Im using the ~* to match the incoming keywords against several fields, 4 varchar and one text ...... its working BUT Im getting partial words which isnt exactly what I wanted (neat but not right) lets me explain more.
If im searching on the word cat and using this syntax: ~* 'cat' I get back any whole word "cat"...
mangal
Last Activity: Mar 2 '13, 01:54 PM
Joined: Dec 30 '06
Location:
-
Whole word Search in Postgresql
-
Thank you
I will try it. -
How to stop adding/updating duplicate username and email?
Hello,
I am creating a web application in which registrations are open as usual. My doubt is, if some one try to create an account by an email-id like '[email protected]' , at same time other user also try to create account by same emailid '[email protected]' , what will happen in this case? I have added a validation to check the duplicate email-id in the database before insert and update in my script but i am thinking if both request submitted... -
What is the solution of stop submission of form on refresh, I am trying lot of tips and tricks, some of them works but I am not satisfied with them. If you have any clean solution please update.
Regards,
Mangal KumarLeave a comment:
-
Thank you kovik,
I will do more research and update you
Regards,
Mangal KumarLeave a comment:
-
kovik,
It is not working in case of font-weight:bold. I have added one more foreach to handle this;
can be make it one for each by adding one more condition in regular expression:
...Code:$content = '<body><p><span style="font-size:11pt; font-style:italic; color:#221E1F">Mangal.</span></p> <p><span style="font-size:11pt; font-weight:bold; color:#221E1F">Pankaj.</span></p>
Leave a comment:
-
Thanks Kovik,
You really saved my lot of time, i already tried different regular expression but could not make correct one; as i was including nested <span> logic, may be that was the reason;
kovik as you were saying that nested span case is different approach; if you have the logic of nested span then please post that also;
Very-2 thank for your kind help;
Regards,
Mangal Ku...Leave a comment:
-
Hi, anybody know the regular expression for the post, please post, it will help me lot
Megards,
MangalLeave a comment:
-
How to convert span tags in a String?
Hi,
I need of assistance to convert spans having style related bold, ital and underline & color into html bold, underline and/or italicize tags.
Sample Input String:
...Code:<p>In <span style="font-family:'serif', 'Caslon'; font-size:11pt; font-style:italic; color:#221E1F">The Crack in the Cosmic Egg</span> I recounted how, at a gathering of dor mitory mates around a table, <span
No activity results to display
Leave a comment: