Hi! Very weird problem. Saving email addresses to my database, but when I query those emailaddresses it shows up as name@ instead of [email protected]. I suspect some internal filtering going on but have no idea how to solve it. CREATE TABLE `bredeschool`.`users` ( `userID` smallint(6) NOT NULL AUTO_INCREMENT, `gebruikersnaam` varc...
Hi, I need some help joining two table. I've got: my_type_table, which has columns: type (VARCHAR) latitude (decimal) longitude (decimal) ...and neighborhood_shapes, which has columns: neighborhoods (VARCHAR) neighborhood_polygons (geometry) I've got a function called myWithin which checks the latitude and longitude to see whet...
I need to do a SELECT for a product_id where the length the product_id is 4 characters long and the last character can be any letter. I know the wildcard for selecting any letters but I don't know how to denote that it has to be the last character and that the product_ids I'm looking for must be 4 characters long. Does that make sense?...
Will the order of the record retrieved using a select query, be in the same order if retrieved infinite number of times, each time using a new connection? (to the same table, same select) What order method is used when none is specified? ...
hi guys, here is the connection i have strCon="DBQ=" & Server.Mappath("db.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};PWD=password;" set adoCon=server.createobject("adodb.connection") adoCon.Open strCon so in order to work with the 2 databases i have 2 adoCon and when i do the select i select from each db i need now for the p...
My goal is to return a start and end date having same value in a column. Here is my table. The (*) have been marked to give you the idea of how I want to get "EndDate" for every similar sequence value of A & B columns ID | DayDate | A | B ----------------------------------------------- 1 | 2010/07/1 | 200 | 300 2 | 2010/07/2 | 2...
Hello, how can i count the number of days between (sysdate) & a column called hiredate in PL/SQL. Thanks. ...
The fake code is: public class ParentClass { decimal quantity, decimal price } IQueryable<ParentClass> parents; //SonClass is created at run time //SonClass has some extra property, such as amount=quantity*price, which is defined by a string at run time IQueryable<SonClass> sons=parents.Select(p=>new S...
I want a query to create a one row table with as many columns as there are rows in a table returned from a SELECT query., where the columns created have names which are values taken from some column of the SELECT query, and have values which are values taken from some other column of the SELECT query. e.g. If I have a table T1 with two...
I have to filter orders which do not have a specific product. It is simple, but the problem is that every order could have many lines, containing different products. Here is an example of my data: ID | Product | Customer | Quantidy | Date 1 | Apple | Alex Sorensen | 3 | 17.4.2009 2 | Orange | Alex Sorensen | 1 ...
I am working on a application. It is in its initial stage so the number of records in table is not large, but later on it will have around 1 million records in the same table. I want to know what points I should consider while writing select query which will fetch a huge amount of data from table so it does not slow down performance. ...
Hi, I am trying to add a class to some of my dojo.filterselect in order to color them in Blue. Does anyone know how to do that? thanks, Alon ...
Hello, How can I get all the Days of the previous month in PL/SQL ? Thanks. ...
I want to append: selected="selected" to an option in my dropdown if my session value is equal to the value of the option. Example: if($_SESSION['sms-timezone'] == 'Africa/Abidjan') append selected="selected" where option value="Africa/Abidjan" <select> <option value="Africa/Abidjan"> Africa/Abidjan( +00:00 GMT ) </option> <optio...
Title pretty much says it all, I have a dynamically generated Dijit.Form.Select element. I have been trying all kinds of CSS workarounds but the only browser that seems to tolerate what ever I try is Firefox. Does anybody know the correct way to set the the width of this element. I use span tags rather than the regular select/option...
This will work in US regional settings table.Select("[Date] = "#04/16/1984#" This should work in german regional settgins but it thorws dateformat excpetion table.Select("[Date] = "#16.04.1984#" To me it seems that datatable does not understand current regional settings. Is there a way to pass date in a certian format, so it will w...
I have a filtering select emplemented on a large dataset (~10,000) and it works rather well. However, what I would like to do is as the user is typing, display how many records match. So let's say you have the data set: 1A 1B 1C 2A 2B 2C ...and the user types the number 1, the number I would like to return to the users is (3 matches). ...
I currently have a select() statement configured to keep track of two UDP sockers. I send perhaps 10 - 20 messages a second at one general data socket, which is this interpreted as I expected. However, once I hit around 1024 messages, I get the notice: talker: socket: Too many open files talker: failed to bind socket This is lo...
Is there any other way we can get that to work in other browsers? I mean the options still can hovered and the background color changes, is there any event that cause that which we can catch? ...
Hello. I have a list and I show it with s:select without any problem but I want it's header value to be one of list's items and it differs on different runs. something like this: <s:select list="roleList" name="role" headerkey="" headerValue="%{euser.role}" cssClass="textfield"/> value of 'euser.role' is one of 'roleList' items but i...