Search Results

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

Page 976/1158 | < Previous Page | 972 973 974 975 976 977 978 979 980 981 982 983  | Next Page >

• sqlite issue using WHERE statement on a varchar field in Objective-C

  - by Geykel

  Hi, I have this sql statement SELECT * FROM Language WHERE LanguageCode=? where LanguageCode is a varchar(2). When I use sqlite3-prepare-v2 on that statement I got SQLITE_ERROR but if I use SELECT * FROM Language WHERE LanguageID=? where LanguageID is the primary key numeric identity field the statement compiles just fine. Is there any issue filtering by a varchar field using WHERE statement? Thanks

  Read the article

• Allow repeater to be arranged using drag-drop

  - by o-logn

  Hey all, I have a repeater that's bound to a SQL Data Source (using ASP.NET). Are there any JQuery plugins/efficient way of converting my repeater into something that can be sorted via drag and drop? i.e. users can rearrange the order of the data, which updates the database? Thanks

  Read the article

• Problem with DBDesigner

  - by Renato Bezerra

  Hi everyone. The DBDesigner can synchronize only with MySQL? I tried with SQL Server but don't works. DBDesigner Ver: 4.0.5.6 Tks.

  Read the article

• What is the best framework for developing a Java CRUD for an existent database?

  - by Otavio

  We have a Java application with lots of config tables on the database (Oracle). We'd like to have Web-based GUIs for setting up these tables, that we currently update via SQL queries. What is the simplest way to develop CRUDs for a subset of our database? Is there any Java-based framework for doing this?

  Read the article

• Get number of concurrent users online - ASP.NET

  - by Srikanth

  I would like to know the number of users logged into my ASP.NET 2.0 application. Points to be considered: 1) Simplest way would be to use Application or Cache object to have the counts on Session start or end. However this would fail if there is a worker process recycle. Wouldn't it? 2) Should't make a difference whether the session is inproc/state server managed/ or SQL server managed. 3) Should preferably be seamless to a web-farm architecture.

  Read the article

• Joins and subqueries in LINQ

  - by Brian

  I am trying to do a join with a sub query and can't seem to get it. Here is what is looks like working in sql. How do I get to to work in linq? SELECT po.*, p.PermissionID FROM PermissibleObjects po INNER JOIN PermissibleObjects_Permissions po_p ON (po.PermissibleObjectID = po_p.PermissibleObjectID) INNER JOIN Permissions p ON (po_p.PermissionID = p.PermissionID) LEFT OUTER JOIN ( SELECT u_po.PermissionID, u_po.PermissibleObjectID FROM Users_PermissibleObjects u_po WHERE u_po.UserID = '2F160457-7355-4B59-861F-9871A45FD166' ) used ON (p.PermissionID = used.PermissionID AND po.PermissibleObjectID = used.PermissibleObjectID) WHERE used.PermissionID is null

  Read the article

• Simple Chatroom in PHP & MySQL !

  - by acer

  What is a simple and easy-to-use php-sql chatroom with no external signin (like meebo or ...) I want to use it for my own registered users.!

  Read the article

• Django 1.2 Equivalent of QuerySet.query.as_sql()

  - by Zach

  In Django 1.1 I was able to produce the SQL used by a QuerySet with this notation: QuerySet.query.as_sql() In Django 1.2, this raises as AttributeError. Anyone know the Django 1.2 equivalent of that method? Thanks

  Read the article

