Search Results

Search found 33242 results on 1330 pages for 'database optimization'.

Page 914/1330 | < Previous Page | 910 911 912 913 914 915 916 917 918 919 920 921  | Next Page >

• MS Access Import from Text File problems

  - by Gavin O'Brien

  I'm trying to import a text file into an access database. It's not one I've written myself but the spec for the delimited text file is set up properly and the file imports properly using the wizard. When I try to use the import functions of the app itself, the ImportError table tells "Field Truncation" for one of the fields. Any help would be appreciated.

  Read the article

• Help getting the following create table function to work with mysql and C#

  - by Matt

  string createTable = "CREATE TABLE IF NOT EXISTS " + m_strDatabase + "_TimeLogs (logName VARCHAR(16), logTime INTEGER, logCountry TEXT, UNIQUE(logName)) TYPE=MyISAM;"; When this runs, no table is created. No errors either. Im using an ODBC connector. the variable passes in the db name, so that the table created would be users_TimeLogs if the database was called users for example. Am I doing something wrong?

  Read the article

• Selecting rows distinctively

  - by noway

  Lets assume my database table structure is something like | items | weight | |============|==========| | item_1 | 50 | | item_2 | 90 | | item_2 | 45 | | item_2 | 60 | | item_3 | 40 | In the select statement, I want to show an item only for once with the highest weight also ordered by height. So the result should be : | items | weight | |============|==========| | item_2 | 90 | | item_1 | 50 | | item_3 | 40 | I tried something like SELECT DISTINCT items, weight FROM mytable ORDER BY weight DESC but it didn't work because the results are actually distinct. How can I make that selection?

  Read the article

• Convert date in text format to datetime format in T-SQL

  - by Rob

  I have a client supplied file that is loaded in to our SQL Server database. This file contains text based date values i.e. (05102010) and I need to read them from a db column and convert them to a normal date time value = '2010-05-10 00:00:00.000' as part of a clean-up process. Any guidance would be greatly appreciated.

  Read the article

• why should i use single quotes for application.run in excel?

  - by every_answer_gets_a_point

  i have this: Application.Run ("'L:\database\lcmsmacro\macro1.xlsm'!macro_name") why should i use the single quotes? does it not recognize the backslash?

  Read the article

• How much to put in a Repository class?

  - by chobo

  When using the repository pattern is it recommended to have one Repository class for each database table? Would I also map one service layer class to one repository class. I'm having a hard time trying to understand how much stuff one repository or service layer class should have. Thanks!

  Read the article

• Reduce the number of additional Queries to 0 by overriding functions in the base model

  - by user334017

  my basic database setup is: User:... Info: relations: User: { foreignType:one } When displaying information on the user it takes: 1 query to find info on the user, and 1 query to find additional info I want to reduce this to one query that finds both, I assume I need to override a function from BaseUser.class.php, or something along those lines but I'm not really sure what to do. Thanks!

  Read the article

• my sql insert query not working

  - by Piyush

  I am inserting userId.It is displaying correct but inserting 0 in spite of actual userId. mycode- If(! empty($userIDToCheck) || $userIDToCheck != '' ) { echo $userIDToCheck; $sql = "INSERT INTOpnpdb.ruser(userid) VALUES ('$userIDToCheck');"; mysql_query($sql)or die(mysql_error()); echo "Done"; } Output : pi203713 Done But is database it is inserting "0"???

  Read the article

• How can I save objects as XML files

  - by iTayb

  I'm working on my high-school matriculation asp.net project, and I wish to make a website of a bookstore. I want to create two classes,Book and BookStore, and save the data created in XML files and not in a database. How can I save objects as XML files, and how can I load them afterwards? Thank you very much.

  Read the article

• MSSQL SQL Building Software

  - by TheGambler

  What are the option in terms of applications that help build SQL statements against a MSSQL database? We have some users that need to build sql statements, perferably through drag and dropping or linking up tables etc.., against a MSSQL databse who don't have any experience in this area. Any Ideas?

  Read the article

• MySQL DATE_FORMAT comparison to CURDATE() query...

  - by Crazy Serb

  Hey guys, I am just trying to pull all the records from my database who have a rec_date (varchar) stored as m/d/Y and are expired (as in, less than curdate()), and this call isn't giving me what I want: SELECT member_id, status, DATE_FORMAT(STR_TO_DATE(rec_date, '%m/%d/%Y'), '%Y-%m-%d') AS rec FROM members WHERE rec_date CURDATE() AND status = '1' I'm obviously doing something wrong, so can you help? Thanks.

  Read the article

