Search Results

Search found 49727 results on 1990 pages for 'multiple select query'.

Page 370/1990 | < Previous Page | 366 367 368 369 370 371 372 373 374 375 376 377  | Next Page >

• function with multiple arguments

  - by Viral

  hi, how to pass multiple arguments in a single function in objective c? I want to pass 2 integer values and the return value is also integer.

  Read the article

• making multiple c# file for one asp.net page

  - by Nikhil K

  For my project(in asp.net) i wrote near 1000 lines of c# code for one asp.net page.It includes so many functions.The problem is,it is going complicated while i am writing more codes on one page.How can i make multiple c# files for one asp.net page?? I tried by adding new class in VS2008.But calling a function from one file to other is making error(item is not present in current file).How can i do that??

  Read the article

• Converting a selected date from a datetimepicker into my query, along with subtracting a day

  - by MyHeadHurts

  I am currently using this to get yesterdays date, however i need to do something similar where the user will use a javascript datetimepicker in my asp.net page and i will then use the date they select instead of just yesterdays date Declare @dayselection int set @dayselection = CONVERT(int,DateAdd(year, @YearToGet - Year(getdate() + 1), DateAdd(day, DateDiff(day, 1, @dayToGet), 1) , DateAdd(month, DateDiff(month, 0, @monthToGet), 0) ) but it isnt working i keep getting syntax errors I want the day and year functions to stay the same i just need help with the month part. I need to convert the selected date into an int

  Read the article

• doctrine: save 20 users with one sql query?

  - by fayer

  i save a user like this in doctrine: $user = User(); $user->name = 'peter'; $user->save(); is there a way to save 20 users in one sql query? or do i have to loop the above code 20 times hence creating 20 sql queries? thanks

  Read the article

• kohana quotes in query.

  - by peter

  hey, i want to format a date in mysql using DATE_FORMAT(tblnews.datead, '%M %e, %Y, %l:%i%p') i cant seem to get the quotes right , so i keep getting errors. how would you put this in a query?

  Read the article

• How to store multiple values in TSQL Variables

  - by RPS

  I have the following TSQL Statement: SELECT ProductId, OwnerId FROM Product How I can store the ProductId and OwnerId in a TSQL variable and then return it to the calling application?

  Read the article

• Question About SQL Query

  - by Ameer

  I am using the below statement to generate age of a person in Oracle SQL and my question is below. SELECT TO_NUMBER(TO_CHAR(CURRENT_DATE,'YYYY'))-TO_NUMBER(TO_CHAR(BIRTH_DATE,'YYYY')) FROM NAME WHERE NAME_ID =NAME_ID This statement is only correct upto so far that I need a statement which could count months and even days in order to get the age.

  Read the article

• Which database invented the "limit" SQL query syntax?

  - by Howard

  MySQL has a nice feature (although non standard) which allow to query resultsets' limit, offset as SELECT * FROM TABLE LIMIT M, N; Is it created by MySQL? or Postgres?

  Read the article

• mysql query help please

  - by moustafa

  i have forum_topics table and have topics_posts table now i want to select from forum_topics where have no posts from topics_posts can any one give me the one syntax like this selct from * forum_topics where have no rows in topics_posts table

  Read the article

• Can multiple threads modify a dictionary?

  - by Sir Psycho

  In C#, can multiple threads read and write to a Dictionary provided each thread only accesses one element in the dictionary and never accesses another?

  Read the article

• mysql query help in selecting top votes

  - by moustafa

  i have table posts and posts_votes in posts_votes i have id and post_id and vote now i want select from posts where have top votes count in last 1 day using this to set the time from_unixtime(post_date) >= SUBDATE(NOW(),1) thanks in advance

  Read the article

• Clean multiple JTextField

  - by redmarv

  Hi all! I was wondering about how to clean multiple JTextField in a Java applicatio, without setting the text with an empty string for each field. Any suggestions?

  Read the article

• Can multiple wordpress's feed off one database?

  - by ThomasReggi

  I am a template designer and I want to create one wordpress with all generic posts, but I don't want to have to keep logging in and copy & pasteing the same wordpress posts everytime. Can I point multiple WP installs to one database? A harder way would be export a master db and importing it to each install. Before I go crazy and try to hack something together, does anyone have any advise? -Thanks in advance.

  Read the article

• Query for retrieving top two rows from a table in SQL Server

  - by Praveen

  Hi All, I have a table called Employee with EmpID,Salary,Name fields. I want to get top two employees with maximum salary. How can i write this query ?

  Read the article

• MySQL- complex data query in a single statement

  - by yoda

  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!

  Read the article

• Doing a count over a filter query efficiently in django

  - by apple_pie

  Hello, Django newbie here, I need to do a count over a certain filter in a django model. If I do it like so: my_model.objects.filter(...).count() I'm guessing it does the SQL query that retrieves all the rows and only afterwards does the count. To my knowledge it's much more efficient to do the count without retrieving those rows like so "SELECT COUNT(*) FROM ...". Is there a way to do so in django?

  Read the article

• Lookups with multiple values are not showing porperly in sharepoint edit and display custom form

  - by user208628

  HELP! For some reason when I create a custom edit or display form, all the lookup fields are showing in a weird way or not showing any value at all, can someone explain to me how I am suppose to fix that, I know it has something to do where it say select="@value" in the display form. Please help me out. Thank you.

  Read the article

• saving multiple files through xcopy

  - by sushant

  i want to copy multiple files at once through xcopy. is it possible. i mean something like: xcopy file1+file2+file3 destinationfolder any help is appreciated :)

  Read the article

