Search Results

Search found 32492 results on 1300 pages for 'reporting database'.

Page 894/1300 | < Previous Page | 890 891 892 893 894 895 896 897 898 899 900 901  | Next Page >

• problem with IN clause in SQL

  - by user179056

  Hello, We have observed that there seems to be a maximum number of ids/variables which one can pass in the IN clause of SQL as comma seperated values. To avoid this we are storing all the ids in a table and doing a SELECT within the IN clause. This however means extra database operations to store and retrieve ids. Is there any other way to use IN without SELECT? regards Sameer

  Read the article

• Can I use anything other than BIGINT as Primary Key data type in SQLite?

  - by weenet

  I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality. However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid). Is there any way around this?

  Read the article

• SQL Delete Query

  - by jerle78

  I need to write an SQL script that selects one record in table1, then does a lookup in the remaining tables in the database. If it doesn't find the record, I need delete the record from table1. Anyone provide some sample script?

  Read the article

• Set given time to 00:00:00 in PHP/MySQL

  - by hypnocode

  Hi, I'm retrieving a date from a MySQL database that shows up like this: '2010-03-09 09:11:30' How can I change the date to '2010-03-09 00:00:00'? I'm using PHP to perform the query. Thanks!

  Read the article

• Can Django be used for non web apps?

  - by Leeks and Leaks

  I noticed in the main Django introductin they show a feature that maps python objects to the database. This doesn't strike me as being mutually exclusive with with development, is there any reason why this can't be used for non web apps? Is it easy to separate out?

  Read the article

• hibernate proxy ..

  - by abc

  load() just returns a proxy by default and database won’t be hit until the proxy is first invoked. what does it mean by proxy exactly here ?

  Read the article

• mysql query fails.It gives me invalid result

  - by user2941349

  I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advance

  Read the article

• iphone programming getting data from remote server

  - by user320023

  HI, I'm new to iphone programming and developing travel application, which retrieve most of it data from remote database. What is the best way to implement this solution? I thought of generating XML files in server side and getting data via XML files to iPhone app and displaying them... Is there better implementation to this, thank you in advance? Waruna.

  Read the article

• Package start and end times

  - by abkl

  Hi , I wanted to know if there is any system variable which is can use to access package execution start and end times. My requirement is that i need to store this in 2 relevant fields in a table in the database. Thank you. Abhi

  Read the article

• How to insert Google Adsense in a single post after the <!--More--> Tag

  - by Bob Cavezza

  I'm using wordpress, and I want to add the adsense javascript tags where the Read More tag goes in a blogpost. It's stored as <!--more--> in the database, but when you use the_content() this is automatically changed before I have the chance to use a str_replace() function. I'm looking to place an adsense tag for each post in the single.php page where the teaser ends. Has anyone been able to do this?

  Read the article

• how to check whether the item in the combo box is selected or not in c#?

  - by zoya

  im having a combo box in which i have to display dates from database...user have to select a date from the combo box to proceed further...but im not able to make the user aware of selecting the item from the combo box first to proceed further...what is the process so that a user can get a message if he has not selected the date from the combo..

  Read the article

• Can I tell sitecrawlers to visit a certain page?

  - by Ace

  Hi there! I have this drupal website that revolves around a document database. By design you can only find these documents by searching the site. But I want all the results to be indexed by Googlebot and other crawlers, so I was thinking, what if I make a page that lists all the documents, and then tell the robots to visit the page to index all my documents..? Is this possible, or is there a better way to do it?

  Read the article

• What values do the walkback array in the SocketException contain?

  - by akhilss

  Recently I have debugging into a problem where a connection to a database server from the application server get reset. I am pretty sure there is no reset being called from either end. But while I was debugging into the problem, while inspecting the SocketException, I found the walkback variable. arg0 SocketException (id=11532) cause SocketException (id=11532) detailMessage "Connection reset" stackTrace null walkback long[50] (id=11618) What do the values in this variable represent?

  Read the article

