Search Results

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

Page 992/1158 | < Previous Page | 988 989 990 991 992 993 994 995 996 997 998 999  | Next Page >

• what is the best asp.net hosting provider out there

  - by ooo

  i have been hosting a bunch of asp.net mvc website on webhost4life.com and i am finally fed up with their poor customer service and down time. Can someone please suggest the best windows iis hosting that supports asp.net mvc, sql server 2008, etc.

  Read the article

• what is required to run a c# winform program on a computer

  - by saso

  i have created a simple c# winform program that uses MS sql, and several DLLs. what steps should i do in order to get the program run on another computer. ie should i transfer the exe file + the dlls i used? should i also install .net framework 3.5 on the other pc? i used visual studio 2008 to compile.

  Read the article

• How get the names of all the tables from a database in a combo box using c#

  - by syedsaleemss

  Im using c# .net windows form application. i have a SQL database with 5 tables. i need to populate a combobox with these table names. only names should be displayed.

  Read the article

• Question on Books

  - by rockbala

  I am a learning SQL, HTML now. I would like to learn the following two more... Java, XML. I want to understand these two from testing and Web Services point of view. Is there a better order to learn the next two Java, XML or XML, Java?

  Read the article

• Using Oracle Zero Date

  - by Noam

  I have an application with existing data, that has Zero in the date column. When I look at it from sqlplus I see: 00-DECEMB when I use the dump function on this column, I Get: Typ=12 Len=7: 100,100,0,0,1,1,1 I need to work with the existing data from .Net (no changes to the data,or the data structure or even existing sql statements) How the hack do I read this value, or write it. The db version varies, from 8 to 11. Help would be appreciated

  Read the article

• How to construct these HQL statements

  - by losintikfos

  Do anyone know how to construct these two SQL statement in HQL; SELECT MIN(id) FROM Books WHERE mid < ? OR mid =? SELECT SUM(noOfBooks) FROM Bookcount WHERE mId=128

  Read the article

• Supplying my own Query Statement - Can it be done?

  - by Randy Minder

  I am creating a Crystal 2008 report, and I'd like to provide it a T-SQL statement for data generation, instead of selecting and joining together tables. Can this be done?

  Read the article

• Help Desk Database Design

  - by user237244

  The company I work at has very specific and unique needs for a help desk system, so none of the open source systems will work for us. That being the case, I created a custom system using PHP and MySQL. It's far from perfect, but it's infinitely better than the last system they were using; trust me! It meets most of our needs quite nicely, but I have a question about the way I have the database set up. Here are the main tables: ClosedTickets ClosedTicketSolutions Locations OpenTickets OpenTicketSolutions Statuses Technicians When a user submits a help request, it goes in the "OpenTickets" table. As the technicians work on the problem, they submit entries with a description of what they've done. These entries go in the "OpenTicketSolutions" table. When the problem has been resolved, the last technician to work on the problem closes the ticket and it gets moved to the "ClosedTickets" table. All of the solution entries get moved to the "ClosedTicketSolutions" table as well. The other tables (Locations, Statuses, and Technicians) exist as a means of normalization (each location, status, and technician has an ID which is referenced). The problem I'm having now is this: When I want to view a list of all the open tickets, the SQL statement is somewhat complicated because I have to left join the "Locations", "Statuses", and "Technicians" tables. Fields from various tables need to be searchable as well. Check out how complicated the SQL statement is to search closed tickets for tickets submitted by anybody with a first name containing "John": SELECT ClosedTickets.*, date_format(ClosedTickets.EntryDate, '%c/%e/%y %l:%i %p') AS Formatted_Date, date_format(ClosedDate, '%c/%e/%y %l:%i %p') AS Formatted_ClosedDate, Concat(Technicians.LastName, ', ', Technicians.FirstName) AS TechFullName, Locations.LocationName, date_format(ClosedTicketSolutions.EntryDate, '%c/%e/%y') AS Formatted_Solution_EntryDate, ClosedTicketSolutions.HoursSpent AS SolutionHoursSpent, ClosedTicketSolutions.Tech_ID AS SolutionTech_ID, ClosedTicketSolutions.EntryText FROM ClosedTickets LEFT JOIN Technicians ON ClosedTickets.Tech_ID = Technicians.Tech_ID LEFT JOIN Locations ON ClosedTickets.Location_ID = Locations.Location_ID LEFT JOIN ClosedTicketSolutions ON ClosedTickets.TicketNum = ClosedTicketSolutions.TicketNum WHERE (ClosedTickets.FirstName LIKE '%John%') ORDER BY ClosedDate Desc, ClosedTicketSolutions.EntryDate, ClosedTicketSolutions.Entry_ID One thing that I'm not able to do right now is search both open and closed tickets at the same time. I don't think a union would work in my case. So I'm wondering if I should store the open and closed tickets in the same table and just have a field indicating whether or not the ticket is closed. The only problem I can forsee is that we have so many closed tickets already (nearly 30,000) so the whole system might perform slowly. Would it be a bad idea to combine the open and closed tickets?

  Read the article

