Problem on facebbok like button html : Facebook is showing here That you can add a like button to your site that allows users to also add a comment right after clicking on the "LIKE" button. From some reason, when I try that html on my site, it doesn't work. My site is public and I also got the required META tags inside my html. He...
I cannot get the like statement to work with space and trailing wildcard. My query goes as follows: select * from Table where Field like 'Desc_%' The data is space-delimited such as, Desc Top, Desc Bottom and so on. The query works when I use the pattern 'Desc_%' but not when I use the pattern 'Desc %'. The field is nvarchar(255). A...
I'm trying to write a linq-to-sql query using || that behaves the same way as the OR in SQL when combined with a LIKE/Contains. SQL: SELECT * FROM Users WHERE GroupNumber = 'A123456' OR (FirstName like 'Bob%' AND LastName like 'Smith%') This will result in everyone with a name like "Bob Smith" as well as everyone with a GroupNumber e...
Hello, I am using Oracle SQL and I want to group some different rows that 'like' function results. To elaborate with an example: Let's assume I have a table MESA with one of the columns is a huge string. And I am counting the number of rows matching particular patterns: SELECT m.str, count(*) FROM MESA m WHERE m.str LIKE '%FRUIT%' A...
Hi, i developing an app on facebook and want to get the last date that user of my app liked anything on facebook. it doesn't matter if its a page, post, comment, link or whatever u can like on facebook. is it possible? thanks! ...
I'm using mongodb 1.4. I want query something as SQL's like. For an example in SQL: select * from users where name like '%m%' How to do the same in mongodb? I can't find a operator for like in the document of http://www.mongodb.org/display/DOCS/Advanced+Queries ...
I'm using the MySQLicious type schema described here for a simple tagging system. I've read some alternative implementations of tagging schema in 4 different SO threads, and this suits my needs best. A collection of entries have the tags "apple banana orange" and "strawberry banana lemon", and I'm trying to find the Elixir/SQLAlchemy eq...
I'm running a Rails app on Postgres through Heroku. I'd like to implement similar to Facebook "likes" on my site for various items, such as user comments. What's the smartest way to store these in my database that will be efficient and fast? The obvious one is just to have a like join table between users and items, something like this:...
I have a table of URLs, and I need to find any URLs that contain a keyword, such as "fogbugz" or "amazon". If the keyword appears anywhere in the URL, I'd like it to be a result. Right now, I'm trying: SELECT url FROM url WHERE url LIKE '%keyword%' Which is predictably slow, even when url is indexed. I'm open to alternative metho...
Hello, guys. I have a problem with sql query in php: select user, name, outlet, switch, port, vlan, mac, status from access where user like '%' and name like '%' and outlet like '%' and switch like '%' and port like '%' and vlan like '%' and mac like '%' and status like '%' order by 'user'; When r...
Hi all, I have a table (AmenityData) of data and a column of this table contains postalsectors e.g. E14 7 I also have an Excel spreadsheet with a list of postal districts e.g. E14 I need to get all the data out of the AmenityData table where the postal districts are LIKE the postal sectors e.g. WHERE [PostalDistricts] + '%' LIKE [Post...
How can I implement like button into Flash? Official documentation supports only Javascript solutioon. ...
I have a table Books in my MySQL database which has the columns Title (varchar(255)) and Edition varchar(20)). Example values for these are "Introduction to Microeconomics" and "4". I want to let users search for Books based on Title and Edition. So, for example they could enter "Microeconomics 4" and it would get the proper result. My ...
How to get the number of Likes in facebook like button? Here is my scenario, I have five like buttons, I want to sort the buttons based on the number of likes. Is it possible? ...
Hi all! I've tried in vain to manage how to adapt the Like Button Plugin found at http://developers.facebook.com/docs/reference/plugins/like trying to make it works in do-like action on a picture instead of a page. Can someone kindly tell if is this possible via the Open Graph protocol and metatags to like an album picture published ...
Hi I am doing a project in ASP.NET that at one point searches a SQL database for a postcode using Datasets: string postcode = "%" + searchTerm.Trim().Replace(' ', '%') + "%"; SearchDataSet.SearchCustomerTableDataTable custTable = custAdapter.GetDataCustPostcode(postcode); The GetDataCustPostcode runs: SELECT * FROM CustomerTable WHE...
How to control the facebook like box stream part height alone. Its normal to reduce height of whole box but if tries to control it fans images are not shown. The css .fan_box .page_stream{ ...,width:300px} to .fan_box .page_stream{...,width:150px} i'm asking because the stream box inside iframe ...
Is there a short way to check if a list of strings is %LIKE% a given string? For example: book animal a Would all satisfy this condition for "A Book about Animals"? I know that I could write out Title Like '%book%' AND '%animal%' LIKE Title, etc. but that seems unwieldy. I'm using this for an autocomplete, where I return results whe...
I have one application where admin posts on the wall of one facebook app and same appears in my application (in PHP). We show like button for each of these posts and when any logged in user likes any of them it throws error "exception 'FacebookRestClientException' with message 'User not visible'". However, if user is a fan of app or he i...
Hi, My URL is something like www.example.com/product/?mid=1&pid=B0019DVLN2 If I add this url to the like button it takes only www.example.com/product/?mid=1 and leaves the rest part of the URL. I tried using the facebook lint tool. The problem still didnt get solved. I tried replacing & with & also, but still the problem remains. Tha...