Search Results

Search found 24958 results on 999 pages for 'select region'.

Page 575/999 | < Previous Page | 571 572 573 574 575 576 577 578 579 580 581 582  | Next Page >

• LINQ - more than or equal to

  - by trnTash

  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 :)

  Read the article

• How to pass data between controls and persist the values in WPF

  - by randyc

  I am stuck on how to pass data from one control to another. If I have a listbox control and the Contol Item contains a datatemplate which renders out 5 fields ( first name, last name, email, phone and DOB) all of which come from an observable collection. How can I allow the user to select a listbox item and have the valuesbe stored within a new listbox control? Is this done through the creation of a new collection or is there a more simple way to bind these values to a new control? thank you,

  Read the article

• Selecting events from SQL Profiler in 2005 for profiling a query

  - by user279521

  Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped. I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window. Thanks

  Read the article

• Random selection in jQuery

  - by danit

  Im using the following function to hide a series of forms on a page: $('.ask').toggle(function() { $(this).text('-').next('.addtitle').slideDown('fast'); }, function() { $(this).text('+').next('.addtitle').slideUp('fast'); }); There can be anything from 0 to 5 forms on the page all with the class .ask What I want to be able to do is to select one form NOT to hide, so the jQuery needs to hide all put one of the forms on the page randomly. How can I achieve this?

  Read the article