• Profiler tool for web service

  - by Rotem

  Hi, I need a profiler that is able to measure performance of web service execition. Our application has several layers and ideally I would like to be able to dive into each web service request and see how much time was spent in each layer (server, sql server, etc...) Is there a tool that can help detect where are the bottlenecks ? Is that something that can be done using VS Team System Test Edition ?

  Read the article

• Second query to SQLite (on iPhone) errors.

  - by Luke

  Hi all, On the iPhone, I am developing a class for a cart that connects directly to a database. To view the cart, all items can be pulled from the database, however, it seems that removing them doesn't work. It is surprising to me because the error occurs during connection to the database, except not the second time I connect even after the DB has been closed. #import "CartDB.h" #import "CartItem.h" @implementation CartDB @synthesize database, databasePath; - (NSMutableArray *) getAllItems { NSMutableArray *items = [[NSMutableArray alloc] init]; if([self openDatabase]) { const char *sqlStatement = "SELECT * FROM items;"; sqlite3_stmt *compiledStatement; if(sqlite3_prepare_v2(cartDatabase, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) { while(sqlite3_step(compiledStatement) == SQLITE_ROW) { int rowId = sqlite3_column_int(compiledStatement, 0); int productId = sqlite3_column_int(compiledStatement, 1); NSString *features = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 2)]; int quantity = sqlite3_column_int(compiledStatement, 3); CartItem *cartItem = [[CartItem alloc] initWithRowId:rowId productId:productId features:features quantity:quantity]; [items addObject:cartItem]; [cartItem release]; } } sqlite3_finalize(compiledStatement); } [self closeDatabase]; return items; } - (BOOL) removeCartItem:(CartItem *)item { sqlite3_stmt *deleteStatement; [self openDatabase]; const char *sql = "DELETE FROM items WHERE id = ?"; if(sqlite3_prepare_v2(cartDatabase, sql, -1, &deleteStatement, NULL) != SQLITE_OK) { return NO; } sqlite3_bind_int(deleteStatement, 1, item.rowId); if(SQLITE_DONE != sqlite3_step(deleteStatement)) { sqlite3_reset(deleteStatement); [self closeDatabase]; return NO; } else { sqlite3_reset(deleteStatement); [self closeDatabase]; return YES; } } - (BOOL) openDatabase { if(sqlite3_open([databasePath UTF8String], &cartDatabase) == SQLITE_OK) { return YES; } else { return NO; } } - (void) closeDatabase { sqlite3_close(cartDatabase); } The error occurs on the line where the connection is opened in openDatabase. Any ideas? Need to flush something? Something gets autoreleased? I really can't figure it out. --Edit-- The error that I receive is GDB: Program received signal "EXC_BAD_ACCESS". --Edit-- I ended up just connecting in the init and closing in the free methods, which might not be the proper way, but that's another question altogether so it's effectively persistent instead of connecting multiple times. Still would be nice to know what was up with this for future reference.

  Read the article

• Rails, ActiveRecord, how to find foreign rows that are NOT there?

  - by randombits

  The title is a bit difficult to put together for this question. Say I have two models, Foo and Bar. Foo has many Bar's. Bar belongs to one Foo. How do I use Foo.find to find all of the Foos that currently have zero Bars? In SQL this would translate into something like: SELECT * from foo where id NOT IN (select foo_id from bar);

  Read the article

• How to get the top most parent in PostgreSQL

  - by wereach

  I have a tree structure table with columns: id,parent,name. Given a tree A-B-C, how could i get the most top parent A's ID according to C's ID? Especially how to write SQL with "with recursive"? Thanks!

  Read the article

• C# Reading a file and writing out replacing string

  - by Mike

  What I have is a C# windows app that reads a bunch of SQL tables and creates a bunch of queries based on the results. What I'm having a small issue with is the final "," on my query This is what I have ColumnX, from I need to read the entire file, write out exactly what is in the file and just replace the last , before the from with nothing. I tried .replace(@",\n\nfrom),(@"\n\nfrom) but it's not finding it. Any help is appreciated. Example: ColumnX, from Result: ColumnX from

  Read the article

