Search Result

newbie93 · Jun 4 '12, 08:30 PM

Hey guys. I'm working on a database with 3 tables, some with overlapping information. A few columns from each table can be updated by the user via the web app that I am creating. But... There is an issue. Not sure what it is, but my updates aren't happening. I am wondering if something is wrong with my query. (Actually, after debugging, I am quite certain there is).

Code:

	if (empty($errors)) { 	
		$query1 = "UPDATE owner SET

...

newbie93 · May 31 '12, 04:01 PM

Hi everyone - I need a way to turn a column in my table into a list. Basically, my table consists of: userId, name, and "role" (0 or 1). I want to write a function that outputs a list of usernames. This is what I have:

Code:

 
         function checking_query() {
		global $connection;
		$query = "SELECT GROUP_CONCAT(userId) FROM owner";
		$result = mysql_query($query, $connection);
		confirm_query($result);

...

newbie93 · May 22 '12, 08:46 PM

Hello everyone,
I am wondering if it is possible to check *which* rows were updated when a user edits a field.
This is my problem: I have a list of users and it is important that no usernames are repeated. I have already created a function that checks if the username already exists in the database when a user is intially added. However, I am not sure how I can check if, once the username field is *updated*, if the newly updated field...

bestbird7788 · May 16 '12, 08:18 AM

Hi, everybody
I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis?
The requirements are:
1. Able to cope with the unexpected requirement rapidly.
2. Able to perform further computations on results interactively.
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?...

newbie93 · May 14 '12, 07:41 PM

Hi, so this issue has been driving me crazy for the entire workday. I hope someone can help; I am sure it is trivial.
I am trying to access a user in a database based on their id. The id is auto incremented and thus unknown to the person accessing the user. I have created the functions below for accessing user information:

Code:

	function get_user_by_id($user) {
		global $connection;
		$query = "SELECT * ";

...

scriptcsharp · Apr 20 '12, 11:44 AM

Getting Unspecified error on 32 bit windows XP with office 2010.

issue is reproducible on some machine not all.

Code:

 Dim dbConn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test\data.mdb")
   try
   {
   dbConn.Open() 
   }

Exception

Code:

Exception: 
  at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString

...

Jindra · Apr 16 '12, 09:27 AM

Hello,
I wrote a GUI app in Jython (using Java Swing) which uses database. The application remains connected for its whole run time until the main window is closed (JFrame, using defaultCloseOpe ration = JFrame.EXIT_ON_ CLOSE).
Now, when exiting, I would like to make sure I explicitly close the database connection. Is there any function, like _atexit() in C, where I could place my code?
Thank you very much.

Joe Farage · Mar 30 '12, 06:49 PM

I have a SQL statement that I need to run on my databases quarterly (monthly would work too). It compresses the database and speeds up the searching of it for my company. As of right now, I just have a reminder on my calender to tell me when I need to run it. My question is, is there a way to set it up so that this statement will run automatically?

tqa89 · Mar 13 '12, 10:23 AM

Hi,
When user input the date,I want to save it to database. But I'm not sure about the date format,whether I should change the format?
I'm using getter and setter method to save to database.I'm using db2
This is my code.

Code:

DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
Date startDate=user.getDate_from();
				dateFormat.format(startDate);
						user.setDate_to(startDate);

...

tharindu96 · Mar 6 '12, 06:04 AM

http://localhost/download.php?lt =a&sr=0&sp=9

lt = letter(eg:- a,b)
sr = start
sp = stop

Code:

   <?php
	if(isset($_GET['lt'])){
		$lt = $_GET['lt'];
		if(isset($_GET['sr'])&&isset($_GET['sp'])){
		$sr = $_GET['sr'];
		$sp = $_GET['sp'];
			if(!empty($lt)){
				if(!empty($sr)&&!empty($sp)&&$sp!=9){
					if(strlen($lt) ==

...

imhomer · Mar 6 '12, 02:41 AM

When I run "python manage.py syncdb" and after I input that I want to create a superuser, cmd told me the error below:

django.db.utils .DatabaseError: You mustnot use 8-bit bytesrings unless you use a text_factory that can interpret 8-bit bytestings (like text_factory = str). It is highly recommend that you instead just switch your application to Unicode strings.

Could you help me solve the problem? Thanks!

tharindu96 · Mar 4 '12, 05:06 AM

Code:

$itarget = "images/";
							$ftarget = "files/";
							$idir = $itarget.$image['name'];
							$fdir = $ftarget.$file['name'];
							$gquery = "INSERT INTO `games` VALUES ('','".$name."','".$content."','".$idir."','".$fdir."','','')";
							if(mysql_query($gquery)){
								$itarget = $itarget.basename($image['name']);

...

Catalyst159 · Feb 21 '12, 09:20 PM

I have a linked table called "dbo_tblNot es".

dbo_tblNotes has the following fields:

id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)

I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNot es"...

Clarence sagum · Feb 15 '12, 03:53 PM

hi. im new with vb. i would like to ask how to code 35 checkboxes and connect it to database with a primary key (lets name it Patientno) and a label from another form that has the patient's name. i tried to use the if-else statement, but of course its an epic fail with he database.

my DB looks like this (imagine it in DB)
/* 1 is checked. 0 is uncheck

Patientno ____ Patientname _______ chk1 ____chk2 ____ chk3...

Stuart Hunter · Feb 3 '12, 04:09 PM

I'm currently setting up an image gallery using Isotope and it's combination filter:

http://isotope.metafizzy.co/demos/co...n-filters.html

However... this will also be used as an internal resource for the company to find relevant PR imagery from 1000's of photos (not all these images will be public facing).

Is there a way of automating the addition of content to an Isotope gallery via an upload form, and...

Search Result

Is something wrong with my query?

clarification on GROUP_CONCAT()

Is it possible to check which fields were changed?

Could anyone recommend an interactive application for data analysis?

Undefined index

Unspecified error: On opening OleDbConnection in VB. net

cleanup actions on sys.exit()

automatically run a SQL statement quarterly or monthly

cannot save date from user input to database

how to make this code work?

Django error: django.db.utils.DatabaseError: You mustnot use 8-bit bytesrings

Why is this code won't work

Form for entering data into linked Table

how to connect 35 checkboxes using vb 6 to database?

Isotope - Database driven