• In Asp.net (c#) i'm not able to catch any exception properly????

  - by Anand

  In Asp.net (c#),i'm not able to catch exception(FileNotFoundException) properly... i don't know the reason..Actually File s not there..But catch statement fails to catch the exception.. here is the code.. try { System.Drawing.Image imgg1 = System.Drawing.Image.FromFile(Server.MapPath("").ToString() + "\\images\\img1.jpg"); } catch (FileNotFoundException) { Response.Write("<script>alert('Please Select and upload Student's Photo');</script>"); }

  Read the article

• how to do reverse fulltext search in MySQL?

  - by Shore

  By default it's like this: select * from main_table where match(col1,col2) against('search_item'); but what I want to fetch is the reverse, say,I've restored all the search_item(1000 records,for example), and I want to see which of them matches a specified row in main_table. Is that doable?

  Read the article

• SQL Server varchar to datetime

  - by Dezigo

  I have a field varchar(14) = 20090226115644 I need convert it to - 2009-02-26 11:56:44 (datetime format) My idea. use cast and convert.. but I always have errors. Conversion failed when converting datetime from character string. I made this, but don`t like it.. SELECT SUBSTRING(move,1,4) + '-' + SUBSTRING(move,5,2) + '-' + SUBSTRING(move,7,2) + ' ' + SUBSTRING(move,9,2) + ':' + SUBSTRING(move,11,2) + ':'+SUBSTRING(move,13,2) as new -- FROM [Test].[dbo].[container_events] where move IS not null Result :2009-02-26 11:56:44

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• asp.net mvc Upload File ajax

  - by Bill White

  Hi ive got an mvc form with a fileupload functionality. Ive got an action that accepts an file and extracts thumbnails from it, after which the user can select the images and then proceed to submit the form. How can post the initial file via ajax, bearing in mind, this is not the final submission on the form and I want to retain user input. ie no postback Thanks

  Read the article

• MySQL - Combine two fields to create a unix timestamp?

  - by Dan

  Hi, I'm trying to retrieve a UNIX timestamp from a query by combining a date and a time field in the table, however it keeps returning as zero. SELECT *, UNIX_TIMESTAMP(startdate starttime) AS start, UNIX_TIMESTAMP(enddate endtime) AS end FROM mytable; Can anyone help me out? Thanks.

  Read the article

• Can I override a query in DJango?

  - by stinkypyper

  I know you can override delete and save methods in DJango models, but can you override a select query somehow to intercept and change a parameter slightly. I have a hashed value I want to check for, and would like to keep the hashing internal to the model.

  Read the article

• Oracle equaivalent of java System.currentTimeMillis()?

  - by Gaurav

  Hi, I want to be able to store the current time in millis in an oracle number field. How do I do this via a query? select systimestamp from dual; returns the actual timestamp. Is there anyway that I can convert this into milliseconds the same way java's System.currentTimeMillis() does?

  Read the article

• 2 Rails Apps, 1 Database (using Heroku)

  - by Paul A.

  I've made 2 apps, App A and App B. App A's sole purpose is to allow users to sign up and App B's purpose is to take select users from App A email them. Since App A & B were created independently & are hosted in 2 separate Heroku instances, how can App B access the users database in App A? Is there a way to push certain relevant rows from App A to App B?

  Read the article

• Help with simple query - why isn't an index being used?

  - by Randy Minder

  I have the following query: SELECT MAX([LastModifiedTime]) FROM Workflow There are approximately 400M rows in the Workflow table. There is an index on the LastModifiedTime column as follows: CREATE NONCLUSTERED INDEX [IX_Workflow_LastModifiedTime] ON [dbo].[Workflow] ( [LastModifiedTime] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) The above query takes 1.5 minutes to execute. Why wouldn't SQL Server use the above index and simply retrieve the last row in the index to get the maximum value? Thanks.

  Read the article

• what is the out put of this code?

  - by user329820

  Hi I want to know that this code will have an out put or it will show an error? thanks CREATE TABLE T1(A INTEGER NULL); SELECT * FROM T1;

  Read the article

• Linq-to-Entities Dynamic sorting

  - by verror

  This is my query, how can I use string as orderby parameter? string sortColumn="Title"; var items = (from ltem in ctxModel.Items where ltem.ItemID == vId orderby //something here select ltem).Skip(PageSize * PageIndex).Take(PageSize);

  Read the article

• round a number in SQL

  - by LIX

  I have a number and I use ROUND() function in SQL : SELECT ROUND(1.81999,2,1) I want the result 1.82, not 1.81. I don't know where my mistake is.

  Read the article

• sql Query Time out error

  - by prakashbhatt

  Hi, I have a table which have 6 million recods,when a fire select query with where condition in that table it is timing out. How can I make it run, Please help

  Read the article

• In JQuery, does the advanced CSS 3 selection style work in all browsers?

  - by SLC

  I'm watching a tutorial learning JQuery for the first time, and it seems you can select items using pretty much CSS, like: $('ul li:nth-child(3)').addClass('biscuits'); Is that kind of selector going to work on all browsers, or just ones that support CSS 3 ?

  Read the article

• Get a list of the last 10 Mondays

  - by Jonesy

  Hi folks, I wanna have a drop down that lets me select "Week Commencing Monday the 20th" going back 10 Mondays but I'm not sure how to go about doing this. I've used date.now(), etc. before but not sure how to do this one. Thanks, Billy

  Read the article

• Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.

  - by sajad

  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

  Read the article

• PHP uploads and checking

  - by user147685

  Hi all, I want to update/insert file by using upload box to the database but before that it will check for the file type thats only pdf can be upload. Somthing wrong with the codes and i dont know what..Please help here are part of my updates codes: $id=$rs['id']; $qry = "SELECT a.faillampiran FROM {$CFG->prefix}ptk_lampiran a, {$CFG->prefix}ptk b WHERE a.ptkid=$id and b.id=$id"; $sql = get_records_sql($qry); if($_POST['check']){ $ext = pathinfo($faillampiran,PATHINFO_EXTENSION); $err = "Upload Only PDF File. "; if ($ext =='pdf'){ $qry="UPDATE {$CFG->prefix}ptk_lampiran SET faillampiran='".$faillampiran."' WHERE ptkid='".$_GET['id']."'"; $sql=mysql_query($qry); $qry = "SELECT a.faillampiran FROM {$CFG->prefix}ptk_lampiran a, {$CFG->prefix}ptk b WHERE b.id = '".$rs[id]."' AND a.ptkid = '".$rs[id]."' "; $sql = get_records_sql($qry); foreach($sql as $rs){ ?> <?=basename($rs->faillampiran); ?><br> <? } ?> <tr><td></td><td></td><td> <input type="file" size="50" name="faillampiran" alt="faillampiran" value= "<?=$faillampiran;?>" /> <input type="submit" name="edit" value="Muat naik fail ini" /><br /> </td></tr> } else { echo "<script>alert('$err')</script>"; } } else { foreach($sql as $rs){ ?> <?=basename($rs->faillampiran); ?><br> <? } ?> <input type="file" size="50" name="faillampiran" alt="faillampiran" value= "<?=$faillampiran;?>" /> <input type="submit" name="edit" value="Muat naik fail ini" /><br /> <?} Sori bout the messiness of the codes, im still a beginner in this languages. thx

  Read the article

• Creating temporary tables in MySQL Stored Procedure

  - by burntblark

  The following procedure gives me an error when I invoke it using the CALL statement: CREATE DEFINER=`user`@`localhost` PROCEDURE `emp_performance`(id VARCHAR(10)) BEGIN DROP TABLE IF EXISTS performance; CREATE TABLE performance AS SELECT time_in, time_out, day FROM attendance WHERE employee_id = id; END The error says "Unknown table 'performance' ". This is my first time actually using stored procedures and I got my sources from Google. I just cant figure out what I am doing wrong.

  Read the article

• How can I find columns which have non-null values?

  - by aartist

  I have many columns in oracle database and some new are added with values. I like to find out which columns have values other than 0 or null. So I am looking for column names for which some sort of useful values exists at least in one row. How do I do this? Update: This sounds very close. How do I modify this to suit my needs? select column_name, nullable, num_distinct, num_nulls from all_tab_columns where table_name = 'SOME_TABLE'

  Read the article

• Modifying MySQL Where Statement Based on Array

  - by Ryan

  Using an array like this: $data = array ( 'host' => 1, 'country' => 'fr', ) I would like to create a MySQL query that uses the values of the array to form its WHERE clause like: SELECT * FROM table WHERE host = 1 and country = 'fr' How can I generate this query string to use with MySQL?

  Read the article

< Previous Page | 571 572 573 574 575 576 577 578 579 580 581 582  | Next Page >