Search Results

Search found 23568 results on 943 pages for 'select'.

Page 472/943 | < Previous Page | 468 469 470 471 472 473 474 475 476 477 478 479  | Next Page >

• Retrieve list of indexes in an Access database

  - by waanders

  I know there's a way to get a list of all tables in an Access database by using the quering the MsysObjects: "SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<'~') AND (Left$([Name],4)<'Msys') AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name" Does anybody know a similar (or other) way to retrieve a list of all indexes in an MS-Access database?

  Read the article

• Java, dBase microsoft driver and deleted flag

  - by blow

  Hi, im connecting to dBase from java with this string: String url="jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ="+databasePath+";DefaultDir="+databasePath+";DriverId=533;FIL=dBase IV;MaxBufferSize=2048;PageTimeout=5;"; Work fine, but with a SELECT statement i can retrieve only record that are not "deleted". In dBase database deletet record are only flagged deleted, so i want retrive deleted record too. Is this possibile? Thank.

  Read the article

• Reference data using @ModelAttribute

  - by Eqbal

  I am trying to populate couple of select lists on a form and I am using @ModelAttribute to annotate the get method for these lists. I am getting an exception when I try to access the resource: java.lang.IllegalStateException: Neither BindingResult nor plain target object for bean name 'command' available as request attribute

  Read the article

• Django templates check condition

  - by Hulk

  If there are are no values in the table how can should the code be to indicate no name found else show the drop down box in the below code {% for name in dict.names %} <option value="{{name.id}}" {% for selected_id in selected_name %}{% ifequal name.id selected_id %} {{ selected }} {% endifequal %} {% endfor %}>{{name.firstname}}</option>{% endfor %} </select> Thanks..

  Read the article

• Set Android Gallery widget to show specific starting image

  - by Dalmazio Brisinda

  Hi all, I have a task where the user can select an image from a GridView representing a photo album, and from this I start a new activity which displays a Gallery widget to show the images of the photo album. However, I can't seem to get the Gallery widget to show the contents of the photo album with a given image as the starting point. Ideally I would like a Gallery#setStartingImage(int position) or something similar. Any ideas would be greatly appreciated. Best, Dalmazio

  Read the article

• Problem reading from 3 tables in mysql

  - by user225269

  What do I do, I need to fetch data from 3 tables in mysql, here is my current query. All of the tables contain the IDNO which has 03A45 number. But this query isnt returning any results: SELECT * FROM father, mother, parents WHERE father.IDNO=mother.IDNO=parents.IDNO AND mother.IDNO='03A45' AND father.IDNO='03A45' AND parents.IDNO='03A45' What would be the correct query for this? All of the tables have the IDNO as primary key.

  Read the article

• ID/Class Selector

  - by Ionut Staicu

  Hi. I have some kind of problem with jQuery selectors. Let's say i want to select $('#elementID') but the elementID is a variable. There is any other possiblity to do this other way than var variable = elementID; $('#'+variable) ? I mean without specifying the # anywhere else? Thanks!

  Read the article

• How to declare a variable in SQL Server and use it in the same Stored Procedure

  - by Nicklas

  Im trying to get the value from BrandID in one table and add it to another table. But I can't get it to work. Anybody know how to do it right? CREATE PROCEDURE AddBrand AS DECLARE @BrandName nvarchar(50), @CategoryID int, @BrandID int SELECT @BrandID = BrandID FROM tblBrand WHERE BrandName = @BrandName INSERT INTO tblBrandinCategory (CategoryID, BrandID) VALUES (@CategoryID, @BrandID) RETURN

  Read the article

• Is there a jQuery selector to check if a tag has any attributes?

  - by Ektron Doug D

  In trying to select elements that have any attributes, the following throws a jQuery syntax error. $("div[*]") Is there a selector to check if a tag has any attributes? Tested with jQuery 1.3

  Read the article

• Keyboard layout change in cocoa application

  - by frederic

  Hi , I'm a newbie, I'm trying to learn objective-c.I have developed a small application which accepts user input and saves it in sqllite. Curently my application supports only english keyboard layout. I have put radiobutton with options English and Danish. On option select the keyboard layout should change to desired on and accept the input. Can anybody help be outwith this. Thank in advance.

  Read the article

• restrict customer lookup to contacts bug

  - by Amr H. Abdel Majeed

  I'm using microsoft dynamics crm 4 I inserted the following line to restrict a customer lookup to contacts only (no accounts): crmForm.all.customerid.setAttribute("lookuptypes", "2"); It does restrict the lookup to contacts only, but there is a strange bug: When i select any customer, the icon next to him becomes the account icon, not the contact icon (folder instead of card) Any solutions to this ?

  Read the article

• How to install WE8EBCDIC500 on Oracle XE?

  - by wishihadabettername

  I need to make the "WE8EBCDIC500" character set available in an Oracle XE installation (on my desktop) to import a mainframe-generated file. Running SELECT value FROM v$nls_valid_values WHERE parameter='CHARACTERSET' does not show this character set to be installed and I get KUP-03006: error initializing handle for character set WE8EBCDIC500 when attempting to use it. How can this be done? Thanks.

  Read the article

