i have things that requires processing and rarely changes except with certain events to take advantage of memcached. can i store a serial version of an object in a data field quickly?
I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement:
SELECT CarReserve.ID
FROM CarReserve
INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName
WHERE UserName = @UserName
Unfortunately, I am getting this warning:
Ambiguous column name "UserName"
Can anyone here tell me what is wrong with my statement?
I have a field ,if user enters data it should go and check db if it is present it should redirect to next page.
But here i m not sure whether it is checking the db but mysql query is correct.
$ThirdPartyCategoryName =$_POST['ThirdPartyCategoryName'];
$activate = mysql_query("SELECT * FROM `thirdpartycategorymaster` WHERE `delete` = 'y' ");
if($activate=='y')
{
header("location:catact.php");
}
else
{
//$activate=='NULL';
header("location:tp_home.php");
}
Say I have these tables:
people(id, name),
cars(person_id, car)
and this query:
SELECT c.car
FROM people as p, cars as c
WHERE c.person_id = p.id
AND p.id = 3
I want the c.car column to take its name from the name field in the people table, like this (invalid SQL, just to illustrate):
SELECT c.car AS(SELECT name FROM people WHERE id = 3)
How do I do that?
hi!
i'm new to membership. i have a table named contact, with a field, userId that must get its data from the membership users table. so when a user is created i have to get the userId from membership users table. how can i do that?
thanx in advance
I am uploading a image and want to change the size ( heigth and width) of image (without using plugin) according to the user.
i create two fields in my form - imageWidth and imageHeigth
when user enter the values in certain field, size of the image will be changed according to those values.
please help me.
Thanks and regards.
I want to implement basic spell checking in a Notepad clone project I'm doing. I want to underline misspelled words with a squiggly like like Word does. I think I need to use GDI and draw on the text field, but I'm not sure how to draw on controls.
Thanks
Hi
I have a table with the following structure:
id int(11),
name varchar(250)
I have lots of records in the table but when I am trying to find a particluar record which has the following value on the name field:
Lorem ipsum d\'olor sit amet
The query is simply returning a blank recordset. I am not being able to figure out this weird behaviour, when my query is as simple as follows:
SELECT * FROM slot_games WHERE name='Lorem ipsum d\'olor sit amet'
Would appreciate your help please! Thanks in advance.
Hi all,
I am learning how to use JQuery validation plugin,
I got a simple input text field like this:
<input type="text" name="username">
But I don't know how to use this plugin to do some data availability tasks.
Could you help me please?
SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii
FROM schedule sch
JOIN schools s ON s.ID = 83
WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83)
AND sch.SeasonID = 4
I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need.
I have a textarea that when a users pressed enter/return on their keyboard, I want to submit the field to a JavaScript function, just like it works on Twitter.
Ideas?
Thanks
Hello,
i try to add a generated SPFieldLookup to a List. That works fine, but the Field only added to the default ContentType. How can I add the LookupField to all ContentTypes from the List?
Hi All,
In my application screen, i am having a field, where user can to choose his DateOfBirth.
I want to popup any built-in "Date" calendar or some built-in Date picker to user, so that it will look professional. As i'm new to this development, i wanted to know there is any code sample available to popoup the built-in Date Picker?
Note: I also want to store the selectable Date by user after selecting it in my existing persistent storage.
Thank you for your suggestions.
I mean, won;t it be more specific and appropriate if i "only" keep "protected","internal" and "private" members (field,method,property,event) in a class which is declared as "internal" ?
I have seen this practice ( having "public" members in an "internal" class) in various code so just wanted to know is it a bad practice or does it has some benefit or advantage.
[Only concerned about C#]
Thanks for your interest.
I have a bunch of dimension tables that have unique ID and Name fields. I need a T-SQL function that returns an ID when passed a table name and a value for the name field.
I'm guessing the query would build a little query then execute it? Performance isn't an issue since this is a one time ETL thing.
Hi All,
I have a basic doubt. Internally how are events represented as methods or as (fields)objects. If event is a field then how one can still contain events in the interface definition.
Thanks
JeeZ
hi all
i am new in the field of iphone development ....
i am working on a game in which when user touch on a image then a nib file must be pop up on the scree and i am unable to do that..
please help provide some sample code or any kind of help
thanks in advance
When we have a column that will store a username that will only accept letters and numbers we always do validation on this input field using javascript or even server validation from code .. but i want to know if is there any way that can allow me make this validation on the Table column itself even some one try to enter data from any place it don't accept and throw exception ?
I'm trying to pass in both the field and the value in a find call:
@employee = Employee.find(:all,
:conditions => [ '? = ?', params[:key], params[:value].to_i)
The output is
SELECT * FROM `employees` WHERE ('is_manager' = 1)
Which returns no results, however when I try this directly in mysqsl using the same call without the '' around is_manager, it works fine. How do I convert my params[:key] value to a symbol so that the resulting SQL call looks like:
SELECT * FROM `employees` WHERE (is_manager = 1)
Thanks,
D
How to check in Oracle Function whether value is increasing in particular field for last 3 year or not. Suppose one table is company and if we want to consider only values if profit of past 3 year of company is in increasing manner.
Hello,
I have a strange problem which I can't fix:
A field:
private boolean[][][] gaps;
Constructor (1st line):
gaps = new boolean[NOBARRICADES][WIDTH][HEIGHT];
Constructor (2nd line):
for (int i = 0; i < NOBARRICADES; i++) {
JAVA throws an error for the 2nd line, saying:
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException
Does it have anything to do with JAVA syntax (the mistake is in these lines of code) or I should look for the problem somewhere else?
Hello
I have a problem with "CFDataRef.
I get the "data" field from a "kCFSocketDataCallBack.
"data" should correspond to a string received on the socket.
How do I convert, for example, in a NSString so I can put my text in a textbox??
Thank you very much
static void
AcceptDataCallback(CFSocketRef s,
CFSocketCallBackType type, CFDataRef
address, const void *data, void *info)
{
//my code for the textBox
}
Can any one please let me know the best way to use IF statement in mysql query to show if the "email" field is NULL then it should show as "no email"...
Postcode Telephone Email
----------------------------------------------------------
BS20 0QN 1275373088 no email
BS20 0QN 1275373088 no email
PO9 4HG 023 92474208 [email protected]
SO43 7DS 07801 715200 [email protected]
----------------------------------------------------------
I have an input field that is extending well beyond the rest of the page, but as the question alludes to, it appears fine in iOS.
I am wondering if anyone has run into this issue. My search button, which in iOS is on the right of the search textbox, actually wraps to the next "line" on the other two platforms.
I am not using a table, just inside a div, and the CSS isn't doing anything fancy.
Any ideas?