SELECT `profiles`.*
FROM `profiles`
INNER JOIN `friendships`
ON `profiles`.id = `friendships`.(CASE WHEN friendships.profile_id = 1
THEN`friend_id` ELSE `profile_id` END)
How can i make the inner join like profile.id = friendships.(here will select the one key that is needed) but it doesnt work. please help :P
it cant be:
`profiles`.id = (CASE WHEN friendships.profile_id = 1
THEN `friendships`.`friend_id` ELSE `friendships`.`profile_id` END)
Is it a bad idea to split up a application and the database?
Application1 uses database1 on ServerX
Application2 uses database2 on ServerY
Both application communicates over web service API, they are apart of the same application,
one application is used to manage user's profile/personal data, while the other application is used to manages user's financial data.
Or should just put them together and just use 1 database on the same server?
I have a .net 4 application that uses a Com Dll to send SMS messages. I used TlbImp to create the interop assembly and that is what is referenced in the application.
When I try to create an instance of this class, it takes a really long time (2-5 seconds).
I ran performance profile in VS 2010 and the call that takes the longest by far is System.Activator.CreateInstance().
I am looking for tips on how to debug or gotchas with using Com Interop.
I am trying send user profile images from a client to the server using ActiveResource.
Is there a gem/plugin that adds Multipart support to ActiveResource?
i want open myspace profile,friendslist and inbox messages from myspace to my website by using myspace api.I registered in deeveloper.myspace and i got applicationkey ,consumer key.I gave callback url also.but i am getting 401 error
Hi,
there is any pastebin-like php open source system without sql? I want to install it on localhost and dont want to backup sql.
edit: Highlighting as much as possible languages (as pastebin.com).
i want to create one facebook application with asp.net
i required login to facebook and required permission for sending email, publish stream and offline access to facebook profile.
Hi,
I'm going to develop a social like network using Ruby on Rails.
For this app I need basic social functionality like friends, activities, authentication, user profile, facebook connect, comments. I searched for rails plugins with social functions and i found - tog and community engine.
So which is better and more easier to extend?
Thanks
I found out that on Android contacts, at least HTC Sense stores Facebook ID with the following mimetype: vnd.android.cursor.item/vnd.facebook.profile this differs from their mimetype format such as com.htc.socialnetwork.facebook/smallavatar
I am wondering where do I find a list of officially supported mimetypes for Android?
I need to build a system which backup and restore system in which all the phone datas
including audio, video, pictures. From iPhone 4.0 , there is support for accessing the videos
and photos from the library . Is there any way to access the music files. I need to convert those music files into binary format . Is there any way to accomplish this...
awaiting for the response
Best Regards,
Mohammed Sadiq.
Hello, this is a weird one, when I run the following code all rows are returned from the db. Imagaine what would happen if this was an update or delete.
Dim cmd As New NpgsqlCommand
cmd.Connection = conn
cmd.CommandText = "select * FROM ac_profiles WHERE profileid = @profileId"
cmd.Parameters.Add("@profile", 58)
Dim dt As DataTable = DataAccess2.DataAccess.sqlQueryDb(cmd)
DataGridView1.DataSource = dt
My question is why is this happening?
I've placed the players in "sites/all/libraries/" but I'm still getting this message when I go to admin/settings/swftools/handling, "FlexPaper - Missing sites/all/libraries/flexpaper/FlexPaperViewer.swf" Anyone having the same issue?
On a side note when I setup the swftools profile and then assign the CCK formater and then goto the page to view the swf I get this message: "No modules have registered the action swf_list. Check any required supporting modules are enabled."
http://drupal.org/node/790506
I have developed a python C-extension that receives data from python and compute some cpu intensive calculations.
It's possible to profile the C-extension?
The problem here is that writing a sample test in C to be profiled would be challenging because the code rely on particular inputs and data structures (generated by python control code).
Do you have any suggestions?
kXML is an alternative XML parser I chose to use for JavaME apps.
The XML file to be editted is inside the mobile app's own JAR.
I'm using CLDC profile.
Please help
Is it possible to pull photos from the Flickr API based on a search term? Not necessarily something from my profile, but from any public photo that matches the search term.
Or is the Flickr API only for pulling your own, or another authenticated users, photos?
Thanks!
I have a client who would like to pull public information about people who "like" some of their web pages or are associated with their Facebook app.
I wanted to do a proof of concept, but we really don't about any particular methodology.
Another option we want to explore is to assume we have captured a Facebook user ID/email. Can we use that to collect public profile information?
i installed and setup all the certificates, provisions , etc. and selected the did what was needed in the project edit page. i have the device in the usb and once i build i get this error.
The iPhone “myname” doesn’t have the provisioning profile with which the application was signed.
i have tried everything, read tutorials and what i can to get this to work. what are some things i can try that you have?
tahnks
how do you configure rotation of syslog log files on ubuntu?
in my /etc/syslog.conf, i have this line:
local1.* /var/log/log.txt
over time, the following backup files have appeared:
/var/log/log.txt.0.gz
/var/log/log.txt.1.gz
how do i configure how often these files get generated, and how to clean them out?
Hi there,
Just built myself a mvvmlight app and if i press f5 TO COMPILE and run all works ok, it displays the wpf window
but if i do a BUILD i get an error
Error 1 The target "RunCodeAnalysis" does not exist in the project.
I am using the visual studio 2010 professional version RTM
The only thing i see strange is the target framework which is set to .NET framework 4 client profile
Anybody know why this happens??
Hi Everyone,
My installshield project uses custom prerequisites to install .Net Framework 4.0 Client Profile and Microsoft Sync Framework 2.0 client package.
I want to let clients to donwload .Net Framework and Sync Framework directly from the Internet so that our installer is small. But I cant see a way to this.
If you could give some advices or example, it would be most appreciated.
Cheers
hi every one
i am iphone developer as standard registered,
i installed SDK4 seed version is fine
and i alos instal ios4 for my ipod touch that is register in apple for development use,
so i used xcode organizer to update my ipodtouch to new ios4 every this was fine and working to upload data , but in middle is crash and didn't work , now my ipod touch is dead is not working at all and i try to restore my ipad from backup i have in itune it didn't work?
so any one has solution for my problem for installing ios4 in my ipodtouch ?
thanks
We need to profile the JDBC operations of several web applications, number of queries, time spent, rows returned, ...
Have you used any free/commercial JDBC profiling tool? What are your experiences?
Thank you.
Hello everybody,
I accidentally changed owner of all files on my plone site to plone, and I don't know how to fix this without reinstalling site, which won't be acceptable.
I have backup version which keeps default owners but it's changed in the meanwhile on the dafault site. Maybe rsync can sync only ownerships between these copies???
Any idea would be precious.
Cheers