Search Results

Search found 21336 results on 854 pages for 'db api'.

Page 528/854 | < Previous Page | 524 525 526 527 528 529 530 531 532 533 534 535  | Next Page >

• Concate String In MYSQL

  - by streetparade

  How can i concate this string in mysql desc=desc+$desct what i want is each time i insert a variable from PHP that the string is added to the string which was already in db and seperated with || the field desc should look like this desc 10||30||90||710 say i want to add the value 20 desc 10||30||90||710||20 then the desc field should look like this How can i implement this?

  Read the article

• How are get and set methods on javabeans called by frameworks?

  - by testymctesttesttest

  If you have a bean with a getFoo method, how does whatever framework you're using know how to call the getFoo method when you ask for the value of foo? Is this done using the reflection API? Or is it somehow done using annotations? Obviously I know how you can derive the method given the name of the property, I just don't know how the method is invoked.

  Read the article

• How to sort it!?

  - by user334269

  The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!? sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 199 211 page_step 211 207 link 218 559 page_step 559 199 page_step Result: sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 218 559 page_step 559 199 page_step 199 211 page_step 211 207 link 000 197 198 218 559 199 199 211 207

  Read the article

• Case Statements versus coded if statements

  - by Eric

  What is more efficient - handling with case statements in sql or handling the same data using if statements in code. I'm asking because my colleague has a huge query that has many case statements. I advised her to take stress off of the DB by coding the case statements. I've found that it is more efficient...but why?

  Read the article

• python+gae compatible web ui toolkit with ajax but degrades gracefully when there is no js?

  - by lankerisms

  I am searching for a web toolkit that is Python compatible social/db/wiki like google-appengine compatible has built in pagination handles 'relationships' between entities uses ajax modal dialogs but degrades very gracefully on browsers that dont have js good ui decisions that make it gracefully degrade even on mobile, text and braille/speech interfaces.

  Read the article

• Factory(:user) hits database?

  - by davidegp

  Playing around with factories, which I read weren't supposed to hit the database, allowing you to avoid having your controller specs interacting with the DB. But when I fire up the Rails console in test and use a factory to create a sample user, I noticed an actual user gets created in the database. Huh? (Using Rails 2.3.8 and Factory Girl 1.2.3.)

  Read the article

• How to represent "ALL" in Primary Key -foreign Key relationship.

  - by Rohit

  I have to create a db design to store blacklisted fax numbers. I have created a table and one column of this table is customerID which is a foreign key to table Customer. Now i want to have a faxnumber which is blacklisted for all customers. How should i proceed with this. Should i use Null in this case. Please provide options

  Read the article

• Detect Internet V. local lan connection.

  - by MattR

  Is there anyway with Windows api to detect whether a Windows 7 computer's network connection is an internet connection or a LAN connection without internet access? Windows 7 and Vista indicate this in the network icon (Local only v. Local and Internet), is there anyway to grab that information progammatically?

  Read the article

• Where can I get SQL for default Oracle's "HR" schema?

  - by Dmitry

  I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

  Read the article

• TSQL to combine a date field and a time field

  - by justSteve

  Using logparser to import IIS logs to a db results in one column that has the date value and a second field for time: 2010-05-25 00:00:00.000 2010-01-01 11:11:58.000 I'd like to code an INSERT AFTER trigger that combines the 2 fields.

  Read the article

• How to find out if a Java ResultSet obtained is empty?

  - by Bruce

  Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from table WHERE is_query_processed = 0;"); How can I find out if rs is empty?

  Read the article

• Android Full Text Search

  - by Eduardo

  Does Android come with a way to do Full Text Search? I know is it not even possible to search contacts by the notes field, being Google the search company, but I would be disappointed if there is no API for that.

  Read the article

• parsing non-strict json, one in which keys are not enclosed in quotes, with Java

  - by Nishan

  I am trying to parse a string which in JSON format only that keys are not enclosed in quotes. I can very well parse this string in Javascript, but can not find a Java API which will help me parse this. All the APIs I tried assumes strict JSON format. Can anyone suggest a library which has an option to parse this, or a whole new approach to the problem (say like use regex instead) ?

  Read the article

