Search Results

Search found 8893 results on 356 pages for 'stored'.

Page 150/356 | < Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >

• Using MySQL variables in a query

  - by Jon Tackabury

  I am trying to use this MySQL query: SET @a:=0; UPDATE tbl SET sortId=@a:=@a+1 ORDER BY sortId; Unfortunately I get this error: "Parameter '@a' must be defined" Is it possible to batch commands into 1 query like this, or do I need to create a stored procedure for this?

  Read the article

• Make a final call to the Database when user leaves website (ASPX)?

  - by Jisaak

  I have a system set up to lock certain content in a database table so only one user can edit that content at a time. Easy enough and that part is working fine. But now I'm at a road block of how to send a request to "unlock" the content. I have the stored procedure to unlock the content, but how/where would I call it when the user just closes their browser?

  Read the article

• Return a result in the original page.

  - by Josh

  When the user submit his data, I take him to a different page where plenty of calculations are made, then I redirect him to the original page with a simple : <?php header("Location:http://mysite.com/index.php"); The problem is I need all the variables and results to be show in this page, but they are obviously stored in the other one, so I need your help please :) ! Thank you for reading this !

  Read the article

• SQL results operation question

  - by wali

  I know I missasked the question, and that's probably the reason I can't find the solution myself: How do I take a result in a stored procedure and and change the data such as if column1 = AAA then column1=Hello else if column1 = BBB then column1 = goodbye and have the data return with the new values? Thanks

  Read the article

• fastest way to upload an xls file into a database

  - by shmichael

  I have an xls file with ~60 sheets of data. I would like to move them into a database (postgres) such that each sheet's data is stored in a different table. What is the fastest way of creating these tables? I don't care about naming or proper typing of columns. The columns could all be strings for that matter. I don't want to run 60 different csv uploads.

  Read the article

• How to use a varying database?

  - by nimo

  I want to use a database which name is stored in a variable. How do I do this? I first thought this would work but it doesn't: exec('use '+@db) That will not change database context Suggestions anyone?

  Read the article

• Understanding this prolog implementation of head

  - by dmindreader

  head([Y],Y):-!. head([X|XS],X). I understand that the head of the list is stored on the variable X. What does the first clause mean? Is it a cut? Why?

  Read the article

• How does Python store lists internally?

  - by Mike Cooper

  How are lists in python stored internally? Is it an array? A linked list? Something else? Or does the interpreter guess at the right structure for each instance based on length, etc. If the question is implementation dependent, what about the classic CPython?

  Read the article

• Storing SMTP credentials for a VB.Net application

  - by Jonesy

  Hi folk, I've been storing SQL connection strings in web.conf which is fine but now I need to store SMTP credentials somewhere protected. web.conf seems like the likeliest place since its protected but how can they be stored? -- Jonesy

  Read the article

• GDB disas question about address values

  - by user324994

  I'm working with a binary file that I disas'd in gdb. Right now I'm just examining the return value of a function. 0x08048604 <playGame+78>: ret Is the address shown the address where ret is stored in the function? Or is it just the address of the instruction to return the ret value?

  Read the article

