Search Results

Search found 28930 results on 1158 pages for 'sql ce'.

Page 989/1158 | < Previous Page | 985 986 987 988 989 990 991 992 993 994 995 996  | Next Page >

• What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

  - by trenton

  I tried this in mysql: mysql> alter table region drop column country_id; And got this: ERROR 1025 (HY000): Error on rename of './product/#sql-14ae_81' to './product/region' (errno: 150) Any ideas? Foreign key stuff?

  Read the article

• NHibernate, updating a db column to a function call when persisting a domain object.

  - by Wyass

  I have a domain class that when persisted to Oracle must update a column to sysdate. NHibernate must only generate 1 SQL. e.g. update person set age = 12, stamp = sysdate where id = 1; Can this be done?

  Read the article

• Entity Framework 4 omits some associations during model generation

  - by kzen

  After creating an EF4 model from a SQL Server database I noticed that all the relationships of my Users table were not imported into the model as associations. All the other relationships were imported fine. My Users table has a PK userId which is a char(7) field and it is integrated into several other tables in the database as an FK but for some reason EF4 does not import these relationships as associations during the model generation process... Does anyone have any ideas why this would be happening?

  Read the article

• @Resource annotation is null at run-time.

  - by Andrew

  I'm using GlassFish v3. The following field is declared in a class: @Resource private javax.sql.DataSource _data_source; The following is declare in web.xml: <data-source <namejava:app/env/data</name <class-namecom.mysql.jdbc.Driver</class-name <server-namelocalhost</server-name <port-number3306</port-number <usermyUser</user <passwordmyPass</password </data-source At run-time _data_source is empty. What am I doing wrong?

  Read the article

• How to get the number of columns from a JDBC Resultset?

  - by Sanoj

  I am using CsvJdbc (it is a JDBC-driver for csv-files) to access a csv-file. I don't know how many columns the csv-file contains. How can I get the number of columns? Is there any JDBC-function for this? I can not find any methods for this in java.sql.Resultset. For acessing the file, I use code similar to the example on the CsvJdbc website.

  Read the article

• how to create a auto-incramented attribute in xcode managed object model

  - by Mausimo

  Hey, what i want to do is to make a int that will be the ID of the entity and auto increment itself whenever a new entity is added (just like a SQL identity property). Is this possible? i tried using indexed (checked on attribute) however there is no description to what indexed even does.

  Read the article

• SSIS Lookup component only returns matching rows when using partial mode

  - by Myat Htut

  I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one component returns the matching rows only when I enable the partial cache mode. If I use the full cache mode, all data is routed to the error path. I am using SQL 2005 SSIS. Any help appreciated..

  Read the article

• Django: select_related and GenericRelation

  - by Parand

  Does select_related work for GenericRelation relations, or is there a reasonable alternative? At the moment Django's doing individual sql calls for each item in my queryset, and I'd like to avoid that using something like select_related. class Claim(models.Model): proof = generic.GenericRelation(Proof) class Proof(models.Model): content_type = models.ForeignKey(ContentType) object_id = models.PositiveIntegerField() content_object = generic.GenericForeignKey('content_type', 'object_id') I'm selecting a bunch of Claims, and I'd like the related Proofs to be pulled in instead of queried individually.

  Read the article

• Mysql:How to concatenate more than one row into single row with diffrent field name?

  - by subakaran

  id Subject mark Year 1 Maths 32 2008 1 Science 40 2009 1 Science 45 2008 1 English 50 2009 1 English 60 2008 I need solution like this ID Maths Science English 1 32 40 & 45 50 & 60 Please advise me. am using my sql

  Read the article

• My .Net app need local admin rights to run. Why?

  - by paul

  I wrote a WinForms app using .Net and C#. The app accesses DirectoryServices and SQL databases. The new Win7 workplaces are not allowed to have local admin users and this app will not run. How can I identify the actions in the app which need local admin rights?

  Read the article

• Making a function for selecting from MySQL, how is mine?

  - by Doug

  This is my first time. I will appreciate any thoughts, tips, and what not. How can I improve this? Ultimately, I don't want so many selects in my script. function mysqlSelectCodes($table, $where, $order, $limit) { $sql = "SELECT * FROM $table WHERE $where ORDER BY $order LIMIT $limit" or die(mysql_error()); }

  Read the article

• Two-pass multi way merge sort?

  - by Nimesh

  If I have a relation (SQL) that does not fit in memory and I want to sort the relation using TPMMS (Two-pass multi-way merge sort method). How would I divide the table in sub tables (and how many) that can fit in memory and than merge them? Let's say I am using C#.

  Read the article