• <object> pasted into textarea is removed... why?

  - by swt83

  I have a textarea that saves data into a database. For some reason it is removing <object> tags from anything that I paste into it -- none of the other tags are removed, only <object> tags. I've never had this problem before and have done this same thing in times past -- any ideas as to what could cause this? I'm not filtering the data before it's saved to the db at all.

  Read the article

• Validating entered user data

  - by msfanboy

  Hello, this is a general question but I do a desktop application. Should I check for example the firstname exceeding 50 chars or is this a matter of taste? Or should I check for 50 chars because the user could flood my database with 10000000 chars ?

  Read the article

• android : SQL Exception while querying

  - by Ram

  Team, Can you please help me to understand why I m getting the following exception. 05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1 Thanks in advance,

  Read the article

• how to submit a form and show the result in that page

  - by Mac Taylor

  hey guys im using a form in php to submit some information into my database so i used two function to do this but how to show the result in th same page that has the form

  Read the article

• How can I extract a range of lines from a text file on unix?

  - by Adam J. Forster

  I have a ~23000 line sql dump containing several databases worth of data. I need to extract a certain section of this file (i.e. the data for a single database) and place it in a new file. I know both the start and end line numbers of the data that I want. Does anyone know a unix command (or series of commands) to extract all lines from a file between say line 16224 and 16482 and then redirect them into a new file?

  Read the article

• Oracle scheduler job log output

  - by JOTN

  I'm using dbms_scheduler to execute a PL/SQL stored procedure. I would like to be able to have that code create some text logging output and associate it with the run to verify it's working, but I can't find anything to do that in the docs. Is there a facility to do this that I'm missing? This is an 11g database running under Unix. It would be real nice if I could use dbms_output so I could also run it from sqlplus and get output.

  Read the article

• Hibernate OneToOne - how to set null value?

  - by EugeneP

  If I want to save a linked instance as null in a database, what should I do? I cannot simply pass null to obj.setOneToOneAssociatedObject(null) Still, I want to save this link as null (table allows it).

  Read the article

• Is there any Gmail API for Java

  - by chenxgre

  I am trying to crawling google gmail inbox and download messages into the database, is there any gmail java api can best do this job?

  Read the article

• Handling ties when ranking from the highest to the lowest

  - by Undgerman

  I am trying to make a ranking manager for a small project.The totals are stored in the database.I can easily get the max and min using mysql and also arrange the records descending.The problem comes in when there is a tie.I need to show a tie in the form:1,2,3,3,4,5,6,7,7,7,7, etc.The repeated numbers will show the ties.I have been thinking of ways of achieving the above but i need more ideas;mine is seems long and complicated. Can anybody share his/her idea of doing the ties.

  Read the article

• Remove all styles from dynamic label in asp.net

  - by kad1r

  I have a label and I got some text from database. text format like: Windows Server 2008 ...etc But sometimes there are different fonts or something like style. How can I remove all of them quickly? I know I can make it with replace command. But is there any quick way for it?

  Read the article

• query mysql table and fetch rows posted in 3 days

  - by Mac Taylor

  Hey guys how can i query my mysql database and fetch rows which are posted in earlier 3 days i know how to fetch todays's rows but not 3 days ago time will save in my table like this : 2010-01-20 19:17:49 and this is what i know : SELECT id FROM pages WHERE date=now() but i need to show posts in 3days and im looking for a simple and straight solution ,because i know how to do so in long php codes

  Read the article

• Passing data between asp.net pages

  - by user204588

  Hello, I'm wondering the opinion of what is the best way to pass a lot of values between pages. I was thinking of either saving the values to a database, using context.Items[], or Session[]. I'm not sure about what is the best method. I'm passing probably around 40 variables.

  Read the article

< Previous Page | 890 891 892 893 894 895 896 897 898 899 900 901  | Next Page >