Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.
Javascript needed to prevent form submit if any of field is empty. all my form fields start names start with name=add[FieldName] those are the fields that need checking.
PHP, backend check before submiting to database double check to make sure all $POST are not empty
This is the connection string that is currently working on a non-password protected MS Access database.
db.url = jdbc:odbc:Driver\={Microsoft Access Driver (*.mdb)}Dbq\=C:\Inventory.mdb;DriverID\=22;READONLY\=true
How do I add a password to this connection string?
Thanks!
I want to implement a model "Contact", whose data is not stored in database, but remotely.
The operations on data are done via web service.
The model Contact is related to other models, whose data is stored locally.
Is there any plugin/gem which can take care of this?
Regards,
Pankaj
how to implement a counter in label which decrements every time page is loaded in asp.net(vb)?
It would be better if that counter value is accessed from and updated into database..
I've tried this on buttonclick but the value is reset automatically to intial value everytime
as the button is insert and page is reloaded
Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim entries As Label = FindControl("label1")
entries.Text = entries.Text - 1
End Sub
Hi,
If I already have domain classes, and I want to be able persist them using EF via a model first approach how do I do this?
For example do I go to the EF designer (in VS2010) and create the model and generate the classes, then go to these EF classes and somehow manually modify them? But then would there be an issue if I needed to change the model and re-create database TSQL from the model for updates?
What's the easiest approach?
Hi guys,
I got this Error when querying MYSQL Database:
Glib-Error **: gmem.c:173:falied to allocate 216000000 bytes aborting..
Do anybody have some explanations?
I am using MYSQL Query Browser.
thanks
I have a Browser and I want to display history & favorites of user on webbrowser on button_Click event. Can I accomplish this by using treeview in my form? if not what other way i can use. Data about History and Favorites is stored in SQL server database.
Thanks,
Ani
How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express.
The clear results does not seem to refresh.
I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in.
The documentation structures the url as "jdbc:h2:tcp:///mem:'
I've tried many combinations, but simply cannot get the remote connection to work. Is this feature working, can anyone give me the details of how they used this.
How can we generate a link that can be clicked on by 5 different people on a Social Network game, so that each of the five people can get a bonus? The link will be published as a "newsfeed" on the Social Network such as Facebook.
The link shouldn't be easily "generated" by any people as a cheating method.
Also, what database table(s) should be added to handle:
1) the bonus can be claimed up to 5 times
2) must be claimed by different people
?
Hello Friends,
I have developed customized setup Installer using NSIS. But every time when I reinstall an application, I want to take backup of old database files. & backup file should be rename as 'currentdatetime'(ex: 201003101140 means 2010-03-10 at 11:40 AM).
please, Help me soon
I am waiting your reply
Thanks !
what is the best way to use Application Constants ?
What i usually do is create a separate table in database of constants and reference them as foreign key in other table.
In Java i use enum.
But how to keep a single place of authority for constants in application and what are the different ways i can do that(like table or enum).
I have a USER table in database. The table has a RegistrationDate column which has a default constraint as GETDATE().
When using LINQ, I don't provide any data for RegistrationDate column to make it default. But SQL Server raises error. I think LINQ tries to insert NULL into the column.
How can I make LINQ not to try to insert in the column RegistrationDate, because it has default value?
I don't understand how to make a connection with nitrogen and couchdb using ecouch, because I have a error on this connection
CAUGHT ERROR: error-undef
[{ecouch,db_info,["test_suite_db"]}
I put ecouch in my erlang library path and I create a symlink to support/include.mk (even I don't know if it has necessary).
Or if anyone know a database how can connect with nitrogen and who to make this connection.
How to initialize variables in ActiveRecord class?
Variables here is the variables that are outside the scope of database
such as:
class Product
attr_accessor :used
end
I want to initially assign @used initially to false, later if some person access the product, i will change @used to true
First i thought of putting @used=false in initialize method, but it does not get called.
Hello Guys,
We need an address finder (premise level) based on postcode. We have a budget of 40k for this. But I have been assigned to find some cheaper alternatives for Royal mail PAF database. Is Google any good to find premise level address when you send full postcode. Any recommendation over Royal Mail PAF file. Any web services out there for this to accomplish? Please share your knowledge.
Cheers,
Naren
Hi,
my code is:
var ctaLayer = new google.maps.KmlLayer(
'http://.../per1.kml',
{suppressInfoWindows: true});
ctaLayer.setMap(map);
var info_percurso = new google.maps.InfoWindow({
content: 'hi'
});
google.maps.event.addListener(ctaLayer, 'click', function() {
info_percurso.open(map,ctaLayer);
alert("dd");
});
this is possible?
this code doesn't work...but the operation is possible?
I need to create my own infoWindow for database queries
Hi All
What Tips And Tricks Exist in C# And .Net FrameWork To Implement Fast UI in Windows Application? This Tips And Tricks Must Be Implement in WinForms And isn't For WPF Applications.
In This Scenario My Application Use A DataBase To Save his Data.
Hi,
In a WPF app, in MVP app
I have a combo box,for which I display the data fetched from Database. Before the items added to the Combo box, I want to display the default text such as " -- Select Team --" , so that on pageload it displays and on selecting it the text should be cleared and the items should be displayed.
Selecting data from DB is happening. I need to display the default text until the user selects an item from combo box.
Please guide me
Thanks
Ramm
What's the best way to determine if a given SQL Server table is readonly, either because of account permissions or the database being marked as read-only?
I have a search page on my MVC site that contains a list of strings that I think the user might wish to search for in my database. This list of strings is available in my model class, so I can populate an Html.ListBox with those strings thus:
<%=Html.ListBox("SearchStrings", new SelectList(Model.SearchStrings)) %
My problem is, how can I tell which strings the user selected in that list in my postback action?
Any help would be most appreciated.
I need to create a custom field that supports multiple values which can be uniquely identified (beyond the delta field which changes when the values are re-ordered). I have created a module for the field and specified the two database columns that I would like CCK to use (one for the value and one for the ID) but I am not sure where the entry point is for adding in a unique id for each value (probably will just take the id from a sequence).
I have a very simple joomla component that returns database results. It is not structured int the MVC format. How do I code the component so I can designate a page title? I wouldn't want to disable the existing functionality of joomla content articles.