Search Results

Search found 9396 results on 376 pages for 'stored procedures'.

Page 171/376 | < Previous Page | 167 168 169 170 171 172 173 174 175 176 177 178  | Next Page >

• 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

• 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

• is able to accommodate multiple data type in one column?

  - by Jothi

  hi, i have one problem that, i have to change type of data in column based on foreign key stored in that row. unit_id unit_name 1 String 2 Float 3 Date 4 Int Id spec value unit id 1 "A" 1 2 30.90 2 3 null 3 4 100 4 now i should achieve the above codition. how do i achieve it? please help me.

  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

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

• Load Balancer Timeout

  - by Anilkumar

  "This website is temporarily unavailable. Please check back later. Unfortunately there were no suitable nodes available to serve this request." When I request a stored procedure from my program (SP is taking 2 minutes to execute) the above error is getting. I believe this is because of Load balancer Time out. How we can increment the load balancer time out.

  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

• Getting a partial path to a file in a bash script

  - by Massif

  I have a path that is stored in a variable $FULLPATH="/this/is/the/path/to/my/file.txt" I also have another variable containing a partial path $PARTIAL="/this/is/the/" I want to remove the partial path from the full path so that I am left with: path/to/my/file.txt What's the best way to do this?

  Read the article

• CruiseControl.NET: Displaying generated files as part of the build history

  - by Garry Shutler

  I have a rake task running on CC.NET that generates HTML test reports. I'd like these test reports to be stored against each build and be accessible from the CC.NET website when looking at the details of the build. Is there a way of doing this or do you know of another continuous integration server that can do this?

  Read the article

• How to access image folder in django

  - by anc1revv

  I just started django and i want to access images uploaded by a user. here is my model: class Food(models.Model): name = models.CharField(max_length=100) price = models.DecimalField(max_digits=4, decimal_places=2) quantity = models.IntegerField(blank=True, null=True) description = models.CharField(max_length=200) location = models.CharField(max_length=100) time = models.DateTimeField() photo_thumbnail = models.ImageField(upload_to="images") photo_fullsize = models.ImageField(upload_to="images") i stored the image in the "images" folder below the html is this: img src="{{steak.photo_thumbnail}}" and steak.photo_thumbnail = images/steak_and_egg_thumbnail_1.png here is the error i get: [06/Jul/2012 19:08:24] "GET /menu/ HTTP/1.1" 200 99 [06/Jul/2012 19:08:24] "GET /menu/images/steak_and_egg_thumbnail_1.png HTTP/1.1" 404 2127

  Read the article

• How to hash a password and store for later verification with another digest

  - by oxygen8

  I am using gsoap's wsseapi plugin and would like to store hashed sha1 passwords rather than plain text. I have spent a rediculous amount of time experimenting with various methods of hashing the plain text password for storage. Can anyone suggest a way to hash a password so it can be later verified against a username token digest sent by the client. I can't seem to get the client password to authenticate against my stored hash

  Read the article

• What is the best way of inserting a datetime value using dynamic sql

  - by jaffa

  What is the best way of inserting a datetime value using a dynamic sql string, whilst at the same time being able to handle the possibility of the value being null? The current statement inserts into a table from a select statement built using a string. The datetime value is stored in a parameter and the parameter is used in the select. Like so: set @execsql = 'Insert into ( start_date ) SELECT ( ''' + CAST(start_date as VARCHAR) + ''' + ')'

  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

• Why can't i access page viewstate in usercontrol?

  - by Rohit

  I stored a object in viewstate on Page. Now when i access the same viewsate object on usercontrol,it shows as null. I even tried creating the same viewstate with same name in usercontrol and page.Both holds different value. I understand that viewstate is a protected property. How does this thing implement in above scenerio or is there any other reason for this behaviour.

  Read the article

• date / time convert to time since php

  - by Webby

  Hello in my database date / time are stored in this format 2010-06-01T18:20:25+0000 I'd like to echo that out to time passed since that date / time e.g. 2 minutes ago or 2 days ago is this possible?

  Read the article

• accessing Excelfile from Resources

  - by Sathish

  i am trying to access a Excel file stored in my Resources and build-embed by OLEDB but when i run the program i get database is read only.. i am using the below code. Please help conMap.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + CTARepository.Properties.Resources.mapping + ";Extended Properties=Excel 8.0;"; conMap.Open(); mapping is my mapping.xls file

  Read the article

• writting an sql query

  - by Praveen Prasad

  iam having 2 tables table Items Table (this table holds all items iam having) itemId --------- Item1 Item2 Item3 Item4 Item5 table 2 users_item relation UserId || ItemId 1 || Item1 1 || Item2 userId one has stored 2 items Item1,Item2. Now i want to write a query on table1 (Items table) so that it displays all items which user1 has NOT chosen.

  Read the article

• If I am a provider for email messaging how can I register a service in the service book on Blackberr

  - by timoto

  As I understand in the service books we have the entries for each messaging and transport service. The configuration for those services are stored there. In particular I see the Google talk, Yahoo client download and facebook as services.

  Read the article

• SQL Server 2008 error message from store procedure

  - by George2

  Hello everyone, When we met with such error message from store procedure, Message 1205, Level 13, State 52, the process Pr_FooV2, Line 9 Services (Process ID 111) and another process is deadlock in the lock | communication buffer resources, and has been chosen as the deadlock victim. Rerun the transaction. I am wondering whether such messages are stored in log files? I searched log folder of my SQL Server 2008 installation root (in my environment, it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log), but can not find such files. thanks in avdance, George

  Read the article

• Android Google Analytics dispatch interval

  - by Bear

  In the document, it mentions that we can have a dispatch interval such that page view will be automatically dispatched after x seconds. I have the code like the following tracker.startNewSession("UA-YOUR-ACCOUNT-HERE", 20, this); I sure trackPageView() is called as I can see those pageview are stored into "google_analytics.db" which is the database that google analyitcs used to store non-dispatching pageview. However, it doesn't send to Google Analytics after 20 seconds In log, it keeps reporting scheduling next dispatch when I call trackPageView().

  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

• How long will a browser remember a "a:visited" link?

  - by Matrym

  How long will a browser remember a "a:visited" link? Assuming the method isn't uniform across browsers - an answer for any individual browser (or as many as you know) would be helpful. Also, under which type of memory is it stored? "Web History"? Cache?

  Read the article

• Calculating percent of votes inside mysql statement.

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  Read the article

• Need Help Loading and Manipulating Bitmap Data

  - by Dave

  Using VB6, I need to load a bitmap image and subsequently manipulate some of its data - specifically, I want to rotate a section within the image, and in the end keep the image intact with the rotated section. How do I (1) find out where an image gets loaded into memory (a physical address), and (2) in what format is it stored, a 1-D array, 2-D array, or what? Maybe you can even suggest a better way to do this. Thanks.

  Read the article

< Previous Page | 167 168 169 170 171 172 173 174 175 176 177 178  | Next Page >