Search Results

Search found 30606 results on 1225 pages for 'database relations'.

Page 805/1225 | < Previous Page | 801 802 803 804 805 806 807 808 809 810 811 812  | Next Page >

• Subsonic SELECT FROM msdb

  - by Lukasz Lysik

  Hi, I want to execute the following query using Subsonic: SELECT MAX([restore_date]) FROM [msdb].[dbo].[restorehistory] While the aggregate part is easy for me, the problem is with the name of the table. How should I force Subsonic to select from different database than default one.

  Read the article

• Is it possible to have a local group for an LDAP user

  - by fakedrake

  I have an LDAP server to which i do not have full privileges and an ubuntu system with LDAP authentication to which i am root. Is it possible to add an LDAP user to a local group? (i dont know if i phrase this correctly but all i want is to have a user in LDAP in a group without edititing the actual database)

  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

• need explanation for this MySQL query .

  - by Sachindra

  I just came across this database query and wonder what exactly this query does..Please clarify .. select * from tablename order by priority='High' DESC, priority='Medium' DESC, priority='Low" DESC;

  Read the article

• Using PHP to populate a <select></select> ?

  - by Flins

  <select name="select"> </select> I want to populate the above tag with values from database. I have written php code up to this. while($row=mysql_fetch_array($result)) { } $row is fetching fetching correct values.. how to add it to the <select> please help... Am new to programming

  Read the article

• Access.Application.CurrentDb is Nothing?

  - by Allain Lalonde

  I'm at a loss to explain this one: I'm getting an error "91" (Object or With block not set) on the second line below: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM employees") The following also causes it: Set rs = CurrentDb.OpenRecordset("employees") Executing ?CurrentDb.Name alone in the immediate window causes the error as well. Now, clearly the database is open since I'm editing the form within it, so what can cause this error here?

  Read the article

• Pass windows authentication username to asp variable

  - by Darren Cook

  Hi, I have a site that processes orders taken by phone into a SQL database. Access to the portal uses Windows Authentication and I would like to pass the username of the order processor along with the order so that I can record who has taken the order. How can I pass the user name to a form element? The pages are written in classic asp. Thanks.

  Read the article

• Programmatically determine whether to describe an object with "a" or "an"?

  - by MarathonStudios

  I have a database of nouns (ex "house", "exclamation point", "apple") that I need to output and describe in my application. It's hard to put together a natural-sounding sentence to describe an item without using "a" or "an" - "a house is BIG", "an exclamation point is SMALL", etc. Is there any function, library, or hack i can use in PHP to determine whether it is more appropriate to describe any given noun with A or AN?

  Read the article

• mysql on xp performance issues

  - by dave

  Please could you let me know if there are any performance issues with using mysql on windows xp. The mysql serves over 10 client server apps, which query the database simultaneously

  Read the article

• Way to generate a code that creates a constructor based on the current values of an object?

  - by burak ozdogan

  Hi, What I want to achieve is after loading my object from the database, to generate a code that will give me a block which initializes my object based on its current values so that I can use this code-block in my unit tests again and again without loading it from Db anymore. Is there any tool around to achieve such a goal for VS? thanks

  Read the article

• Using ASP.Net GridView Update Command for specific fields

  - by kenom

  How do I use the Update command in GrideView? I would like to use update command for specific fields in the dataset, but not all fields from database ( or maybe in GridView? )

  Read the article

• Explaining your system to a client

  - by Sir Graystar

  I'm currently developing a small Database Management System for a local company. How would you go about explaining how the system you have designed to a client? If they are non-technical and have no understanding of programming, how would you go about showing what the system will do and how it will do it? I guess some sort of visual representation of the system but this seems very patronising to me.

  Read the article

• Different databases using WCF dataservice

  - by espenk

  I have multiple SQL Server databases with the same schema. I would like to use one WCF data service (Rest service) to access the different databases. How can I accomplish this so the client can pass in the correct database name or connection string?

  Read the article

• MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my

  - by asksuperuser

  I am currently adding hundred of thousands of rows of data to a table first on a MS Access Table then on a MySQL Table. I first tried with MS Access, it tooks less than 40 seconds. Then I tried exactly with the same source and with the same table structure to MySQL and it took 6 min and 40 seconds that is 1000% slower !!! So is there a myth that a database server is more performant ?

  Read the article

• Unserialize data and check it against an id in MySQL

  - by kylex

  I have a row of IDs in a database that has been serialized. What I'm trying to do is check those serialized IDs against a known ID to see if it should be excluded or not. for example: "SELECT * FROM mydb WHERE id = 4 AND checkID != 'an id in the serialized column' " What's the best way to go about this?

  Read the article

• want to fill a textbox dynamically in jsp page

  - by Atul

  want to create a application using jsp pages such that it takes a value from user in a textbox and on the basis of that value it retrives other values from database and fill other textboxes with that retrived values

  Read the article

• select top 50 records from sql

  - by air

  i have following database table name tbl_rec recno uid uname points ============================ 1 a abc 10 2 b bac 8 3 c cvb 12 4 d aty 13 5 f cyu 9 ------------------------- ------------------------- i have about 5000 records in this table. i want to select first 50 higher points records. i can't use limit statement as i am already using limit for paging. Thanks

  Read the article

• Dynamic picture that displays the visitors IP address?

  - by Rob

  I see this a lot now, jpg files displaying your IP address. To you of course, not to others, they would see their own For example: How is this even possible? If this is possible, would it be possible to log an IP into a MySQL database from the picture as well? Is my IP getting logged when I view this?

  Read the article

• Java application on windows server possibility?

  - by Shawn Mclean

  I'd like to know if it is possible to have this application (neo4j) running on windows server 2008 alongside an asp.net mvc application. Reason for this, I need to access the graph database (neo4j) which provides a RESTful service from my mvc application. How would I go about setting up this architecture?

  Read the article

• To get which function/line threw exception in javascript

  - by uzay95

  I am trying to create a Exception class to get and send errors from client to server. I want to catch exception in javascript function and push the details to the web service to write to database. But i couldn't get how to get which function/line throwed this exception. Is there any way to solve this?

  Read the article

• SQL Alter Table to Add a Column, does it do anything "scary"?

  - by Pselus

  I need to add a column to an existing table in my live sql database. I know how to use the ALTER command, but what I want to know is the effect this has on the table. For example,, if using SQL Management Studio, it claims that adding a column will "drop and recreate" the table. Will the ALTER table command do that as well? This table is CONSTANTLY accessed and VERY important so I want to make VERY sure of this before going forward.

  Read the article

• How to auto insert the current user when creating an object in django admin?

  - by FurtiveFelon

  Hi all, I have a database of articles with a submitter = models.ForeignKey(User, editable=False) Where User is imported as follows: from django.contrib.auth.models import User. I would like to auto insert the current active user to the submitter field when a particular user submits the article. Anyone have any suggestions?

  Read the article

• how to execute Sql Raw Query in Microsoft Entity Model Framework.

  - by kamal

  Hi I'm using Microsoft Entity model framework to access my database. I get an issue while i use this execute query command for executing Sql raw query. Let me know how could i resolve it. svdc.CreateQuery("select * from videomastertable WHERE FREETEXT(*, '"+keyword+"')").ToList(); Thanks in Advance, Kanal

  Read the article

• Using hyperlink control with imagefield control in gridview

  - by niks

  I have a gridview and a column of that gridview is displaying images whose path is stored in a database & image is stored in locale folder inside my website. My problem is that I want to use the hyperlink control with the image, so that when the image is clicked it should jump to another page. How can I do that?

  Read the article

• What is Best way to obtain filename for HTML FILE Uploading on forms?

  - by CitadelCSAlum

  I need to obtain the String for the file that is being uploaded from forms to store in the database. I am using the usual form input file element input type="file" name="some_name" I found a couple JS scripts that allow me to do useless things like display the string in a dialog box, etc. I need this as an element on the request object or as a hidden field on my page when the form is posted.

  Read the article

< Previous Page | 801 802 803 804 805 806 807 808 809 810 811 812  | Next Page >