• Asp.net mvc small amount data storage

  - by Trimack

  Hi there, I am writing some learning tests (i.e. what's the answer for...; choose correct options...). Now my question is, how should I store them. SQL db seems quite an overkill, but I really don't know what would be the best choice if I wanted to select random subset of questions etc. Perhaps some simple xml files? Thanks for advice.

  Read the article

• The action or event has been blocked by Disabled Mode

  - by mattruma

  I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, I was able to run queries, update data, and delete data. Today I opened up the Access database to finish my data migration and am now receiving the following message when I try to run some update queries: The action or event has been blocked by Disabled Mode. Any ideas what this is talking about?

  Read the article

• Source Control at home

  - by Sash

  I am trying to setup a dev environment at home. My primary development environment is VS.NET 2008 (now it is VS 2010 Premium) with SQL Server 2008. Objectives / Requirements : - Should be simple and lightweight - Should have a Visual Studio plugin (cost should be less than $50, if its not free) - should work just fine with continuous integration systems like TFS and CruiseControl.NET - VSS is not an option. Thanks in advance, SK

  Read the article

• How to use group by and having count in Linq

  - by Luke

  I am having trouble trying to convert the following query from SQL to Linq, in particular with the having count and group by parts of the query: select ProjectID from ProjectAssociation where TeamID in ( select TeamID from [User] where UserID in (4)) group by ProjectID having COUNT(TeamID) = (select distinct COUNT(TeamID) from [User] where UserID in (4)) Any advice on how to do so would be much appreciated.

  Read the article

• INFORMIX ESQL/C 2.10.06E for MS-DOS 6.22 or 5.0

  - by Frank Developer

  Anyone know where I can get a copy of ESQL/C 2.10 which will work with INFORMIX-SQL 2.10.06E running on MS-DOS 5.0 or 6.22?.. I would also need to find Microsoft C compiler Version 6.

  Read the article

• Moving file security from one server to another (asp.net sites, IIS)

  - by Imageree

  I am running windows server with asp.net websites and sql server 2008 and IIS 6. It is working fine. Now I need to move my asp.net websites to another windows server and I have hard time setting correct file security for the new server. Is there any way to compare or move or see difference file security between two servers?

  Read the article

• How do I protect my website from javascript injection attacks when using rich text editors?

  - by VJ

  Hi all I am using the markitup editor to get the value for one of my fields and storing it a sql server 2008 db. Now I guess the problem is people having script tags and javascript in the editor and injecting malicious scripts and I have my validate input turned false. So can anyone suggest me a way to write a custom validation method that maybe checks for script tags and removes them...or just guide me through the steps i need to do ?...also are there other things also that I should be worried about..?

  Read the article

• simple php Dollar $ evaluation in string questions

  - by Mirage

  I have always been confused that .e,g in php i have sql statement $qry = "select * from table where id = $id"; now can i insert "$" directly inside the quotes or i have to use $qry = "select * from table where id =".$id." "; or $qry = 'select * from table where id = $id'; or $qry = 'select * from table where id = '$id''; Which is correct

  Read the article

• Cleansing string / input in Coldfusion 9

  - by Jakub

  I have been working with Coldfusion 9 lately (background in PHP primarily) and I am scratching my head trying to figure out how to 'clean/sanitize' input / string that is user submitted. I want to make it HTMLSAFE, eliminate any javascript, or SQL query injection, the usual. I am hoping I've overlooked some kind of function that already comes with CF9. Can someone point me in the proper direction?

  Read the article

• how do I execute a function from TOAD for Oracle and bind the result to a data grid

  - by neesh

  I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle?

  Read the article

• Preparation of preloaded user data

  - by Dave

  How do you all actually go about doing that? Currently what we will do is send the excel file to users they will fill in the info and we will use excel concatenation to generate the corresponding SQL scripts I kist thinking if there is any better way

  Read the article

• UTF-8 - Oracle issue

  - by goe

  I set my NLS_LANG variable as 'AMERICAN_AMERICA.AL32UTF8' in the perl file that connects to oracle and tries to insert the data. However when I insert a record with one value having this 'ñ' character the sql fails. But if I use 'Ñ' it inserts just fine. What am I doing wrong here?

  Read the article

• Alternative to Windows Azure tables out of the cloud

  - by John Grey

  Hi :) I'm developing a .NET app, which needs to run both on Azure and on regular Windows Servers(2003). It needs to store a few GB of data and SQL Azure is too expensive for me, so I'll use Azure tables in the cloud version. Can you recommend a storage solution, which will run on standalone servers and have an API and behavior similar to Azure tables? From what I've seen Server AppFabric does not include Tables. TIA

  Read the article

• cx_Oracle and output variables

  - by Tim

  I'm trying to do this again an Oracle 10 database: cursor = connection.cursor() lOutput = cursor.var(cx_Oracle.STRING) cursor.execute(""" BEGIN %(out)s := 'N'; END;""", {'out' : lOutput}) print lOutput.value but I'm getting DatabaseError: ORA-01036: illegal variable name/number Is it possible to define PL/SQL blocks in cx_Oracle this way?

  Read the article

• How can I create a small relational database in MySQL?

  - by Sergio Tapia

  I need to make a small database in MySQL that has two tables. Clothes and ClotheType Clothes has: ID, Name, Color, Brand, Price, ClotheTypeID ClotheType has: ID, Description In Microsoft SQL it would be: create table Clothes( id int, primary key(id), name varchar(200), color varchar(200), brand varchar(200), price varchar(200), clothetypeid int, foreign key clothetypeid references ClotheType(id) ) I need this in MySQL.

  Read the article

• Loop through resultset and add create comma seprated string in ASP Classic

  - by Sam

  Here's my ASP Classic: set irs = recordset(sql,PageDB) if not irs.eof then dim new_list new_list = "" do while not irs.eof 'Add irs("name") to new_list and seperate by comma irs.movenext loop end if kill(irs) How would I add irs(name) to new_list and seperate by a comma?

  Read the article

• mysqldump command not working?

  - by Harish Kurup

  I am using mysqldump to take backup of my database, but the command is not working.. the command i am using is mysqldump -u root dbname> 'c:\backupdatafolder\backup.sql' i am running this command in MySQL cli but not running,..is there any thing wrong in the command?

  Read the article

< Previous Page | 972 973 974 975 976 977 978 979 980 981 982 983  | Next Page >