Search Results

Search found 30606 results on 1225 pages for 'database relations'.

Page 789/1225 | < Previous Page | 785 786 787 788 789 790 791 792 793 794 795 796  | Next Page >

• SQL Server 2005: Invalid object name exception

  - by Craig Johnston

  In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException Invalid object name 'tableXYZ' but tableXYZ is a table in the database. Should it be looking for dbo.tableXYZ instead? Is this a permissions issue with the login being used?

  Read the article

• are push notification tokens unique across all apps for a single device?

  - by scootklein

  i will have multiple applications on the app store and 1 urban airship account to send push notifications to all of these devices. what i want to know is if each apple device has the same "push token" across all applications? this is more of a database architecture thing so that I don't duplicate a push token many times if one single device uses many of my apps if each apple device generates a unique push token for each application it has installed my architecture needs to change.

  Read the article

• trusted SQL Server connection

  - by dan_vitch

  When I attempt to make a connection from my console app to my sqlExpress. I get the following error: The user is not associated with a trusted SQL Server connection. I have: Switched users Switched passwords Switched Servers Switched Databases I always get the same error. I am using VS 2010 and Sql Server 2005 Here is my current connection string SqlDatabase sqlDatabase = new SqlDatabase(@"Server=localmachineName\SQLEXPRESS;database=database1;user id=username password=mypassword;");

  Read the article

• Jeditable doubling up on linebreaks every edit

  - by st3

  I'm using var retval = value.replace(/<br[\s\/]?>/gi, '\n'); To strip the <br> tags from the textarea and nl2br('$_POST('newValueHere')') to insert into my database and to return back to jeditable to display the edits. The only problem I'm having is that each click on the editable field seems to make all the <br> tags be written twice? This makes no sense, does anyone have any ideas what could be going on?

  Read the article

• Ad-hoc retreival of data from SQL Server varbinary column

  - by Daniel Fortunov

  I would like to retreive some binary data from a varbinary(max) column in a SQL Server database for debugging purposes. What is the easiest way to get this data into a local binary file, preferably without having to write a throw-away console application? I have tried using SQL Server Management Studio but this returns a hex encoded binary string, rather than raw binary data (even with the "results to file" option).

  Read the article

• ASP.NET Session size limitation

  - by eugeneK

  Is there some kind of Session size limitation or advisable value to not to surpass ? In my web application i create few DataTables to store user selections which are stored in session until user approves selections so i add those values to database. problem is i don't know whether session is reliable enough to keep few objects in or not ? thanks

  Read the article

• Passing multiple parameters of same column to SQL Server select SP

  - by Bill

  I have a string value in the web.config — for example 2 guids seperated by a ",". I need to query the database dynamically (i.e i have no idea how many values could be seperated by a comma in the web.config) and run a select statement on the table passing these values and getting all that is relevant for example: select * from tablename where columnname = string1 string2 string3 etc etc some strings may only contain 1 guid some may contain 10

  Read the article

• Run sql script from console and not from query analyzer in SQL server

  - by Spyros

  Hello , i have written an sql script for updating a database that runs in SQL server 2005 and I want to make that changes to the production DB server but I dont want to run the query from the query analyzer , is there a way to run the sql script from console?

  Read the article

• connecting cell phone to computer

  - by I__

  is it possible for me to intercept the text messages that get sent to my cellphone if i connect to my cellphone via bluetooth or USB or some other connection to my computer? i want to create a database with all of my received text messages and be able to control my cell phone through my computer by using it to send text messages i have a regular motorola flip phone

  Read the article

• SQL Server Query Command

  - by Scott Jackson

  Hi, I have an SQL database table, I want to find everything in a table where the 'Room' says 'DISPOSED', Insert 'DISPOSED' into the 'Status' field and then delete the entry in 'Room'. Basically moving the entry from one field to another (if the 'Room' field has 'DISPOSED' in it) Hope this makes sense. Thanks for any help.

  Read the article

• Hooking entity creation in SQLAlchemy

  - by Dan Ellis

  I want to write a SessionExtension that fires a 'Foo-created' event or 'Bar-created' event every time a new Foo or new Bar is committed to the database. However, once inside the after_commit method, I don't know where to find which entities have been committed. Where do I get this information?

  Read the article

• Parameter has no walue

  - by Simon

  string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE users.ID= " + a.ToString() + " AND obroki_save.datum =?"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) { cmd.Parameters.Add("@datum", OleDbType.Char).Value = DateTime.Now.ToShortDateString(); } Why doesn't the parametr datum get the date value? (the value of at least one complex parameter has not been determined )

  Read the article

