Hello,
Q: Is there a way to direct MYSQLDUMP to export VIEW's with data (and not just the CREATE SQL)? I want to use the resulting SQL to create a new table.
Thanks!
Jon
When user start typing in their username in textBox field, a dropdown list shows old data. How can I clear this?. It's a class room and many students logs in from the same pc everyday, I don't want the student to see his mates usernames.
hi all i want to know that while specifying url in my iphone native application for downloading purpose it works fine but if i want to know the exact size of data either in kb or in Mb coming from that url how could i do that plz guide me to do that demonstarting a sample code would be a big boost
thanks
After I decided at last to implement my Int128 in C#, I thought it would be nice to make it look like other dotNet data types.. But I could not implement the following feature:
suffix initialization: such as 13L and 0.2D
Can I make my own suffix in C#?
And if I can not.. how can I initialize it?
i.e
Int128 a= ??
Hi everyone,
I use MonoDevelop 2.2.2 with Mono 2.6.3 on OpenSuse so the linq to sql feature is implemented. But I have the problem I can create a new connexion to a postgresql database it's ok but when I click in Tool - Generate Data classes and select the connexion I've created before I obtain nothing, no tables appear.
What's the problem ?
I have created an .SDF file and inserted data into the SDF database file on a mobile device. I want to transform .SDF file to a SQL Server 2008 Database File but don't know how. Any pointers or suggestions would be appreciated.
Currently my MySQL data stored like below
product | total
------------------------------------------
puma,adidas | 100.00,125.00
puma | 80.00
reebok,adidas,puma | 70.00,100.00,125.00
adidas,umbro | 125.00,56.00
How to combine, explode, merge and total it like this in php?
puma 485.00
adidas 350.00
reebook 70.00
umbro 56.00
I have a list of data indicating attendance to conferences like this:
Event Participant
ConferenceA John
ConferenceA Joe
ConferenceA Mary
ConferenceB John
ConferenceB Ted
ConferenceC Jessica
I would like to create a binary indicator attendance matrix of the following format:
Event John Joe Mary Ted Jessica
ConferenceA 1 1 1 0 0
ConferenceB 1 0 0 1 0
ConferenceC 0 0 0 0 1
Is there a way to do this in R? Sorry for the poor formatting.
I'm using:
ForceType text/html;charset=utf-8
in my .htaccess file, but it's causing all externally linked CSS to stop rendering on their respective pages.
So something like this:
<link rel="stylesheet" type="text/css" href="somestyles.css" media="all" />
no longer works on the page using it.
I've also been trying combinations of:
AddCharset utf-8 .html
AddCharset utf-8 .htm
AddCharset utf-8 .css
AddCharset utf-8 .js
ForceType text/html;charset=utf-8
ForceType text/css;charset=utf-8
but no luck so far. Does anyone know what's wrong?
I have some specific requirements, with the most important at the top:
Can plot line and stacked bar charts
Can customize mouse events (hover, click) on chart data
Compatible and performant with IE7/8 (likely will use excanvas.js)
Can optionally control label formats, legends, colors
Open source preferred, or at least can purchase the source
Can be hosted locally
I have seen a couple potentially good ones:
Google's interactive charts (But code must be accessed via Google servers)
EJSChart
Flot
Does anyone have experience with these, or others, and can make a recommendation?
I am using the below piece of code for SQL Bulk copy
using (SqlConnection con = new SqlConnection(strConString))
{
con.Open();
SqlBulkCopy sqlBC = new SqlBulkCopy(con);
sqlBC.DestinationTableName = "SomeTable";
sqlBC.WriteToServer(dtOppConSummary);
}
Can anyone provide me the equvalent code using Data access block Enterprise library
I am using the RESTEasy client framework to call a RESTful webservice. The call is made via a POST and sends some XML data to the server. How do I accomplish this?
What is the magical incantation of annotations to use to make this happen?
I am trying to upload a tab delimitted file with MySQL. I want a query something likes this: LOAD DATA LOCAL INFILE 'file' INTO TABLE tbl FIELDS TERMINATED BY 'TAB' Is there something I can subsitute for TAB to make this work?
Hi all,
i have to validate the data contains numeric or not and if it is not numeric return 0 and if it is numeric or empty return 1.
Below is my query i tried in SQL
SELECTdbo.Regex('^[0-9]','123') --- This is returning 1
SELECTdbo.Regex('^[0-9]','') -- this is not returning 1 but i want to return as 1 and i try to put space in "pattern" also it is not working...
please can any one help....
Thanks in advance
Hi!
The following is an excerpt of my XML data source:
<file>
<ALL_INSTANCES>
<instance>
<ID>1</ID>
<start>5.8633333333</start>
<end>29.8216666667</end>
<code>Player 1</code>
</instance>
<instance>
<ID>2</ID>
<start>28.4566666667</start>
<end>51.1450000000</end>
<code>Player 2</code>
</instance>
<instance>
<ID>3</ID>
<start>49.8383333333</start>
<end>71.1150000000</end>
<code>Player 3</code>
</instance>
<instance>
<ID>4</ID>
<start>72.9850000000</start>
<end>95.3766666667</end>
<code>Speler 1</code>
</instance>
</ALL_INSTANCES>
I'm looking to restructure this data into something like this:
<Player 1>
<ID>1</ID>
<start>5.8633333333</start>
<end>29.8216666667</end>
</Player 1>
<Player 1>
<ID>4</ID>
<start>72.9850000000</start>
<end>95.3766666667</end>
</Player 1>
<Player 2>
<ID>2</ID>
<start>28.4566666667</start>
<end>51.1450000000</end>
</Player 2>
<Player 3>
<ID>3</ID>
<start>49.8383333333</start>
<end>71.1150000000</end>
</Player 3>
Could anyone please help me to achieve this? Much appreciated!
Cheers,
Frank
Looking for a data type that is similar to VARCHAR as to the values I would like, but is there a way to have a MIN/MAX character length?
VARCHAR(6,10)
This would have a minimum of 6 characters and a maximum of 10 characters.
Hello,
I am unable to access an action in my controller using .ajax. The code works on my development machine but as soon as I place it on the server it gives the error 401 Unauthorized. Here is a snippet of the code in the .aspx file...
var encoded = $.toJSON(courseItem);
$.ajax({
url: '<%= Url.Action("ViewCourseByID", "Home") %>/',
type: "POST",
dataType: 'json',
data: encoded,
//contentType: "application/json; charset=utf-8",
success: function(result) {
Thank you for the help.
I am building an application that will function as a client-server application, and also as a disconnected client application. I will be using WPF (browser app for client-server application).
When interacting with the server's database, I will need to connect using WCF web services. When connecting with the localized database, I will need to connect using the local db's data access layer.
What methods/patterns exist for this sort of architecture?
I want to turn a screen shot from the clipboard into a array data (Red/Green/Blue) in my program. so i guess it's as simple as that. but i don't want to use anything else then the print screen and clipboard if i can?
anyway any questions just ask.
Hi,
I have an application where I receive each data 40.000 rows. I have 5 million rows to handle (500 Mb MySQL 5.0 database).
Actually, thoses rows are stored in the same table = slow to update, hard to backup, ...
Which king of scheme is used in such application to allow long term accessibility to the datas without problems with too big tables, easy backup, fast read / write ?
Is postgresql better than mysql for such purpose ?
Thanks in advance
BEst regards
Hi
im a little confused by this diagram http://www.b-eye-network.com/images/content/i030ht0104.gif (Last diagram in the article)
1 - In the "ACCOUNTING ENTRY" table it shows "DebitEntry" and "CreditEntry"
i) is this two column or
ii) is this two rows of data? or
iii) is it two separate tables on its own, Acounting_entry_credit and Accounting_entry_debit?
Same question with the "ACCOUNT" table, it shows asset account, livabilities account, equaity account? are they 3 columns or are they 3 rows?
Source: http://www.tdan.com/view-articles/5227/
Hi all,
I'm wondering whether there is a bossibility to export some selected data from my rails mysql db to a other sqlite db. The aim is to send that sqlite file directly to my iPhone application... That way I don't have to do a lot of xml integration in the iPhone app. That seems to be very slow...
Markus
my object has field with data type int. when i put in html form in this textbox letter not number the validator say- The field must be a number. how can i change this messages like this
[Required(ErrorMessage = "??????? ????????")]
[DisplayName("????????")]
public int age { get; set; }