Search Results

Search found 20208 results on 809 pages for 'compiled query'.

Page 561/809 | < Previous Page | 557 558 559 560 561 562 563 564 565 566 567 568  | Next Page >

• "Insufficient resources" error with Access

  - by Alex

  Any idea on what can cause this error, everytime I execute a query? The DB is about 2GB. Thank you.

  Read the article

• distinction between using .text and .value in VBA access

  - by every_answer_gets_a_point

  i am passing the textbox1.text values into a query and sometimes into a string sometimes i say this: dim combor1 as string combor1 = comboReason1.Text how do i know when i should put combor1=comboreason1.value ?? also why do i need to set focus for a control to reference its property? that doesn't make sense to me also when i set combor4 =…

  Read the article

• Access different columns from LINQ resultset

  - by Piyush

  I have a query which returns multiple columns from the database using LINQ var donors = from d2 in db.Donors where d2.Status == "Pending" select new { donorID = d2.donorID, bloodGroup = d2.bloodGroup, contactNo = d2.contactMobile, status = d2.Status }; now I want to display the results in different…

  Read the article

• Signs that a SQL statement is dangerous

  - by Matt

  Hi, I want to develop a function in PHP that checks how dangerous a SQL statement is. When i say dangerous i mean, certain symbols, characters or strings that are used to get data from a database that the user shouldnt see. For example: SELECT * FROM users WHERE userId = '1' can be injected in several ways. Although i clean the params,…

  Read the article

• Retrieve Specific Data/Value From Database 1 Line PHP

  - by Belgin Fish

  Hi, I'm just wondering how I can retrieve a specific value (only 1 thing will be returned) from a database using php. My query is mysql_query("SELECT balance FROM users WHERE username = '". $this->username . "'") I'm just looking for it to retrieve the data from that row so I can save it directory into a variable.

  Read the article

