Hi, im trying to sort my transformed output by a element which contains a hex value.
<xsl:sort select="Generation/Sirio/Code" data-type="number"/>
Values are plain old Hex: 00 01 02 ... 0A ... FF but they are getting sorted like that: 0A FF 00 01 02, which indicates the sorting method fails as soon as there are character involved.
How can i work around this?
Thank you very much!
I was trying to add Hindi input in Ckeditor but I did not get that.Then I found indic plugin to language selection from ther you can select language and input text in that language but i dont know how to add that plugin to CKeditor.
Please help on this.
how would i select the following in jquery
<ns:text value="my value" />
i have tried selecting it like so:
1:
var x= $('ns:text').attr('value');
return x;
2:
var x= $('text').attr('value');
return x;
but nothing so far... i don't know if it is possible or not but ...
Thanks
Is it possible to assign php array in MySQL IN() function? for example,
$numbers = array('8001254656','8886953265','88864357445','80021536245');
$sql = mysql_query("SELECT * FROM `number_table` WHERE `number` IN ($numbers)");
Any Ideas?
Thanks,
I have following statement in one of the oracle SP:
OPEN CUR_NUM FOR
SELECT RTRIM(LTRIM(num)) as num
FROM USER WHERE USER_ID = v_user_id;
When the above does not return anything the SP result just has no column name in it. But I'd like the cursor to still have num column with some default value like NOTHING when no data is found.
Is this doable ?
Hey guys, I am just trying to pull all the records from my database who have a rec_date (varchar) stored as m/d/Y and are expired (as in, less than curdate()), and this call isn't giving me what I want:
SELECT member_id, status, DATE_FORMAT(STR_TO_DATE(rec_date, '%m/%d/%Y'), '%Y-%m-%d') AS rec
FROM members WHERE rec_date CURDATE() AND status = '1'
I'm obviously doing something wrong, so can you help?
Thanks.
i am trying to query from a temp table,and i keep getting the message
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.
can somebody tell me wats the problem..is it due to convert..
plz help
The query is
select compid,2, convert(datetime, '01/01/' + CONVERT(char(4),cal_yr) ,101) ,0, Update_dt, th1, th2, th3_pc , Update_id, Update_dt,1
from #tmp_CTF
After choosing 'Range Type:' Table Range and 'Select Range:' Sheet1!Table1
I get the error pop-up 'Import to Windows SharePoint Services list' 'Cannot connect to the server at this time. Your table cannot be published.'
Is there somewhere in my computer I can look at for more information as to what I am doing wrong?
I have some text in Photoshop, which I want to use in the web page as image, to save the special font, which is not supported by the browser.
When I try to copy the text layer to a new document in Photoshop, so that I can save it as a separate image file, the text appears very bold, different from the text in the original file.
p.s.: I copy the text layer using: select layer - right click - duplicate layer - to new document;
How can I do to get the next row in a table?
`image_id` int(11) NOT NULL auto_increment
`image_title` varchar(255) NOT NULL
`image_text` mediumtext NOT NULL
`image_date` datetime NOT NULL
`image_filename` varchar(255) NOT NULL
If the current image is 3 for example and the next one is 7 etc. this won’t work:
$query = mysql_query("SELECT * FROM images WHERE image_id = ".intval($_GET['id']));
echo $_GET['id']+1;
How should I do?
thanks
I have a view in Drupal that filters my content. It brings back 7 rows. All I want to return is the number or results returned(7). Is this possible?
I tried using the View result counter but it returns a number for each results
1
2
3
4
5
6
7
I just need the 7 part.
So in SQL I would do a select count(*)
select @[email protected]('*')
for xml raw,type
Above statement will generate following alert:
Msg 6819, Level 16, State 3, Line 2
The FOR XML clause is not allowed in a ASSIGNMENT statement.
I'm new in C# and earlier I saw the lambda expression is like
(params) = { expression;}
but in LINQ, I saw examples like
IEnumerable customerFirstNames = customers.Select(cust = cust.FirstName);
No brackets.
Are they the same or is there any difference?
Thanks a lot.
Can I do an if inside Where?
or something that allows me to do the checks only if the field is not null (path=null)
SELECT
IF(path IS NOT NULL, concat("/uploads/attachments/",path, "/thumbnails/" , nome), "/uploads/attachments/default/thumbnails/avatar.png") as avatar_mittente
FROM prof_foto
WHERE profilo_id = 15
-- only if path != "/uploads/attachments/default/thumbnails/avatar.png"
AND foto_eliminata = 0 AND foto_profilo = 1
Part of the code:
...where se.DateFrom >= pDateFrom && se.DateTo <= pDateTo select se...
Does not work. There is no any error but the To and From days do not get returned.
How do I query "more than or equal to" and "less than or equal to"?
Thanks :)
This line:
used_emails = [row.email for row
in db.execute(select([halo4.c.email], halo4.c.email!=''))]
Returns:
['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']
I use this to find a match:
if recipient in used_emails:
If it finds a match I need to pull another field (halo4.c.code) from the database in the same row. Any suggestions on how to do this?
I already used some script to implement the shortcuts in my web page
but i was wondering if could be possible to associate some combination not syncronic like Ctrl+X but more like a sequence typing 1..2..3 or any other combination to execute a script...
lets assume this example:
you have a long list with numbers:
you could type 3..5...6, so you can go to the item 356 passing trough the item 3 then 35 then 356
more or less like when you type while selecting a select box
i hope it was clear, id not easy to explain...
I'm creating a simple paste-bin in Ruby on Rails, which will have an expire-feature. With this, people can select a date when the paste will be deleted automatically. How can I implement this? I was thinking of a cronjob, but maybe there is a more platform-independent way, by defining this in the model itself. Can anyone help me? Thanks.
hi all,
i found this to check if file exist. is there a way how to check if record exist first?
php.net
i want to check if record exist first, if exist then do update, else do insert. i do understand how to make a queries for select and insert and i dont have problem with it.
if(record exist) {
update query}
else
{ insert query}
I have used Kendo UI Multiselect control and it is working fine.
But I have one issue now that if I tap on a textbox for selecting different values then the default mobile textbox popup window come up which I want to prevent.
I tried Readonly="true" but that will simply disable the function and not able to select any values from that.
So I want to prevent this input window when I click on a textbox.