• When will Postgres's full text search supports phrase match and proximity match?

  - by hko19

  As of Postgres 8.4 the database fts does not support exact phrase match, nor does it support proximity match if given 2 terms. For example, there is no way to tell Postgres to match on content that have word #1 which is in a specified proximity of word #2. Any one know the plan of Postgres and possibly which version will phrase and proximity match be supported?

  Read the article

• sql query returns incorrect result

  - by reza saberi

  I have a mysql database that stores quotation documents with some products that are clearly defining the price of each product in them, and a table for contracts storing contract details as well as customer code and quotation code to which it belongs. I have the following query to see how much is the total price of the quotation to write it in the invoice: select sum(sqproducts.price * sqproducts.quantity) as 'total-price', squotations.currency as 'currency' from sqproducts, ccontracts, squotations where sqproducts.contracted=1 AND squotations.code=sqproducts.quotation_code AND sqproducts.quotation_code=ccontracts.squotation_code AND sqproducts.quotation_code='QUOT/2012/1' group by currency

  Read the article

• Is there an efficient way to call a Grails template from a string loaded from db?

  - by Kimble

  I store user editable articles in a database. Users can insert some simple widgets into the articles (graphs and so on). So far I've implemented this as a proof of concept by letting the user insert graphs like [graph-1] and than do a string search and replace. I was wondering whether there are more efficient ways of calling templates from a string? Maybe involving Sitemesh?

  Read the article

• Web Service Authentication in C# Web Application i.e Details on Digest and Basic Authentication

  - by NSK

  Details on all Web Service Authentication methods and How to apply those?? i.e Way to apply Basic and Digest Authentication in C# Web Application. More: I'm creating a Web Service and want to deploy it on IIS 5.0. In order to authenticate user I want to use Digest Authentication. How this is done? The authentication should contain some through which the user is checked inside database for authentication and then if valid user then return success or else failure...

  Read the article

• hibernate's transaction read and subsequent update

  - by feiroox

  Hi I have situation in which I read a record from a database. And if everything is ok I'll modify few properties and commit transaction. But in situations two threads do the same, they will update the same record. How to make it in hibernate?

  Read the article

• sql "Group By" and "Having"

  - by Hans Rudel

  im trying to work through some questions and im not sure how to do the following Q:Find the hard drive sizes that are equal among two or more PCs. its q15 on this site http://www.sql-ex.ru/learn_exercises.php#answer_ref The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, type, price) any pointers would be appreciated.

  Read the article

• Python : Crating Dynemic Functions

  - by jigar

  I have issue where i want to create Dynamic function which will do some calculation based to values retrieved from database, i am clear with my internal calculation but question in how to create dynamic class: My Structure is something like this : class xyz: def Project(): start = 2011-01-03 def Phase1(): effort = '2d' def Phase2(): effort = '3d' def Phase3(): effort = '4d' Now want to generate those all PhaseX() function dynamically so can any one suggest me how to achieve such thing using Python Code Waiting for Positive reply Regards Thank You

  Read the article

• MySQL 5.1.41 leading zero is deleted

  - by iggnition

  Hello, I have a MySQL database where i want to store phonenumbers among other things. The fieldtype is INT(10) When I try to insert a number starting with a 0, like 0504042858 it's stored like 504042858. This only happens with zeros when the number start with any other number it's stored correctly. What am I doing wrong?

  Read the article

• CakePHP: how to get recently created auto-incremented field

  - by junior29101

  I have a user submit a field to the database, it validates, and makes the entry. The primary key of this new row is auto-incremented. The user then gets to another form where that newly created field is required. Can anyone shed any light on this problem? Thanks in advance!

  Read the article

• C# Working password encyption methods for user password managment needed ?

  - by abmv

  Can someone provide working code to encrypt a password and store it in the database.Anything simple would do,some "salt" would be nice. public void Encrypt(string password) { } public void Verify(string password) { }

  Read the article

• Does some Integer data types differnate with other Programming languages?

  - by Wayne

  Do Integer data types allow spaces when it should be just numeric? Do other programming languages allow spaces in an Integer data type? For example, MySQL database storage does not allow spaces to be stored in an int data type. Do other languages allow it?

  Read the article

• SQL server globalization

  - by Nijesh patel

  When using arabic language, data is stored in database with ? (question mark) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.

  Read the article

• Multitenant NHibernate application with with separate SQL Server schema for each tenant

  - by Branko

  I am writing a new multi-tenant WCF RIA application. I plan to have a shared database with separate SQL Server schema for each tenant. I would like to use NHibernate for object-ralational mapping. Configuration of SQL Server schema in mapping classes doesn't help because it is static and would need one set of mapping classes for each tenant. Is it possible to dynamically configure ISession which SQL Server schema should be used for mapping objects to tables?

  Read the article

< Previous Page | 785 786 787 788 789 790 791 792 793 794 795 796  | Next Page >