i.e. if I create a VARCHAR(50) field, what happens if I try to assign it a value that's 100 characters long?
Will SQL Server let me do this? Is it somehow less efficient?
Hi,
I am currently using JQuery's validation plugin for basic form validation such as required fields.
I want to add functionality so that when the user types in the username field, an ajax call is triggered to check whether the username is already taken. My requirements are:
Preferably integrate with JQuery Validation plugin, rather than writing a custom function
I want the lookup to occur on the nkeyup event
I want the lookup to be triggered approx 0.5 seconds after the keyup event has occurred.
Thanks!
Hi,
How do I auto-resize the input type="text" field with jQuery? I want it to be like 100px wide at the start, then make it auto-widening as user inputs text... is that possible?
Can anybody tell me how to persist long text using JPA (I use PostgreSQL)?
Here's the way I defined a very long string in my class:
@Lob
private String body;
However, this produces a field of type charactervarying(255) in the database.
Furthermore, I've tried to use @Column annotation:
@Column(columnDefinition="TEXT")
private String body;
But everything in vain.
I would be gratefull for a helpfull comment on this problem.
Hey guys, im pretty new to android platform and have a really simple question. Im putting buttons as layouts with text boxes, but im running out of room. How would i make it possible for the user to scroll down to view more buttons and stuff. For example, if i have 6 buttons, and 3 are in thefield of view, i wanna be able to scroll with my finger and be able to see those buttons as I scroll.
Thanks for the help guys
-Localgamer
Hi all,
I would like to display priority information in a drop down. Currently i am using a integer field to store the priority, but i would like to display high/medium/low instead of letting user type in a priority.
A way to approximate this is to use a Priority database which stores 3 elements, 1:high, 2:medium, 3:low, but it seems like an overkill.
Any easier way would be much appreciated!
Jason
In many places it's recommended that clustered indexes are better utilized when used to select range of rows using BETWEEN statement. When I select joining by foreign key field in such a way that this clustered index is used, I guess, that clusterization should help too because range of rows is being selected even though they all have same clustered key value and BETWEEN is not used.
Considering that I care only about that one select with join and nothing else, am I wrong with my guess ?
In the following AccessVBA code, I am trying to write a record to a memo field called "Recipient_Display":
oRec1.Fields("RECIPIENT_DISPLAY") = Left(sRecipientDisplayNames, Len(sRecipientDisplayNames) - 2)
When the string contains 2036 characters, the write completes. Above this number I get the following error:
Run-time error'-2147217887(80040e21)':
Could not update; currently locked by another session on this machine.
What is the significance of this number 2036 and is there a property I can adjust that will allow the above update to take place?
Here's the basic idea of what I'm trying to do:
Set the innerHTML of a DIV to some value X
Animate the DIV
When the animation finishes, change the value of X and repeat N times
If I do this in a loop, what ends up happening is, because the animations occur asynchronously, the loop finishes and the DIV is set to its final value before the animations have had a chance to run for each value of X.
As this question notes, the best way to solve this problem is to make a recursive call to the function in the callback handler for the animation. This way the value of the DIV doesn't change until the animation of the previous value is complete.
This works perfectly...to a point. If I animate a bunch of these DIVs at the same time, my browser gets overwhelmed and crashes. Too much recursion.
Can anyone think of a way to do this without using recursion?
When I create a controller with following through Zend_Tool
command:
create controller NameController
... netbeans creates a new controller successfully. BUT, it sends a message in the output window:
PHPUnit is required in order to generate controller test stubs.
How do I get Netbeans to automatically create a class with phpunit testing? I searched the net and thousands solutions so far not able to solve ...
Important Notes:
Have already installed the pear
Already installed phpunit
Already included 'phpunit' in the include_path
Has created a file and includes zf.ini too in the include_path
Options already configured netbeans, where I informed the directory phpunit.bat.
Is it a bug in NetBeans?
See:
ArcGIS 9.3 Arcobject
I wanna select one row of each duplicated SIDs in a field below.
(an attribute table of a shape file)
The priority is R S = I 0
Therefore, among SID 87, FID1 will be selected.
(SID 88, STATUS will be S+I)
(SID 89, FID 6 will be chosen)
Please kindly advise VBA cord to run the selection and thanks.
FID SID STATUS
1 87 R
2 87 O
3 88 I
4 88 S
5 89 I
6 89 R
7 89 I
8 89 S
For this example fromthe MongoDB documentation, how do I write the query using MongoTemplate?
db.sales.aggregate(
[
{
$group : {
_id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" } },
totalPrice: { $sum: { $multiply: [ "$price", "$quantity" ] } },
averageQuantity: { $avg: "$quantity" },
count: { $sum: 1 }
}
}
]
)
Or in general, how do I group by a calculated field?
The certification's cost between $300-400 per exam which is pretty expensive.
I'm still a java newb but eventually I would like to get a job in thefield of computer programming and I'm wondering if the Sun Java certifications would help.
Especially considering that I do not have the time or money to get a degree.
Hi!
I have an optional property of type pfloat, that can either be an encoded numeric value, or -1 if the property is not set. Numerics are encoded to be range searchable (1 is encoded to something like 10000000001), but -1 will always be -1.
How can I search a field for -1?
property:-1 throws parse error and property:'-1' doesn't return anything.
Thanks for help!
I plan to create an interactive golf score card for my website (XHTML). (Btw. thats how such a scorecard looks like: ScoreCard). So at the end one should be able to insert a score for each hole in the appropriated input field in the virtual scorecard on the website. For me it is very important that the interactive scorecard really looks the same as the original (paper-) scorecard does and so my first approach was to scan and slice the scorecard image to reach that appearance.
Here you can see the way I sliced the image:
The idea was to insert HTML text input for each score field ending up with something like this:
After I sliced the image I reconstructed it using the HTML . To do that I put the image slices as the cell background.
<table>
<tr>
<td style="background: url("slice1.jpg") width="58px" height="25px">
<input type="text"></inputText>
</td>
</tr>
...
</table>
At the first moment this worked fine (as Gimp offers quite a nice feature for this). Then the problem was that I had to create a HTML table to create the exact layout. As you can see the lower part of the layout is split up into 3 columns. The middle column is split up into several (for each hole) rows. So the left and right column have to be spanned over those rows. Ok finally that worked, but it lead to some kind of scaling problem. If I zoom in or out on the table the middle column (and only that one) is not scaled the right way. Iam not able to fix this, and so I start doubting if this is the right technique for html image virtualization. Iam really no specialist in the area of creating websites, so I would really appriciate any help on this. Maybe there is a complete other and better technique to do that, as I think it is a common job in webcreation. I couldnt find any nice examples or tuts on that.
I frequently upload CSV files to a MySQL db.
It is very convenient to use LOAD DATA LOCAL INFILE to upload the data, but I can't use this to create the table itself. As of now, the best method I have is to use PHP to get thefield titles fromthe first row of the file and then put together a CREATE table query. Is there a more convenient way to do this?
I have the following xml and I an trying to perform the following
1- Group By the first Field where id="1923" if the value attribute is the same
2- and average all the fields with id="3095" using the value attribute
3- and average all the fields with id="3095" using the value attribute
Trying to produce the following:
Test 1
5.33
5.33
Test 2
3
4
Test 3
4
4
For some reason, when I add a UITextfield as a subview of the contentview of a tablecell, the clearbutton does not align with the text typed in thefield, and appears a bit underneath it. Is there any way I can move the text of the clearbutton to stop this from happening? Thanks for any help,
Yes, i have Myopia and that's really annoying and make me blame myself why i choosen this field. And i think a lot of people like me here.
What did you choose/Or the best choice in order to correct your short-sight?
Glasses
Contacts
Overnight Contacts
Lasik
I'm really confused because some people say glasses are decreasing the sight more, other say Lasik is just a luck, others prefer overnight contacts which you sleep with'em.
I'd like to make a script which sreach in google and shows the 1st relevant image.
I mean, if you type to the input field: car
if you search to word "car" via google and it suggest the 1st image for me.
What do you think, are there any method to do this?
Over the last couple of weeks i have come across lots of articles about high frequency trading. They all talk about how important computers and software is to this but since they are all written from a financial point of view there is no detail about what does software do?
Can anyone explain from a programmers point of view what is high frequency trading? and why is computer/software so important in this field?
Hello,
I'm looking for an enchanced edit component that allow users to input multiple tokens (items) manually separated by some symbol, or to select them from another source.
It's something like "TO" field in outlook or facebook that allow you to input multiple recipients.
Can anyone suggest any solution?
Thanks in advice!
i am new in this Field.I have implemented BarCode Scanner.I have got the Proper Value of Barcode and Barcode Type.Now Is there any way to find the Date of Expiry using that value.Please help me i don't have any idea about it.Thanks in Advance....
I am trying to filter for an object that has a Title field and I want to ignore case. Is there a way to make sure case sensitivity of turned off?
| Where-Object {$_.Title -like "myString"}
Hi!
I have a table (sql server). One of its columns ('Name') Contains Cyrillic values.
From parameters i recieve value, that contains in this field but the are transliterated.
i mean something like:
var q = from r in m_DataContext.Table where CTransliteration.Transliterate(r.Name).Contains(trans_text) select r;
How can i transliterate value on-fly?