• PHP Session Management, Counting Users With Cookie

  - by Nik

  I want to, upon loading the page, store a cookie in the user's browser. Then, using AJAX, count the number of users with that cookie and send it off to a database row every 1 second or so. How is this accomplished?

  Read the article

• how can I reset field after check it with php

  - by mjd

  Hi all, I have a html form that sends the data from 2 fields (memer no. , pw) via axaj (getElementById)to php file to check them with database info. . I did every thing well but I want to reset both fields if one of them is incorrect . How can I send reset order back to html form ? notice - I didn't use submit button just normal button to keep in same page. Thanks all

  Read the article

• Where can i find this admin addon for OSCOMMERCE?

  - by OM The Eternity

  i want an addon for admin that i can search in my database for my costumers. I want to have 4 tapes of search by customer name (he search in the customer created account, in shipped address or invoice name address if he change after he create account) by address by phone number by email address

  Read the article

• How can I tell that a domain transfer has been successful?

  - by Kieran

  I'm currently transferring from Fasthosts (UK) to 123-reg. Whe WHOIS database says the domain is with 123-reg, but it isn't. Has something gone wrong here, or does it just take a while? Also, will the domain disappear from my Fasthosts control panel when the transfer is complete? Many thanks

  Read the article

• displaying jpg image via jquery ajax call

  - by Sobek

  Hi, I want to show images that are requested from a binary field (blob) out of a mysql database. They are retrieved by a PHP script and outputs a 'real' jpeg image i.e. header('Content-Type') = 'image/jpeg'. This is working. But how can i intercept this image that is being made by an ajax call ?

  Read the article

• Connection to mysql works through php but not through a form submission?

  - by Legend

  I have a download.php file that connects to a remote mysql database. If I run it using php download.php it works fine. But if I create another php file form.php and then submit the form to this download.php, it complains the following: Can't connect to MySQL server on '<IP_ADDRESS>' (13) Does anyone know why this might be happening? I can't see a reason why this works directly but fails to work upon form submission...

  Read the article

• How do I TRUNCATE TABLE using Django orm?

  - by Silver Light

  Hello! To empty database table, I use this SQL Query: TRUNCATE TABLE `books` How to I Truncate table using Django models and orm? I've tried this, but it doesn't work: Book.objects.truncate()

  Read the article

• Delete document with an empty ID

  - by Damien MATHIEU

  Hello, I have a CouchDB database in production. One of the documents has been edited (in Futon by an other developer). And it's lost it's ID (don't ask me how he did it). So now the document's id is an empty string, which makes it impossible to edit or delete via Futon. Is there a way I could hack into CouchDB to delete that document anyway ?

  Read the article

• If there is a necessary data base

  - by Dmitry

  Hello! I have a desktop program which uses an embedded data base mechanism. For the first time a user will execute a program, it must create a database. So that, next time there is a data base and there is no need to create it. Please, tell me, how to chech if there is a necessary data base.

  Read the article

• python intercepting communication

  - by nabizan

  lets say you run third party program on your computer whitch create a process named example.exe how do i determinate if this process is running and how many windows does he open? How do i intercept network communication between this windows and server? my goal is to create an app whitch will be monitoring network trafic between example.exe and its home server in order to analyze data and save to database, and finally simulate user interaction to get more relevant data

  Read the article

• How to Run PHP Pages in CAKEPHP?

  - by suresh

  i configured database in xampp. but i don't know no how to run php pages in cake php .

  Read the article

• how to send multiple row to mysql at same time(like bulk copy)?

  - by Ayyappan.Anbalagan

  I am using asp.net + Mysql. I have multiple rows in my dataset; I have to store the rows in my database table. How to do that?

  Read the article

• Fastest and most efficent way of seaching a key-value pair in Java?

  - by Mohit Deshpande

  DISCLAIMER: THIS QUESTION WAS NOT MENT TO BE ARGUMENTATIVE!!!!!!! What is fastest and less memory draining way of searching a key-value pair? I will be storing items in a key-value like relation and I need to access them quickly. Should I use a SQLite database? A Map? A Hashtable? A HashMap? Please give some advantages/disadvantages of using whatever method of searching.

  Read the article

• find all text before using regex

  - by jeff

  How can I use regex to find all text before the text "All text before this line will be included"? I have includes some sample text below for example This can include deleting, updating, or adding records to your database, which would then be reflex. All text before this line will be included You can make this a bit more sophisticated by encrypting the random number and then verifying that it is still a number when it is decrypted. Alternatively, you can pass a value and a key instead.

  Read the article

< Previous Page | 910 911 912 913 914 915 916 917 918 919 920 921  | Next Page >