Search Results

Search found 66801 results on 2673 pages for 'near real time'.

Page 377/2673 | < Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >

  • make VIEW of SHOW TABLE query

    - by cneeds
    Is there a way to make a VIEW of this SHOW TABLE query? SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table" When I save this as a view (using phpMyAdmin) I get #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"' at line 4 when phpMyAdmin tries to execute this CREATE ALGORITHM = UNDEFINED VIEW `Tables` AS SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"

    Read the article

  • net.sf.json.JSONObject adds backslashes where it's not expected ?

    - by cx42net
    Hi there, I'm loosing my hair trying to figure out why net.sf.json.JSONObject add extra backslash where it shouldn't on my java code : JSONObject obj = new JSONObject (); obj.element ("column_name", "<a href=\"#\" title=\"test\">Test !</a>"); will output : <a href=\"#\" title=\"test\">Test !<\/a> with an extra "\" near <\/a. How can I avoid this behavior ? Thanks for your help !

    Read the article

  • How to insert values using Joins in asp.net stroed procedure?

    - by Samba Siva
    CREATE PROC [dbo].[K_HRM_Insert_VehicleAssign] @vehiclename varchar(50), @empname varchar(50), @updatedby varchar(50), @updatedon datetime as begin insert into K_MasterEmpDetails ME inner join K_HRM_Vehicle_Assign VA on VA.[empname+id] = ME.Firstname +' '+ME.Lastname+' - '+ME.kjlid as ME.Employee (VA.vehiclename,ME.Employee,VA.updatedby,VA.updatedon)values(@vehiclename,@empname, @updatedby,getdate()) end I am getting an error near ME...please help me

    Read the article

  • mysql import script by query instead of bash

    - by vick
    I have a file called script.sql how can I run that file using q mysql query? global $sql; $res = $sql->query("\. /script.sql")or die(mysql_error()); gives: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\. /script.sql' at line 1

    Read the article

  • Embedded programming books

    - by Velho Kerho
    What embedded programming/design books would you suggest? With embedded I mean near to hardware programming in ASM and C/C++. I'm looking something related to best practices in embedded programming/design. Operation system could be Linux, Real Time Linux or any other RTOS.

    Read the article

  • What's wrong with this UPDATE FROM using a case statement?

    - by Blankman
    update p set p.storePrice = CASE WHEN p.costPrice BETWEEN 0.00 AND 1.00 THEN p.costPrice * 1.0 CASE WHEN p.costPrice BETWEEN 0.00 AND 1.00 THEN p.costPrice * 1.0 ELSE p.msrpPrice END FROM product p WHERE p.type = 1 The error says: Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the keyword 'CASE'. I can't seem to see any issue with the sql?

    Read the article

  • Add a file in a folder with bash

    - by CuriousGeorge
    I have figured out how to remove bad files in my folders but I am wanting to know how to add certain named files to that folder. I want to add something like address.xml I have this and can remove the bad files. for addxml in $(find $DIRECTORY/$directoryname -name address.xml); do rm -v $addxml done I am trying to learn how later down the code I can add a file from another folder no where near the folders that are being edited.

    Read the article

  • MySql Alter Syntax error with mulitple FK

    - by acidzombie24
    If i do the first one i have no problem. When i do addition i get a syntax error. What is wrong with the syntax? The error says syntax error near [entire 2nd line] alter table `ban_Status` add FOREIGN KEY (`banned_user`) REFERENCES `user_data`(`id`) alter table `ban_Status` add FOREIGN KEY (`banned_user`) REFERENCES `user_data`(`id`), FOREIGN KEY (`banning_user`) REFERENCES `user_data`(`id`), FOREIGN KEY (`unban_user`) REFERENCES `user_data`(`id`)

    Read the article

  • How to display complex object in debugger?

    - by 4thSpace
    I'd like to display the contents of the property myarray, from the following singleton: [Session sharedManager].myarray I've tried these: po [Session sharedManager]. myarray po [[Session sharedManager] myarray] but always get this error: A syntax error near end of expression. Any suggestions?

    Read the article

  • how to get started with TopCoder to update/develop algorithm skills ?

    - by KaluSingh Gabbar
    at workplace, the work I do is hardly near to challenging and doing that I think I might be loosing the skills to look at a completely new problem and think about different ideas to solve it. A friend suggested TopCoder.com to me, but looking at the overwhelming number of problems I can not decide how to get started? what I want is to sharpen my techniques ( not particular language or framework ).

    Read the article

  • When is `x IS NOT NULL` not the same as `NOT(x IS NULL)`

    - by Mark Hurd
    For what x is The expression x IS NOT NULL is not equal to NOT(x IS NULL), as is the case in 2VL (quote from this answer, which is quoting Fabian Pascal Practical Issues in Database Management - A Reference for the Thinking Practitioner -- near the end of that answer) My guess is when x IS NULL is NULL, but I cannot guess when that would be (i.e. I haven't checked the SQL standard).

    Read the article

  • International Zip Code Search

    - by Dave
    I implemented a U.S. "find near zip code" search for somebody. The coordinates of U.S. zip codes come from a commercial zip code database. Now, they would like a similar ability for countries other than the U.S. Has anybody implemented something like this for non-U.S. searches? How about general "find close to this address" searches? What commercial data is available?

    Read the article

  • insert ... select with divide operator in select errors?

    - by Mark
    Hi, the following query CREATE TABLE IF NOT EXISTS XY ( x INT NOT NULL , y FLOAT NULL , PRIMARY KEY(x) ) INSERT INTO XY (x,y) (select 1 as x ,(1/7) as y); errors with Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO XY (x,y) (select 1 as x ,(1/7) as y)' at line 7 Line 1, column 1 any ideas?

    Read the article

  • how to solve syntax error in procedure in mysql?

    - by Shooter
    Hi all, i am executing a procedure in mysql, procedure is- delimiter $$ create procedure getFacility (in id int, out MyFacility VARCHAR(200)) begin select Facility into MyFacility from facilities where FacilityID = id ; end $$ delimiter ; and it is giving error below- Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end $$ delimiter' at line 1 (0 ms taken) how to solve this error? Thanks, Yugal

    Read the article

  • How to make the swf load after all the images and text loaded?

    - by Jay
    My CMS system allow people to post some swf on the homepage, however, sometime there is video which is included in swf, not two files swf+flv. When the swf video load, it near used up the bandwidth and so the page seems not response for a while ... Can I use jQuery to control all the swf in a page that they load after the others done or maybe just load it after 3s or what? Thanks!!

    Read the article

  • How can I highlight an image on an iPhone?

    - by cometcomet
    I have a photo displayed on an iPhone. I would like to lower brightness of the photo at first, and when the user touches the photo, I would like to raise the brightness of the rectangular region near where the user touched, like this: www.cottagearts.net/tut_images/tut_cropping_pse_06.jpg Could anyone point me to a simple way of doing this?

    Read the article

< Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >