Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 1600/2509 | < Previous Page | 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607  | Next Page >

• How can i convert my string with my common language to English?

  - by Phsika

  i have some excell data. also excel column i created programmaticaly in sql tablr my excel column on the other hand; some column's name is "mydetail" if converting to to upper MYDETAIL. i must this ToUpper() event : MYDETAIL not MYDETAIL

  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 connect PHPMyadmin DB by creating the batch file.

  - by Dev

  Hi All, I have created the sql file to create table in DB, I am using PHPMYAdmin But i am not able to connect to the DB, I want to run this as Batch file. If i try to MYSQL from command prompt it give error as 'mysql' is not recognized as an internal or external command, operable program or batch file. Regards, Dev

  Read the article

• how do i specify connection parameters on the command line to run mysql in batch mode?

  - by hmak

  I need to be able to write a script to automatically connect mysql in batch mode so that I can run some .sql files. I tried to enter the following at the prompt: ./mysql -u root -p mypassword but I keep getting a "Enter password: " prompt. What am I doing incorrectly? Thanks.

  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

• Want to store profiles in Qt, use SQLite or something else?

  - by Pirate for Profit

  I want to store some settings for different profiles of what a "task" does. I know in .NET there's a nice ORM is there something like that or an Active Record or whatever? I know writing a bunch of SQL will be fun

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• Anyone know of any issues with using VS2010 with TFS 2005

  - by Harrison

  We want to upgrade to VS2010 but are currently using TFS 2005. Does VS2010 integrate cleanly with the older versions of TFS. We're not upgrading to SQL Server 2008 anytime soon which is why we're still on TFS 2005. Thanks.

  Read the article

• Can I host an ASP.NET webite outside of IIS?

  - by boraer

  Hi everybody, I need to write an ASP.NET application which must handle a very large number of transactions per second - as many as 5000 users may transact at the same time. I think I will use WCF in back to communicate with SQL server. But in front, can IIS handle 5000 users at the same time effectively, or is there any simple way to host my application outside of IIS?

  Read the article

• mysql insert with auto-increment column

  - by czuroski

  Hello, I am trying to insert data into a mysql table from a csv file. I am using the infile sql command, but I am having trouble because the first column of the table is an id that is set as an auto increment field. what do I have to set my first column value to in order to get this to work, or can I do it at all? Thanks

  Read the article

• Disable automatic index on related object id from yml

  - by BugBusterX

  Doctrine Automatically creates indexes on columns that are used to define object relations, For example user: id, name message: id, sender_id, receiver_id, message if I define relationship between message and user in a way that message has one Sender and has one Receiver, doctrine will automatically index sender_id and receiver_id fields when I generate sql from model. I would like to disable index on sender, because I manually create index with sender_id and receiver id together. How can I disable auto generated index?

  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

• 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

• Disjunction in ActiveRecord

  - by samuil

  Is it possible to use ActiveRecord named_scopes to create one query with sql OR clauses? When I use Model.scope1.scope2 generated query is conjunction of these scopes.

  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 to stop Django "app not found" error?

  - by cml

  When I run python ./manage.py sql grading my django site comes up with: Error: App with label grading could not be found. Are you sure you INSTALLED_APPS setting is correct? I have the app grading with __init__.py and everything, and my INSTALLED APPS is: INSTALLED_APPS = ( 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.admin', 'teachline.courses', 'teachline.grading', ) Why isn't this working?

  Read the article

• 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

• How to test if table was updated in Zend Framework?

  - by AD

  When user opens a form to modify a record, but instead of changing information, he just clicks the Update button. Which causes the update() function to return 0. However, I consider this case a valid update task. How would I test it, so I can assign a success message? Is update() returns -1 when SQL query failed or also 0? Method: Zend_Db_Table_Abstract::update() Any ideas? Thanks

  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

• 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

• How do I check the Database type in a Rails Migration?

  - by Shaun F

  I have the following migration and I want to be able to check if the current database related to the environment is a mysql database. If it's mysql then I want to execute the SQL that is specific to the database. How do I go about this? class AddUsersFb < ActiveRecord::Migration def self.up add_column :users, :fb_user_id, :integer add_column :users, :email_hash, :string #if mysql #execute("alter table users modify fb_user_id bigint") end def self.down remove_column :users, :fb_user_id remove_column :users, :email_hash end end

  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

• Can someone help me find a tutorial for making a hotel reservation system from scratch ?

  - by Shad12ow

  Just as a title say, I need a tutorial to make a simple hotel reservation system. I really need the source code too, but I prefer tutorial because I want to understand the system. Can someone help ? I need them in VB.NET and the database is SQL Server.

  Read the article

• Unknown column '' in 'field list'

  - by Rixius

  I am running a sql in PHP query that is dieing with the mysql_error() of Unknown column '' in 'field list' The query: SELECT `standard` AS fee FROM `corporation_state_fee` WHERE `stateid` = '8' LIMIT 1 when I run the query in PHPmyadmin, it return the information without flagging the error

  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

< Previous Page | 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607  | Next Page >