|
by: ChronoFish |
last post by:
In PHP you can retrieve the table.column name of a MySQL
query doing
something like this:
$result = mysql_query($query, $dbConnection);
$resultArray = mysql_fetch_row($result);
$i = 0;
foreach ($resultArray as $data)
{
$tableName = mysql_field_table($result, $i);
|
by: Robin Tucker |
last post by:
As I had real problems working my head around sp_spaceused, I've written an
SP to do it (I also noted a lot of questions about this when "searching").
Pass in a database name and it will return the size of the database as a
float (ie. 0.75 for 0.75mb). Update usage set to 1 indicates the DB should
update its size information before giving you...
|
by: Derrick King |
last post by:
COuld someone tell me if its possible to get hold of stats about all
Databases on a SQL Server.
The sort of things I would like are
Name of DB
Location of DB
Size of DB
Location of Logfile
Size of DB
|
by: Sylvain Provencher |
last post by:
Hi!
There is a way to obtain tables and fields info from an SQL connection. like
tables name, fields name, type and width ?
I'm writing a VB.NET application.
Thanks
|
by: Saso Zagoranski |
last post by:
Hi!
A question about database tables...
I have a SELECT statement:
SELECT something FROM someTable WHERE code = @code
The parameter code starts with 1 and is autoincremented...
Now I want to add a row to the database and I do it like this:
DataSet dataSet = new DataSet();
|
|
by: Luis Esteban Valencia |
last post by:
Hi experts
What I'd like it is something like this...
I have an xml file and when going to the page, I want the page to look at
the paramater passed in with the URL and gets the XML "element" (is that the
term, it is in JDOM...)
<whatever thefieldtomatchURL="12345" dbtable="table1">
<db field="field1"/>
|
by: RAB |
last post by:
I tested my code on my local computer and it worked fine. When I
uploaded it to my webserver at Godaddy.com, I get the following
error...
Exception Details: System.Data.OleDb.OleDbException: Operation must use
an updateable query.
The line of code with the error is:
objCmd.ExecuteNonQuery
|
by: VG |
last post by:
Hi,
I want to hookup some database change events automatically to my .NET
application. The backend is SQLServer 2003. Is this possible? How do I
get notified automatically of changes in my database?
Samples and URLs would help.
|
by: dallasfreeman |
last post by:
I'm looking at a quick way to get results that are displayed as rows to
display as columns.
I have three tables:-
- The Questions for the survey
- The Results of the survey (Columns are listed as question numbers)
- The Survey Extra Results (As additional questions can be listed into
the Questions table, has 3 columns (a link/id to the...
|
by: Adi |
last post by:
hi everyone... i have a doubt.. is there any way i can get the
database name.. my page is accessing.. i would like to display the
database name, the current page is accessing. This has to be done
without refering to the connection string which is usually used to
create the connection with the database. i would appreciate for the
help.....
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|