• Save all file names in a directory to a vector

  - by Bobby

  I need to save all ".xml" file names in a directory to a vector. To make a long story short, I cannot use the dirent API. It seems as if C++ does not have any concept of "directories". Once I have the filenames in a vector, I can iterate through and "fopen" these files. Is there an easy way to get these filenames at runtime?

  Read the article

• What trace flags are needed for detecting deadlocks

  - by AngryHacker

  I am trying to get better information on deadlocks that are occurring in my DB. After reading this article, it's still unclear to me whether I should be using trace flag 1204, 1222 or both.

  Read the article

• How important is it for me to pool my connections?

  - by Rio Mango

  It has been suggested to me that I rearrange my code to "pool" my ADO connections. On each web page I would open one connection and keep using the same open connection. But someone else told me that was important 10 years ago but is not so important now. If I make, let's say, 5 db calls on a web posting, is it problematic to be using 5 separate connections that I open/close?

  Read the article

• Sync Framework - calling Synchronize only when connection exists?

  - by kamilo

  Hello, How can I call Synchronize method on an agent but only when connection to remote db exists? I'm very new to sync framework so forgive me my ignorance. Thanks in advance :)

  Read the article

• Hibernate query cache automatically refreshed on external update?

  - by artgon

  I'm creating a service that has read-only access to the database. I have a query cache and a second level cache enabled (READ_ONLY mode) in Hibernate to speed up the service, as the tables being accessed change rarely. My question is, if someone goes into the DB and changes the tables manually (i.e. outside of Hibernate), does the cache recognize automatically that it needs to be cleared? Is there a time limit on the cache?

  Read the article

• Hibernate - how to create list of pojos?

  - by AspNewbie

  I am very new to Hibernate. I have MySQL database and mapped pojos. What should I do next? I know little bit LINQ to SQL from .NET, and it generates me List of mapped objects. So basically, what are my next steps after creating POJOS if I want to have List of them and do CRUD operations upon them and data will be also saved in DB not only in java objects ? kthx

  Read the article

• Java - Converting a datetime into gregorian calender time(date)

  - by yogsma

  I am using google data api which gives date in datetime format. I want to convert in Gregorian calendar date format. Does anyone know any methods for doing this?

  Read the article

• How to stop Native video player in Blackberry?

  - by Rajapandian

  Hi, I created one blackberry application which will play a video on a button click.This is my code, invocation=new Invocation("file:///SDCard/Blackberry/videos/PlayingVideo/funny.mp4"); registry=Registry.getRegistry("net.rim.device.api.content.BlackBerryContentHandler"); try { registry.invoke(invocation); } catch(Exception e) { } Now i can play the Video file.After clicking the Back button the native player is going to the background.It always running in the background.But i want to close that player.I have no idea about how to do it.Anybody knows please help me.

  Read the article

• how to handle redirect from http response in c# code ?

  - by dotnetcoder

  I have a http request call that return a url . If I run this url in IE it returns a page that redirects to a another page and downloads the excel file. How can I abstract this whole process in a c# Api tha will deal with http request + response + redirect + file_downlaod in a method and evetually return the file or the file stream. thanks for the help.

  Read the article

• Customer count map (Google maps?)

  - by David Hamilton

  I have a two column list consisting of a US zipcode and a count (number of customers in this case). I want to put this data onto a map. Would Google maps API be a good fit for this? It seems like this would be a common enough type of problem to already have an existing (preferably Java based) solution without having to re-invent the wheel. Any suggestions?

  Read the article

• How do I keep connection in object explorer

  - by dotnet-practitioner

  This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments?

  Read the article

• SQL commands generated in Django by running sqlall

  - by k-g-f

  In my Django app, I just ran $ python manage.py sqlall and I see a lot of SQL statements that look like this, when describing FK relationships: ALTER TABLE `app1_model1` ADD CONSTRAINT model2_id_refs_id_728de91f FOREIGN KEY (`model2_id`) REFERENCES `app1_model2` (`id`); Where does "7218de91f" come from? I would like to know because I'd like to manually write SQL statements to accompany models changes in the app so that my db's can be kept up to date.

  Read the article

< Previous Page | 524 525 526 527 528 529 530 531 532 533 534 535  | Next Page >