• SQL Server dilemma, performance

  - by Woland

  Hello I am creating app where user can save options witch one is better? to save into user table varchar feeld smthing like ('1,23,4354,34,3') query for this is select * from data where CHARINDEX ( 'L', Providers , 0 ) 0 create other table where user options are and just add rows select * from data where Providers in (select…

  Read the article

• MYSQL - sort a list, how to always have one result at the end?

  - by GSto

  I have a table with just as ID and a value. Let's say this list have 4 items, such as Apple,Banana, Zuchinni, and Other. I want to sort the list alphabetically, but always have 'Other' be the last option. Is there a way to accomplish this using a query?

  Read the article

• Execute PHP file in background

  - by Spyric

  I have some php code, that execute for a very long time. I need to realise next scheme: User enter on some page(page 1) This page starts execution of my large PHP script in background .(Every change is writting to database) We sent every N seconds query to database to get current status of execution. I don't want to use exec…

  Read the article

• Clone XML node PHP

  - by Kemrop

  I want to grab an xml node with its attributes plus all the chilren with their attributes and move them to a different node in the same XML file.I believe cloneNode is the most closest thing i can use.Right? Again to be more specific i am using DOM and Xpath to query the node.

  Read the article

• removing comma from string array

  - by sarah

  Hi, I want to execute a query like select ID from "xyz_DB"."test" where user in ('a','b') so the corresponding code is like String s="("; for(String user:selUsers){ s+= " ' " + user + " ', "; } s+=")"; Select ID from test where userId in s; The following code is forming the value of s as ('a','b',) i…

  Read the article

• Getting all rows from a Table where the column contains only 0

  - by Auro

  I got a little problem i need a sql query that gives all rows back that only contains 0 in it. the column is defined as varchar2(6) the values in the column looks like this: 0 00 00 100 bc00 000000 00000 my first solution would be like this: Oracle: substr('000000' || COLUMN_NAME, -6) = '000000' SQL Server:…

  Read the article

• How to check the existence of a row in SQLite?

  - by fx

  I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?

  Read the article

• Lucene Search for documents that have a particular field?

  - by RP

  Lucene.Net - Is there a way to query for documents that contain a particular field. Lets say some of my documents have a field 'foo' and some do not. I want to find all documents that have the field 'foo' - regardless of what the value of foo is. How do I do this? Is it some sort of TermQuery?

  Read the article

• Prepared statement. Can I miss out parameter?

  - by skydreamerr

  I use queries like "UPDATE MAILSCH.MESSAGE " + "SET IDFOLDER=?, SUBJECT=?, CONTENT=?, CREATIONTIME=?, AD_FROM=?, AD_TO=?, STATUS=? " + "WHERE IDMESSAGE=?"; May I miss out IDFOLDER without changing query?

  Read the article

• LINQ display row numbers

  - by timvaines

  I simply want to include a row number against the returned results of my query. I found the following post that describes what I am trying to achieve but gives me an exception http://vaultofthoughts.net/LINQRowNumberColumn.aspx "An expression tree may not contain an assignment operator" In MS SQL I would just…

  Read the article

• How do I select count() and LIMIT?

  - by alex

  SELECT * FROM ...LIMIT 5, 10 But what if I want the total rows? I don't want to make another query without the limit.

  Read the article

• Get current URL in Python

  - by Alex

  How would i get the current URL with Python, I need to grab the current URL so i can check it for query strings e.g requested_url = "URL_HERE" url = urlparse(requested_url) if url[4]: params = dict([part.split('=') for part in url[4].split('&')]) also this is running in Google App Engine

  Read the article

• Java JFrame Remove from Taskbar

  - by ikurtz

  i did a quick topic look and did not find something similar. my query is how do i prevent a child window appearing on the windows taskbar when it is shown?

  Read the article

• How to enable SQL output to log file with Zend_Db?

  - by Alex N.

  I wonder if this possible with Zend_Db, but I am looking for something like SQL query logging similar to how Hibernate does it, where it shows you what SQL it generates in the log file.

  Read the article

• Create trigger for auto incerment id and default unix datetime

  - by user1804985

  Any one help me to create a trigger for auto increment fld_id and Unix datetime. My table field is fld_id(int),fld_date(number),fld_value(varchar2). My insert query is insert into table (fld_value)values('xxx'); insert into table (fld_value)values('yyy'); I need the table record like this fld_id fld_date…

  Read the article

• does mysql undo changes if you kill thread?

  - by every_answer_gets_a_point

  i ran a delete rows query. it was taking too long so i killed the thread from administration. did it undo the changes to the table/?

  Read the article

• I'm trying to do a solr search such that results are shown if a certain field has ANY value

  - by Akeem

  I'm running a search with a type field. I'd like to show results of a certain type ONLY if two other field have values for them. So in my filter query I thought it would be(type:sometype AND field1:* AND field2:*) but wildcard queries can't start with the *.

  Read the article

• Can you define values in a SQL statement that you can join/union, but are not stored in a table outs

  - by Mervyn

  I'm trying to create a query and need to join against something that I can define values in without creating a table. I'll attempt to describe what I'm trying to do: table1 is joined on field a with table2 (titles for FK in table 1) - Table1 has values outside of what exists in table2 - I want to add an…

  Read the article

• Can I and should I use Eclipselink for non OR database interactions?

  - by Tim

  We are using Eclipselink for ORM, but we have a need for some more lightweight database interactions that are more equivalent to JDBC. My question is whether Eclipselink supports such an idiom and whether there are any advantages of it to straight JDBC. I can see one advantage being consistency and being…

  Read the article

• INSERT 2000 records into SQL Database all at a time from C# .NET code

  - by padmavathi

  We need to INSERT 2000 records into SQL DB from C# .Net code. For this is there any way to INSERT all 2000 records at a time instead of executing the INSERT query for each record. Also how would be the performance impact of doing this? Thanks & Regards Padma

  Read the article

< Previous Page | 557 558 559 560 561 562 563 564 565 566 567 568  | Next Page >