• Can I configure an SQL Server 2008 DB so that it will save all empty strings as NULLs?

  - by Ivan

  In my current project it would be convenient to exclude empty strings from the domain, so that is an empty string is met wherever, it is treated as NULL, for example if I UPDATE [table] SET [Something]='', SQL Server should treat it as SET [Something]=NULL, so that in next SELECT a NULL is returned as [Something] value. Should I use triggers or there is a better way?

  Read the article

• Setting User language for Localization/Globalization

  - by Nadeem

  I need to select the language based on the user choice and set it for the entire session. Can anybody suggest where do i need to do these settings and how can i do this?

  Read the article

• How to order by column with non-null values first in sql

  - by devlife

  I need to write a sql statement to select all users ordered by lastname, firstname. This is the part I know how to do :) What I don't know how to do is to order by non-null values first. Right now I get this: null, null null, null p1Last, p1First p2Last, p2First etc I need to get: p1Last, p1First p2Last, p2First null, null null, null Any thoughts?

  Read the article

• MySQL column not found

  - by vian

  The SQL query without where statement runs great and outputs good results, but when I include WHERE condition it shows Unknown column 'date1' in 'where clause'. What's the problem? SELECT IF(e.weekly, DATE_ADD(DATE(e.time), INTERVAL CEIL(DATEDIFF('2010-04-08', e.time)/7) WEEK), DATE(e.time)) AS `e.date1`, `v`.`lat`, `v`.`lng` FROM `events` AS `e` INNER JOIN `venues` AS `v` ON e.venue_id = v.id WHERE e.date1 > '2010-09-01'

  Read the article

• using SET datatype in mysql

  - by Dan Snyder

  Is it possible to set a varaible to a query result such as: DECLARE result INT; SET result = (SELECT index FROM table WHERE data = 'xxxx' LIMIT 1); Assuming of course you know that there will only be one result set

  Read the article

• NHibernate MySQL Mapping Set Column Type

  - by LnDCobra

  In my MySQL database, I have the following column type. Field | Type | Null | ---------------------------------- Column_priv | set('Select','Insert','Update','References') | No | And I cannot figure out what to map this to. Can anyone tell me how I can map this to something?

  Read the article

• [Java Stripes] How can I use List of object with Stripes "option" tag ?

  - by cscsaba242

  Hello, I have a List of object, produced by JPA q.getResultList(). I would like to use it in a drop down, but Stripes "option" tag cant accept List, just Collection, Enum and Map. Im new to Java, that why perhaps the List can translated to each of them but I dont know how can I solve this issue. (Stripes select,option-map,-enumeration, -collection can build up a drop down from previous mentioned input object structures ) Thanks advance

  Read the article

• Help speed this MySQL query which is taking too long because of an aggregate function

  - by Joseph

  Hi all, I am using a following query in MySQL for fetching data from a table. Its taking too long because the conditional check within the aggregate function.Please help how to make it faster SELECT testcharfield , SUM(IF (Type = 'pi',quantity, 0)) AS OB , SUM(IF (Type = 'pe',quantity, 0)) AS CB FROM Table1 WHERE sequenceID = 6107 GROUP BY testcharfield

  Read the article

• Keep rows hidden even when a table filter option is selected in Excel2007

  - by Srin

  I have a Excel Table (Range formatted as table) I have some rows set as Hidden in the table. the table header have filter option and when i select a filter item, the hidden rows are becoming visibe. Is there any option / vba method to keep the hidden rows hidden ? Ideas pls....

  Read the article

• MYSQL query to return rows that are NOT in a set

  - by iglurat

  Hi, I have two tables: Contact (id,name) Link (id, contact_id, source_id) I have the following query which works that returns the contacts with the source_id of 8 in the Link table. SELECT name FROM `Contact` LEFT JOIN Link ON Link.contact_id = Contact.id WHERE Link.source_id=8; However I am a little stumped on how to return a list of all the contacts which are NOT associated with source_id of 8. A simple != will not work as contacts without any links are not returned. Thanks.

  Read the article

• Filtering out page content with AJAX in Sitecore

  - by RaYell

  I have a page in Sitecore that displays the list of clients. There's a form with two select boxes that should filter out clients not matching specified criterias. Clients list should be refreshed via AJAX everytime user changes one of the values in the form or after clicking Submit button if JS is disabled. What is the suggested approach I should take to have this working in Sitecore? I'm not sure about Sitecore part, I know how to call AJAX methods/

  Read the article

• Windows batch file: choosing a file from a directory based on directory name

  - by Stefan Kendall

  I don't do windows batch programming, nor do I need to go that far down the rabbit hole. I have directory structures as such: dir1000000/file.txt dir2000000_1/file.txt dir2000000_2/file.txt I need to select the file.txt from the path with the lexicographically greatest value, i.e. dir2000000_2/file.txt. How do I go about doing this?

  Read the article

• jQuery Text to Link Script?

  - by Elijah Manor

  Does anyone know of a script that can select all text references to URLs and automatically replace them with anchor tags pointing to those locations? For example: http://www.google.com would automatically turn into <a href="http://www.google.com">http://www.google.com</a> Note: I am wanting this because I don't want to go through all my content and wrap them with anchor tags.

  Read the article

< Previous Page | 468 469 470 471 472 473 474 475 476 477 478 479  | Next Page >