Hi,
I have a mySql database i want to display only 10 words from its body field which contain html codes, How i can do that, is there any php function to do that.
can anyone plz provide me a simple working code snippet of codeigniter for uploading 2 images at once (through 2 different input field ofcourse). I need 2 images to be uploaded at once, or one after another. and both of the images need to be in different location.
I tried to make it myself by calling upload function twice but it returned last images with these extentions: *.jpg.jpg.
can anyone help
I've been learning a little of C++ and Java but my main field of interest is gaming and i would like to write code for making my own 3D Games to complement my artistic expertise
Hi
In my mode I am selecting a field as
$query1 = $this->db->query("SELECT dPassword
FROM tbl_login
WHERE dEmailID='[email protected]'");
How to return dpassword as a variable to my controller
I tried this way return dpassword;
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?
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.
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?
Hello,
I have a datetime field in mysql table and i am using JPA for persisting data but only date goes in database. Time always shows 00:00:00. What should i do?
I am not doing any manipulation with Date. All i do is to assign new Date() to a variable and store it in database.
What am i doing wrong?
Hi
I have a stored procedure that declares a input parameter
@BatchNumber uniqueidentifier
This field in the table is set to not allow nullables.
When I drag in the stored procedure and it hooks everything up it says the parameter is nullable.
I don't understand why. Is this normal for it to think that the parameters are nullable?
Hi,
sfGuardUser model of sfDoctrineGuardPlugin is defined this way:
sfGuardUser:
actAs: [Timestampable]
columns:
id:
type: integer(4)
primary: true
autoincrement: true
username:
type: string(128)
notnull: true
unique: true
As you can see 'username' has the feature "notnull:true". Now i want
to create a register form that is not using 'username' but the email
address of the user.
When a user wants to register, it is showed this:
Validation failed in class sfGuardUser
1 field had validation error:
* 1 validator failed on username (notnull)
Any idea?
Javi
I have the following code:
(function(jQuery){
jQuery.fn.timepicker = function(){
return this.each(function(){
jQuery(this).val("14:00");
});
};
})(jQuery);
Currently I invoke this function by the following code: $("#event_start_time").timepicker();
Where #event_start_time is the ID of an <input> field.
How can I invoke this code only when I click inside the text box?
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");
}
*I have a varchar(1000) column declared as field that contains all numbers, as shown below.
And I want to execute the following script. I need this to work please
Declare @PostalCode varchar(1000)=0
set @PostalCode ='7005036,7004168,7002314,7001188,6998955'
Select hl.* From CountryLocation cl
INNER JOIN refPostalCodes pc ON pc.PostalCode = hl.PostalCode
where pc.Postalcode in (@PostalCode) and pc.notDeleted = 1
Hi
I have a header field of 2 bytes where first four bits are packet type and other 12 bits are for length. but i don't know how to store this values and retrieve them.
I am using ms c++ for client and java for server. It is the client which has to set this values and server has to retrieve it.
Thanks
I have a text field that I'd like to support an arbitrary amount of text in. Right now the text is sent through an XML object request using GET. I'd like to use POST to send the data back to the server. Are there any good options in ActionScript 1?
i have a string like this
something = "something, something1, "something2, something else", something3"
i need it to be read into a table like this:
field1 = "something"
field2= "something2"
field3 = "something2, something else"
field4 = "something3"
please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field
anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql.
thanks!
I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique)
create table if not exists misc_info (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
key TEXT UNIQUE NOT NULL,
value TEXT NOT NULL)ENGINE=INNODB;
i have date in dd/mm/yyyy format. how can i store it in databse, if i fant to do some operations on them after?
for example i must find out the rows, where date > something
what type i must set to date field?
thanks
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?
JSF is setting the ID of an input field to search_form:expression. I need to specify some styling on that element, but that colon looks like the beginning of a pseudo-element to the browser so it gets marked invalid and ignored. Is there anyway to escape the colon or something?
input#search_form:expression {
///...
}
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
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
}
Is it possible to define a current user?
I found a stored procedure 'sp_mgGetConnectedUsers'. It returns a result set with the only unique field 'Address'. How could I associate an executing query with such 'Address'.
Please advice.
Note: As far as I understand, another way to get the current user is to set a unique application Id for each connection, but I don't like this way much.
i am doing conditional formatting on a report in access
i need to check if a certain string exists in a field as the condition in conditional formatting. something like this:
[field_name] like '%something%'
will this kind of condition work?