• (database design):Which tables should be created for all kindes files (images, attached email files,

  - by meyosef

  Hi, I new in database design: I have question with my own few solution,what do you thinks?: Which tables should be created for all kinds files (images, attached email files,text files for store email body, etc..) that stored in my online store? *option 1:use seperate table for files types * files{ id files_types_id FK file_path file_extension } files_types{ id type_name (unique) } *option 2: use bool field for each file type * files{ id file_path file_extension is_image_main is_image_icon is_image_logo is_pdf_file is_text_file } **option 3: use 1 enum field 'file_type' for each file type ** files{ id file_path file_extension file_type (image_main,image_icon,image_logo,image_main,pdf,text) **enum** } Thanks you, Yosef

  Read the article

• how to import MS access database table in sql server 2005 in vb.net code

  - by habtamud

  I am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard . please find a sollution thanks a lot.

  Read the article

• Comma separated variable in MySQL

  - by ryan

  I want to create a stored procedure in MySQL and one of the input parameters will need to be a comma separated list of integers. How do I loop through each integer and run an update statement on it? I've googled it but can't seem to find anything that will work for MySQL.

  Read the article

• as3 air for android download folder and contents

  - by Papa De Beau

  Is it possible to download a folder and its contents using air for android? I would like to also use the same code on iPhone. I need it to be stored in the application storage so we can reference the content once downloaded. I know it's possible to download content as referenced in this question: Download Content using Air For Android but can a person download the entire folder and again store it in the application directory? Thanks @lukevain? :)

  Read the article

• java jsp : connecting to sql server tutorial?

  - by phill

  Can anyone recommend a tutorial on how to write a java servlet which connects to ms sql server and manages data? I'm trying to write something which pulls products out of one database and inserts them into a stored procedure located on another database. thanks in advance

  Read the article

• How can I frequently/automatically compare the structure of the same Database?

  - by Pitming

  Does anyone know a tool that automatically compares the structure of a database and gives a report of what was changed? If it can be integrated into a CruiseControl, even better. By structure I also mean functions and stored procedures. Which is probably not clear at first sight ;-) The idea was to integrate that into a cruise control server

  Read the article

• MySQL - Extracting Time in correct format

  - by mouthpiec

  Hi, I have a table with a coloumn of type "time", and the values in this coloumn are stored as follows: 20:45:00, 18:00:00, etc. Now when displaying the result, I am not getting the minutes, but just 00. I am using the following to get the time: SELECT TIME_FORMAT(time, '%h:%m') as time FROM ......... etc

  Read the article

• Clear subversion revision info

  - by RD

  I want to remove all stored revision info, except for the most up to date version (in an effort to safe space). Is this possible?

  Read the article

• sort date fields to obtain earliest date

  - by manu

  in my database , dates are stored in DD-mm-yyyy format , how can i sort this to obtain the earliest date ? Cursor c = myDb.query(TABLE, new String[]{"dob"}, null, null, null, null, "dob"); I have selected it to order by dob field but its not ordered ... This is the output for the above query 01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-11-1977 01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-12-1988 01-03 17:14:51.614: VERBOSE/ORDER DOB(1431): 15-01-1977 01-03 17:14:51.656: VERBOSE/ORDER DOB(1431): 31-01-1988

  Read the article

• ASP.NET MVC image upload store location (db vs filesystem)

  - by adrin

  I am writing web application using ASP.NET MVC + NHibernate + Postres stack. I wonder if images uploaded should be stored in database as binary blobs or on filesystem (and reference only in db). One advantage of db storage I can think of is easy backup/recovery of all data without reverting to filesystem copy tools. On the other hand I suspect that filesystem access may be faster (but is it especially when dealing with many concurrent requests?) What are your suggestions?

  Read the article

• byte[] to image android

  - by Sephy

  Hi everybody, My issue is as follows : I have stored a few pictures into the sqlite database, using the blob format, which seems to work ok. now i want to get my pictures out of the DB and put then back into images... to complicate the matter, their format is variable (png, jpg, maybe something else, im not sure) Is there a way of doing so in android? thank you

  Read the article

• How to test Gem Extensions in Rails

  - by rube_noob

  I have written an extension to an existing gem (that is stored in lib) and a corresponding test for my extension. How could I go about running the gem's tests as well as my own automatically. What is the best practice for this case?

  Read the article

• GoogleMaps API extracting building shape information.

  - by manionml

  Hi, I'm looking for a way to extract building shape (polygon) information from google maps automatically. It appears that you can only downloaded information relating to shapes you've created yourself. Example here. Information relating to building shape and height is stored by google, so I'm hoping there's a way to extract it.

  Read the article

• XML array from SQLite database

  - by Aarron

  I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?

  Read the article

• JPA - How to persist java.util.Set through JPA?

  - by Yatendra Goel

  I have a field aliases of type java.util.Set in one Entity. This Set doesn't denote any relationship to an Entity. Q1. How can I store this aliases field through JPA? Q2. How this field get stored in database? I think that for the database, this field is a multi-valued attribute.

  Read the article

< Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >