Search Results

Search found 10242 results on 410 pages for 'stored proc'.

Page 197/410 | < Previous Page | 193 194 195 196 197 198 199 200 201 202 203 204  | Next Page >

• how to count number of elements of same value in a matrix?

  - by niko

  Hi, Does anyone know how to count the number of times the value appears in a matrix? For example if we have a 1500 x 1 matrix M (vector) which stores the values of weekdays (1 - 7) and would like to count how many Sundays (1), Mondays(2),... , Saturdays(7) are stored in M? Thank you!

  Read the article

• Whats the best way to design this database scenario?

  - by ankimal

  I want to setup 2 MySQL databases which differ in schema in that, one is normalized and the other is flat for quicker reads and writes. The information being stored in both DBs is the same, but the representation is obviously different owing to the different design approaches. I need to find a robust solution to sync information in real time from my normalized version to my flatter version.

  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

• Why am I getting programs stuck in log_wait_commit under Linux?

  - by staticsan

  There is something subtly wrong with my Linux install that I just can't locate. It is Ubuntu Lucid Lynx (10.04) 64-bit. Hardware is a Dell Optiplex 960: Intel Core 2 Quad CPU, 8Gb of RAM, 2x 300Gb HDDs. /home is ext2 on one disk and everything else is on the other (/ is also ext3). I have VirtualBox running a 64-bit Vista image for Outlook calendaring, but the heavyweight apps are IntelliJ, NetBeans, MySQL and Opera. Opera also loads my mail (IMAP) of which there is over 10,000 messages. The problem is that Opera stalls for a few seconds from time-to-time. Watching the process list shows it's in log_wait_commit which means (as far as I have figured out) the filesystem is holding things up. Sometimes I can make this happen by doing a subversion update, but usually it happens for no reason I can see. It usually happens to Opera, but I've seen NetBeans go under, too. It doesn't make the app crash - it's just completely unresponsive for a few seconds. Googling has not helped. The closest I got was to remove the sync attribute in the file system. This achieved nothing. On the advice of a Linux guru friend, I lowered /proc/sys/vm/dirty_writeback_centisecs to 300, but that didn't do anything, either. And it was all he could think of. What is going on and can I fix it? (And how?)

  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

• (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 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 193 194 195 196 197 198 199 200 201 202 203 204  | Next Page >