Hi,
I have a database with only one table as below:
userurltag(id,userID(string),Url(String),tag(String))
I want to delete users that have less than 3 urls associated with them.
How can I do that?
What is the minimum number of bits needed to represent a single character of encrypted text.
eg, if I wanted to encrypt the letter 'a', how many bits would I require. (assume there are many singly encrypted characters using the same key.)
Am I right in thinking that it would be the size of the key. eg 256 bits?
Hello, is there any way how in this situation insert and update DB with single queries?
$message = 'Hello to all group members';
$userdata = mysql_query("SELECT memberid, membernick FROM members WHERE groupid='$cid'") or die('Error');
while(list($memberid, $membernick) = mysql_fetch_row($userdata)) {
$result1 = mysql_query("INSERT INTO messages VALUES (NULL,'$membernick', '$memberid', '$message')") or die('Error');
$result2 = mysql_query("UPDATE users SET new_messages=new_messages+1, total_messages=total_messages+1 WHERE id='$memberid'") or die('Error');
}
I'm trying to create a single layer perceptron.
If I use the nnet function to create a n-0-1 network (n being the number of inputs), is that equivalent to a perceptron?
The table has data of city and its branchs/atms
CITY TYPE NAME
----------------------------------
agra atm X
agra branch X1
delhi atm X2
agra atm X3
agra atm X4
delhi branch X5
chennai branch X6
The result set expecting is
CITY ATM BRANCH
------------------------------------
agra 3 1
delhi 1 1
chennai 0 1
Whether we can do this in one select statement.
hey dudes,
my first question anyway,
i have made a single user dungeon and am looking to change it in to a multi user dungoen how can i do this by the way im using python to make the sud in to a mud lol
I'm trying to figure out if there is a way to show all datatips for a single lineseries in a Flex 3 linechart. This chart will have multiple lines and the functionality we're looking for is when a user hovers over a line, show all datatips associated with just that series. Any help would be appreciated.
showAllDataTips will not work in this case as it will display all datatips on the chart.
Thanks!
Rich
I have a list of
uids: ['1234','4321','1111']
and I would like to turn this into a single string of:
"uid = '1234' OR uid = '4321' OR uid = '1111'"
What's the most efficient way to do this?
Thanks!
Hello
How can I use the update() method on a single model which I retrieved via Queryset.get() ? It seems like model. Model doesn't have an update() method yet I cannot invoke .save() as I have a pre-save signals which messes things up.
EDIT: An idea would be passing some parameter to the save method and catching it at the pre_save signal, so that I can understand the purpose, how can this be done ?
Thanks
Hi,
Consider the following structure :
Ignore the table user_token.
Now, imagine that you need to get all the roles related to an user, wich may be through it's related groups or directly related to him. In case the same role appears related to a group and the user directly, the role related to the user will prevail over the role given by the group.
Is there any chance this could be done in a single query?
Cheers!
Hello,
this should be pretty simple but I don't get it. How can I draw a single point in .Net? If I use g.DrawLine(Black,0,0,0,0) nothing is drawn and if I use g.DrawLine(Black,0,0,1,0) a line with 2 dots is used. The same happens with g.DrawRectangle. This has me intrigued.
Thanks in advance.
I was wondering how can I validate a single checkbox using PHP and MySQL.
Here is the HTML.
<input type="checkbox" name="privacy_policy" id="privacy_policy" value="yes" />
Is it possible to have multiple models included in a single ModelForm in django? I am trying to create a profile edit form. So I need to include some fields from the User model and the UserProfile model. Currently I am using 2 forms like this
class UserEditForm(ModelForm):
class Meta:
model = User
fields = ("first_name", "last_name")
class UserProfileForm(ModelForm):
class Meta:
model = UserProfile
fields = ("middle_name", "home_phone", "work_phone", "cell_phone")
Is there a way to consolidate these into one form or do I just need to create a form and handle the db loading and saving myself?
I have a Perl script that calls aspnet_compiler.exe to compile a large ASP.NET website. The problem is that it takes very long to run. Is there any way to compile just a single .aspx file from the command line? (I think that would suit the needs of my script) It seems that all aspnet_compiler.exe can do is compile at a directory level.
I'm trying to query a database, and return a set of values. Part of the data i'm trying to return is an insurance premium breakdown.
Is it possible to run a query, that selects multiple fields, then adds then and returns them as a single value?
I've seen SUM() but the examples i've seen show it as adding up the results of an entire field - where as i need it to add specific fields for each row returned.
Any help is much appreciated.
I intend to have multiple Rails apps each for site.com, api.site.com, admin.site.com. All apps will access the same tables from one single MySQL database. Apps and database runs in the same server.
Is there any settings in Rails, ActiveRecord or MySQL that I need to be concerned about for above access scenerio? Thanks
Running: Rails 2.3.5, MySQL 5.0, Nginx, Passenger, RubyEE
Hi all,
I want to know how to work on a single data grid which has tab controls in it.Tabs will be selected depending on the dropdown which is in the header.
Thanks,
Brenda
I am running multiple applications with a single Codeigniter system/ folder using the recommended way on the Codeigniter wiki. Each application runs fine and I can link between apps using absolute URLs.
Is there some way I can use or extend the URL helper class (functions like anchor(), redirect()... etc.) to generate links to controllers across applications. I would like to avoid absolute URLs
Thanks!
Field = "columnName"
value = '2,4'
query = ""&Field&" in("&value&")"
here the query will be : columnName in('2,4')
but i want it to be : columnName in(2,4)
how to remove the single quotes
Please help ASAP
When a GSM modem is receiving voice(i.e., multiple wave files continuously) in the voice path, how will the modem able to identify the completion of a single wave file? Is there any software that could perform this?
I have a subversion repository, where each branch is a separate project. I would like to change this architecture, and to gradually move to mercurial. How can I convert a single branch of a subversion repo into an hg repository.
hg version : 1.01
say you have 3 models : user, hair_color, and eye_color
user hasOne hair_color
user also hasOne eye_color
however
var $hasOne = 'hair_color';
var $hasOne = 'eye_color';
obviously wont work. So how do you implement many hasOne relationships in a single model?
I assume the answer is in the cookbook, Im going over that area now, I suspect it has something to do with passing an array to $hasOne, but no example of doing this.
I'm wanting to use http_build_query to change an array to html tag properties. Problem is, it's changing my single-quoted values into %27. So if I have
http_build_query( array("type"=>"'hidden'", ... ), '', ' ' );
I get
<input type=%27hidden%27 ...>
How can I get around this?
Hi I am trying to merge one single revision using CL in SVN using this command:
svn merge -r 5454 URL
but I am getting the following error
svn: Second revision required
My revision is not the latest revision but buried about 90 revisions from the latest update. Any thoughts on what I am doing wrong?