• Capture Stored Procedure print output in .NET (Different model!)

  - by Workshop Alex

  Basically, this question with a difference... Is it possible to capture print output from a TSQL stored procedure in .NET, using the Entity Framework? The solution in the other question doesn't work for me. It works with the connection type from System.Data.SqlClient but I'm using the one from System.Data.EntityClient which does not have an InfoMessage event. (Of course, I could just create an SQL connection based on the Entity connection settings, but prefer to do it directly.)

  Read the article

• PHP Array in MySQL IN() function?

  - by Trez

  Is it possible to assign php array in MySQL IN() function? for example, $numbers = array('8001254656','8886953265','88864357445','80021536245'); $sql = mysql_query("SELECT * FROM `number_table` WHERE `number` IN ($numbers)"); Any Ideas? Thanks,

  Read the article

• How to span multile tables in Django

  - by ipartola

  The Django documentation gives en example like so: b = Blog.objects.get(id=1) b.entry_set.all() Which from what I understand results in 2 queries. What if I wanted to get the blog, the blog entries and all the comments associated with that entry in a number of queries that does not depend on the number of entries? Or do I have to drop down to SQL to do that?

  Read the article

• memcached vs. internal caching in PHP?

  - by waitinforatrain

  Hey, I'm working on some old(ish) software in PHP that maintains a $cache array to reduce the number of SQL queries. I was thinking of just putting memcached in its place and I'm wondering whether or not to get rid of the internal caching. Would there still be a worthwihle performance increase if I keep the internal caching, or would memcached suffice?

  Read the article

• How can I implement String.Concat(object, object) to L2E framework?

  - by Eran Betzalel

  I have two long type columns that I want to concat during sql query. Using Linq to Entities making it impossible, because it only supports String.Concat(string, string). I'd like to know how can I implement this function myself and add it to the L2E framework.

  Read the article

• What's the best way to learn about programming security-related topics? (PHP)

  - by user300371

  I am currently building a site and all the books I have read on PHP so far are just on functionality and not much on security. Is there a book that deals specifically with making your code/site secure? I don't want to go public and the next day have all my code changed or my database erased by SQL injection. thanks

  Read the article

• Blind Injection [closed]

  - by Ajay

  Blind SQL Injection Severity: High Test Type: Application Vulnerable URL: Remediation Tasks: Filter out hazardous characters from user input Variant 1 of 2 [ID=12654] The following changes were applied to the original request: • Set parameter 'nm's value to 'Demography'%20and%20'foobar'='foobar'

  Read the article

• Display database resume to user

  - by Domnic

  Im using upload control to upload my resume(word document) in sql server 2005 database.and i can download it from database when i click link button...Its all working file...My problem is how can i show my full resume to user (how to display my resume) from my database?

  Read the article

• NHibernate join and projection properties

  - by devgroup

  Hello, I have simple situation (like on the image link text) and simple SQL query SELECT M.Name, A.Name, B.Name FROM Master M LEFT JOIN DetailA A ON M.DescA = A.Id LEFT JOIN DetailB B ON M.DescB = B.Id How to achive the same effect in nHibernate using CriteriaAPI ?

  Read the article

• insert exclusive locking

  - by Markus

  Hi, I have thought about the following SQL statements: INSERT INTO A(a1, a2) SELECT b1, udf_SomeFunc(b1) FROM B Where udf_SomeFunc makes a select on table A. As I understand, first, a shared lock is set on A (I am talking just about table A now), then, after this lock is released, an exclusive lock is obtained to insert the data. The question is: is it possible, that another transaction will get the exclusive lock on table A, just before the current transaction takes its exclusive lok on A?

  Read the article

• ASP.NET - How to edit 'bit' data type?

  - by Peter

  I am coding in Visual Basic. I am using a checkbox control. Now depending on its checked property I need to set/unset a bit column in a SQL Server database. Here's the code: Try conSQL.Open() Dim cmd As New SqlCommand("update Student set send_mail = " + _ sendemailCheckBox.Checked.ToString + " where student_id = '" _ + sidnolabel.Text + "'", conSQL) cmd.ExecuteNonQuery() Finally conSQL.Close() End Try The send_mail attribute is of bit datatype. This code is not working. How do I go about it?

  Read the article

• Getting the data out of the data Formview

  - by QEDDave

  I have an ASP pg with a formview list control on it that hooks up to a sql database customer table I want to access the customer name outside the form. How do I: A) access the bound text box in the form view template? Something like Text1.text=formview1.customername.text (that doesn't work but that's the kinda thing) B) access the database field in the table that the sqlsource connects to to feed the formview Really appreciate the help. I bet it's easy to do but I'm just not getting there.

  Read the article

• Should I go for ASP.Net MVC?

  - by Chinjoo

  HI, I want to create an application which requires SQL reports. Should I opt for ASP.Net MVC for this application?

  Read the article

< Previous Page | 985 986 987 988 989 990 991 992 993 994 995 996  | Next Page >