• Table Adapter query Builder ASP.NET

  - by kmsony32

  I want to connect my Table adapter with the Oracle, for that I am preparing a sql query with the query builder. The query which is running fine in Oracle but makes syntax error with query builder.It shows unable to parse the query text. I am using case statement and joins within the query.

  Read the article

• Hibernate SessionFactory getCurrentSession returns null

  - by newbie

  Log file shows that when I start my war, there are no errors. When I try to get Session with SessionFactory it returns null. I'm using SQL Server 2008.

  Read the article

• Rails3 nomethod error #<ActiveRecord::Relation>

  - by Dodi

  Hi! I'm writing a static page controller. I get the menuname in the routes.rb and it's call the static controller show method. match '/:menuname' = 'static#show' And static_controller.rb: @static=Staticpage.where("menuname = ?", params[:menuname]) But if I want print @static.title in the view, I get this error: undefined method `title' for # Whats wrong? the SQL query looks good: SELECT staticpages.* FROM staticpages WHERE (menuname = 'asd')

  Read the article

• MySQL select/where statement

  - by expo101

  I have a webapplication linked to a mysql database with the following fields: field 1:trip_id field 2:trip_destination field 3:trip_description field 4:trip_duration In the webapplication I have a listbox based on the following: ListBox value =1: trip duration 1 - 5 days ListBox value =2: trip duration 6 - 10 days Listbox value =3: trip duration 11 -20 days ListBox value =4: trip duration over 20 days How do I put this in the sql select statement?

  Read the article

• =& operator in PHP

  - by Sapphire

  Example: $this-sql =& new GuestBook_SQL; What does it do?

  Read the article

• Sanitize GET query with Apache

  - by Freelancer

  Hello everyone, I see there's a lot of talk here about how to go about sanitizing data. Could it be as simple as adding this rewrite rule to .htaccess? RewriteRule ^([\w\-]+)$ index.php?page=$1 To my understanding this will allow only letters, numbers, _ and - in $1, am I right? If you add to this usage of prepared statements for SQL queries, it should be pretty proof, is that right? Somehow feels like too easy to be true, am I missing something, any ways to firm it up?

  Read the article

• How can I extract a range of lines from a text file on unix?

  - by Adam J. Forster

  I have a ~23000 line sql dump containing several databases worth of data. I need to extract a certain section of this file (i.e. the data for a single database) and place it in a new file. I know both the start and end line numbers of the data that I want. Does anyone know a unix command (or series of commands) to extract all lines from a file between say line 16224 and 16482 and then redirect them into a new file?

  Read the article

• how to do this in MySql Query??

  - by deep

  ID NAME AMT 1 Name1 1000 2 Name2 500 3 Name3 3000 4 Name1 5000 5 Name2 2000 6 Name1 3000 consider above table as sample. am having a problem in my sql query, Am using like this. Select name,amt from sample where amt between 1000 and 5000 it returns all the values in the table between 1000 and 5000, instead I want to get maximum amount record for each name i.e., 3 name3 3000 4 name1 5000 5 name2 2000

  Read the article

• NHibernate - Is there a way to prevent version increment?

  - by Alice

  For performance reasons, sometimes I want to update entities without any version increment(or version check). With LINQ TO SQL, I just left the version unchanged and it worked fine. Is this behavior possible in NHibernate?

  Read the article

• Updated: How to span multile tables in Django for a backwards relationship

  - 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

• [C#] RegEx search for two pattern strings and cut what's between

  - by gsharp

  I'm trying to write a little SQL Helper. I have a query like this stored in a string: DECLARE @V1 INT --ignore DECLARE @V11 INT DECLARE @V12 INT --endignore DECLARE @V2 INT --ignore SELECT * FROM SampleTable INNER JOIN AnotherSampleTable ...... --endignore SELECT * From Employee ORDER BY LastName My helper method should cut everything what's between --ignore and --endignore The result string should look like: DECLARE @V1 INT DECLARE @V2 INT SELECT * From Employee ORDER BY LastName How can achieve my result with RegEx?

  Read the article

• How to access ASP.NET App Over a Network Using IP Address

  - by john doe

  My asp.net web app is hosted on this URL on my local machine: http://localhost:45433/ I want to access the same application from a different computer on the network. I tried replacing the localhost with my IP but it did not work. any ideas! UPDATE 1: Now, I am getting this error: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

  Read the article

< Previous Page | 988 989 990 991 992 993 994 995 996 997 998 999  | Next Page >