• mysql query timer for .net

  - by acidzombie24

  Is there something i can use to track how long my mysql queries take? perhaps log them if they take a certain amount of time? or track all queries but only hold the longest query time? using this with C# .NET with ASP.NET. I'd like to use this to occasionally check if my queries are getting slow.

  Read the article

• In jquery how can I keep track of multiple ajax request called from one function

  - by binay

  I'm using jquery and in one function I'm calling multiple function which are doing different ajax request for example function contactForm(){ loadCountryList(); loadMyData(); checkUserType(); // doing my stuff } How can I know if all the ajax request are completed so that I start doing my stuff in the end? I don't want to call them one by one to minimize the request time. any suggestion will help me a lot.

  Read the article

• Run multiple copies of an app from Visual Studio

  - by HeavyWave

  How can I run multiple copies of the same app in Debug with Visual Studio? For instance, how do I run app.exe /option1 and app.exe /option2 and still debug both? I know I can run them manually and then attach, but I want an automated solution. I have tried writing a small console app just to run 2 processes, but obviously they are not being run under debugger. Any ideas?

  Read the article

• handling multiple buttons in a form in struts

  - by sarah

  Hi All, I am facing an issue while handling multiple buttons in a form using struts. I have three buttons add,delete and go .I have made forward as hidden and on click of a button i would get the name of the button. The problem is with go button on click of that i want to call a javascript and then call the action and return to the same page .

  Read the article

• PHP ORM's, multiple tables and efficiency

  - by sunwukung

  Let's say I have a data mapper function that aggregates multiple tables and generates an object instance from that data. The mapper has a typical save() method which delegates to update/insert. When the mapper executes save - ideally it isolates object fields that have been modified, thus preventing the code from blanket bombing the database. How would you go about this?

  Read the article

• How to sanitize this particular mysql query ?

  - by justjoe

  i got this SQL query where post_title taken from $_GET $sql = "SELECT ID FROM $wpdb-posts WHERE $wpdb-posts.post_title = '5-desain-web-colourful'"; What is the best way to sanitize this and make it more safe ?

  Read the article

• Skip first entry in Drupal Views Query?

  - by RD

  I've created a view that selects all nodes of type "shoot". But I want it to select all nodes of type "shoot", EXCEPT for the first entry. So, if the normal result is: Node 1 Node 2 Node 3 I want Node 2 Node 3 Node 4 Is that possible?

  Read the article

< Previous Page | 366 367 368 369 370 371 372 373 374 375 376 377  | Next Page >