Search Results

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

Page 899/1300 | < Previous Page | 895 896 897 898 899 900 901 902 903 904 905 906  | Next Page >

• Can't create/write to file (Errcode: 22)

  - by magdmartin

  Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost). Here is my SQL statement: SELECT DISTINCT * INTO OUTFILE 'C:\Users\Martin\Downloads\result.csv' FROM provider, location, provider_has_location WHERE provider.idprovider = provider_has_location.provider_idprovider AND location.idLocation = provider_has_location.location_idLocation LIMIT 20 MySQL return the following error: Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22) Thanks for your help.

  Read the article

• What does `?` stand for in SQL?

  - by user295189

  I have this SQL by a programmer: $sql = " INSERT INTO `{$database}`.`table` ( `my_id`, `xType`, `subType`, `recordID`, `textarea` ) VALUES ( {$my_id}, ?xType, ?subType, {$recordID}, ?areaText ) "; My question is why is he using ? before values? How do I see what values are coming in? I did echo and it shows ?xType as ?xType. No values. What does ? stand for in SQL?

  Read the article

• JQuery search page textbox

  - by Geetha

  Hi all, I am creating a search page using asp.net[c#] with jquery. Needs: If we are typing a word in the text box, for each letter it has to display the related word in the database. ex: step 1. w [display: world Whole] step 2: wor[display: World] How to achieve this using jquery Geetha.

  Read the article

• Difference between string comparrison in java

  - by Gandalf StormCrow

  Is there a difference between these ? if(myString.equals("")){ } if(myString.equals(null)){ } if(myString == ""){ } I have a string, I don't know is it empty or has some emtpy spaces I just wan't to stop it to be written in database if it is invalid(if empty or with some blank spaces).

  Read the article

• Generic object comparison diff routine

  - by MicMit

  The question stems from database tables comparison. Let's say we put left row in the instance Left and the right one into instance Right of the same type. And we'got many tables and respective types. How to implement more or less generic routine resulting in a collection of diffs e.g. propertyName , leftValue , rightValue for each such a pair of instances of the same type.

  Read the article

• How to create object of Date("23.03.2010")

  - by Ranjeet

  I have astring directly coming form the database and I am creating object of Date as Date dt=Date("23.03.2010") and it is comin NaN whereas when I use Date dt= Date("03/23/2010") it works fine. Any Idea how I can get this working?.

  Read the article

• PHP - How do i display the first 20 li then have a link to display more (gallery)

  - by Matt Rogers

  I want to display about 20 li on a page with a link at the bottom that says something like 'display more'. This link will then clear the first 20 and display the next 20. How should i go about doing this. (I am creating a gallery) I was thinking about using PHP and MySQL. However for what I am doing I do not really need to store it in a database so is there an easier way of doing it only using html, php or javascript? thanks

  Read the article

• iPhone connect to SQL server

  - by immuner

  Since i am new to iphone and mac dev, which is the suggested way to connect your application to an sql server/sql server express 2005 database (in my case to sync data with sqlite)? Thank you

  Read the article

• How to set up a progress bar

  - by user310850

  I have a php page named import.php. while executing this file a lot of database operation is doing.So i need to show the progress to the user, by using a progres bar.How is it possible using any of these php ajax, javascript, jquery,css, flash... methods

  Read the article

• Many-to-many relationships examples

  - by Tom

  I haven't found any MYSQL many-to-many relationships examples here and in google. What I am looking is to see a very simple example with php+mysql showing database's results. Can anybody write a very simple example?

  Read the article

• How to upload 10 Gb of data to MySQL programmatically without crashing like on PHPMyAdmin?

  - by asksuperuser

  I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes. So is there any script in php or anything that can allow to do so unlike phpmyadmin ?

  Read the article

• manupluation of date in vb

  - by banita

  how can we extract system time in vb and do calculation ie. adding or subtracing time then store change time in oracle database table in earlier format .

  Read the article

• mysql Error no 2003

  - by Bharanikumar

  am i using the wamp, For phpmyadmin Database username is root and no password, and host is localhost i downloaded the mysql query browser from mysql.com , i have downloaded this mysql-gui-tools-noinstall-5.0-r17-win32 , when i try to connect the query browser , it through the error like, what i do now ? where is the step by step sol for my prob..

  Read the article

• PHP Round Minute to nearest Quarter Hour

  - by Rob

  I need to round times down to the nearest quarter hour in PHP. The times are being pulled from a MySQL database from a datetime column and formatted like 2010-03-18 10:50:00. Example: 10:50 needs to be 10:45 1:12 needs to be 1:00 3:28 needs to be 3:15 etc. I'm assuming floor() is involved but not sure how to go about it. Thanks

  Read the article

• What's the best way to make a mobile friendly site?

  - by Frew

  Speaking entirely in technology-free terms, what is the best way to make a mobile friendly site? That is, I want to make a site that will work on a regular computer but also have mobile versions of the pages. Should I rewrite each page? The pages will probably have different functionality, so should I rewrite the backend code? Should it be an effectively different site with the same database?

  Read the article

• how can i add double slash into path in vb.net

  - by testkhan

  i have a path i.e D:\videos\new\video1.mpg and i want to convert it into D:\videos\new\video1.mpg... to add it in mysql database...how can i do that

  Read the article

• Which controller is better for displaying user details in cocos application?

  - by mikw

  I have some details of user in database but i want to display details for particular user.i want to know which controller is better for that can u give me some advice.Thanks in advance.

  Read the article

• what's the best storage for text

  - by maryam

  Hi, I have an application that just only use for show information and search data. and my datatype is text and has larg size. would you please tell me what's the best storage for it. also I don't want to use SQL database. thaks

  Read the article

• Can anyone decipher this for me? PHP (I think)

  - by Josh

  This code is being used to parse email, it's stored as a table in a mySQL database. I believe it's PHP code. What does the (.+) do? /A new order has been successfully placed through(.+)Name:(.+)Company:(.+)Email:(.+)Address 1(.+)Order ID:(.+)Date:(.+)Payment Type:(.+)Order Status:(\s*)Accepted(.*)\n(.+)\$([\d\.]+)\s+X/si Thanks, super-brainiacs!

  Read the article

• Dynamic Date Time Dropdown List

  - by user302720

  At phpro.org and other sites there is a tutorial, "Dynamic Date Time Dropdown List". How does one get the $_POST variables for insertion into a mysql database? Thanks in advance for any and all assistance.

  Read the article

• PHP forms $_GET and $_POST methods

  - by user294705

  After I select the checkbox and press the button, the result data should display in the other page.I need to know the way I do this in php. My querry is working fine in the database and It shows the results.Now I need to display those results in the other page after selecting the first page checkbox and button(relevent to that checkbox).

  Read the article

• Best Way To Store Users Passwords Using PHP?

  - by PeAk

  What is the best way to store users passwords in a MySQL database using PHP. For example, md5 or is there something better? examples would be much appreciated.

  Read the article

• how i can make a sort system depend on Character

  - by moustafa

  i mean i have songs table ok?? i want to make some things like that a | b | c | d click on a select from the database the songs that start by a Character how i can do that by the mysql???

  Read the article

• asp.net mvc get current logged in user id

  - by niao

  Greetings, I have created a custom membership provider to make it possible to authenticate users on my application. How can i retrieve current user id in controller? I need this to get some data from database for this user.

  Read the article

• Is The Transaction Log Truncated When Doing a Backup In Full Recovery Mode?

  - by byte_slave

  Is the database transaction log automatically truncated after we create a backup and the DB is in full recovery mode? Or do we need to make 2 different backups, let's say 1 in full recovery mode and a different one for the log file.

  Read the article

< Previous Page | 895 896 897 898 899 900 901 902 903 904 905 906  | Next Page >