I have two tables, I want to search TermID in Table-A through TermID in Table-B and If there is a termID like in Table-A and then want to get result table as shown below. TermIDs are in different length. There is no search pattern to search with "like %" TermIDs in Table-A are part of the TermIDs in Table-B Regards, Table-A ID ...
Hi. I'm currently looking for a way to search a big database (500MB - 10GB or more on 10 tables) with a lot of different fields(nvarchars and bigints). Many of the fields, that should be searched are not in the same table. An example: A search for '5124 Peter' should return all items, that ... have an ID with 5124 in it, have 'Peter'...
This code give me an error: string rus = "," + db_user.Anagrafica_Dipendente.ID_Dipendente + ","; int i = db.CBR_User.Count( p => p.RiceviMail == true && ("," + p.Dipe + ",").Contains(rus)) p.Dipe is a string the error is: Unable to create a constant value of type 'System.Object'. Only primitive types ('such as Int32, String, an...
Hello I would like to know if there is any API feature that can tell me which users liked my application page. I know that it is possible to check if a user is a fan of any given Page using page.isFan verification or to get the number of fans. But is it possible to get the fans' User ID? If so, is it possible to get that data ordered...
I've put facebook like buttons into my wordpress blog... the idea is to use them as kind of a voting mechanism for posts. What I would like to do is automatically add a comment for the blog post everytime someone 'likes' it via the facebook like button. So my question is- does the like button api provide some kind of a callback to my pa...
Hello, I've a SP using a LIKE. Let's simplify it to: SELECT * FROM customers WHERE name LIKE '%' + @query + '%'. I'd like to use it for an (optional) exact match search without altering the SP but with a tricky parameter ;) Is there a way to "cancel" the 2 '%' with a clever @query? Thanks. ...
How can I simulate F11 (fullscreen not maximaze browser window) as with flash: http://www.broculos.net/files/articles/FullscreenFlash/flashFullscreen.html ? in flash: fscommand("fullscreen", true ) permadi.com/tutorial/flash9FullScreen/index.html Thanks ...
I am attempting to use a parametrized LIKE query with Python's Sqlite library as below: self.cursor.execute("select string from stringtable where string like '%?%' and type = ?", (searchstr,type)) but the ? inside of the wildcard is not being evaluated leaving me with this error: "sqlite3.ProgrammingError: Incorrect number of bindings...
I'm having a hard time getting some sql in python to correctly go through MySQLdb. It's pythons string formatting that is killing me. My sql statement is using the LIKE keyword with wildcards. I've tried a number of different things in Python. The problem is once I get one of them working, there's a line of code in MySQLdb that burps on...
I'm using the wordpress plugin from http://www.sociable.es/facebook-wordpress-plugin-3-0/ on my blog, and I try to figure out, how they hide their download till I click the "Like" button on the post. I tried: <fb:fbml version="1.1"> <fb:visible-to-connection>HIDDEN CONTENT</fb:visible-to-connection> </fb:fbml> But it didn't work. Is...
I have multiple tables with different customer names. I am trying to find out how many times the same name is in a table. The challenge here is that someone could have entered the name as "John Smith" or "Smith, John". There are 40,000 rows in each table and over 40 different tables. I am trying to query somehow without knowing the name...
Hey there, I'm trying to add an FBML tab in facebook that includes a like button. I want to ask visitors to click the like button before revealing a form. When they click it, the form would display and then they can complete the form and submit it. Is this possible? Any help would be great. Thanks, Howie ...
Hello, I am displaying news feed on some other website say www.xyz.com using graph api. I have queries about below problems. I would like to give "Like" functionality for each news feed post. W would like to give "Comment" functionality for each news feed post. Can someone assist me how to solve this problem using either graph api o...
hey there, I'm trying to create a page on my site where the Like button should be hidden if the user already likes the page. If I can't hide it, then maybe there's a way to get a callback when the like button is rendered with a user who already likes the page. This way I can hide/reveal the iframe myself. Any clues? Howie ...
I know how to add a Facebook like button for a group or page, but is it possible to add a like button to every product in a web store without having to create a group or page for each product? This was originally asked on StackExchange Web Apps Private Beta here. ...
Hi all, I know this might shock some but I just cant figure out what's wrong with this SQL statement.. it kills my head. SELECT * FROM groups WHERE gname LIKE '%m%'; I am using mysql 5.1.41 ...
I'd like to disable the Comment box that pops up when a user clicks the Facebook (fbml) Like button I've placed on my site. Is this possible to do? I can't find any details in the documentation. ...
Hi, How to support "like friends photos" for Facebook user using Facebook APIs or FQLs? Thanks in advance. Regards, Deepa ...
Hi, Is there a good way to convert Regular Expression into LIKE inside a Function (MSSQL)? The sproc does not get more complicated than this: (country\=)(?<Country>[\w\d]+)(\&sessionid\=)(?<SessionId>.+) The groups will not be used in the LIKE, they are there for another purpose. I would like to use this inside a sproc late like: ...
Hello I'm trying to select only entries in the following format from a varchar field. [any number of zeros][a hyphen or not][any number of numbers] some samples of what I want would be... 000000000007975 000000000-58628 123421423890347 But not 00000--18945489 00000000000012B SELECT Field FROM table WHERE Field LIKE ??? ...