Saved As Undefined
Oct 12, 2004When I submit data through my website one particular field which is drop down field and has 4 values (5, 10, Fee, other) saves as "undefined"
I get no errors through the web site.
Field is varchar
ADVERTISEMENT
Where Are The SSI Files Saved When Saved To The Server?
Apr 20, 2006This is a pretty simple question, but I'm going nuts trying to find the answer. After creating an SSI package, I told it to save to the SQL server... Now where do I go to pull that package up again and make changes and/or execute the package?
View 4 Replies View Related&<undefined Value&>
Jul 20, 2005Greetings,I asked this question over on the ADO.NET newsgroup and couldn't scrapeup an answer. I realize that it is more of an ADO question than an SQLServer question, but I'm hoping there might be an ADO programmer herethat can explain this to me.I'm developing database applications using C# on VS.NET 2003 and SQLServer Standard edition (SP3a).I've run into a situation I'm trying to understand, to wit, if I submita query using SqlCommand.ExecuteScalar which returns no results, why isthe returned item a System.Object of <undefined value>?(Actually, I think I know why -- ExecuteScalar returns a null referenceif there are no results.)How do I do test for that condition?I guess I can sort of see why they didn't want to throw an exception --lot's of queries don't return any results, but on the other hand, Ican't figure out how to test for <undefined value>, either.Any ideas?-- Rick
View 2 Replies View RelatedUNDEFINED VARIABLE ERROR
Apr 11, 2006I have the following form
<head>
<title>Mapleside Farms</title>
<link rel="stylesheet" href="mapleside.css" type="text/css" />
</head>
<form name = "account" action="account.php" method = "post">
Enter information
<input type=text name="lastname">
<br>
<input type=text name="firstname">
<br>
<input type=text name="address">
<br>
<input type=text name="city">
<br>
<input type=text name="state">
<br>
<input type=text name="zipcode">
<br>
<input type=text name="email">
<br>
<input type=text name="username">
<br>
<input type=text name="password">
<br>
</form>
And the following php page
<?php
$Customer_Lname=$_POST['lastname'];
$Customer_Fname=$_POST['firstname'];
$Customer_address=$_POST['address'];
$Customer_city=$_POST['city'];
$Customer_state=$_POST['state'];
$Customer_zipcode=$_POST['zipcode'];
$Customer_email=$_POST['email'];
$Customer_username=$_POST['username'];
$Customer_password=$_POST['password'];
// open connection to database
$db = mysql_connect("localhost", "root", "");
if (!$db)
{
print "unable to connect!";
exit;
}
//select database to use
$db= mysql_select_db ("mapleside");
if (!$db)
{
print "could not select database";
exit;
}
// create SQL query string
$query = "INSERT INTO customer (Customer_Lname, Customer_Fname, Customer_address, Customer_city, Customer_state, Customer_zipcode, Customer_email, Customer_username, Customer_password) VALUES ($Customer_Lname, $Customer_Fname, $Customer_address, $Customer_city, $Customer_state, $Customer_zipcode, $Customer_email, $Customer_username , $Customer_password)";
$result = mysql_query($query);
mysql_query($query) or die
('Error, insert query failed');
echo('Data inserted successfully' );
//close connection
mysql_close();
?>
However, when I run my form and php pages, I get undefined variable errors. Can anyone lead me in the right direction????
Element SADDR1 Is Undefined In SESSION
Jul 24, 2007Hi there, I am sorry to be abother but I was wondering if there was someone to tell me what I am doing wrong. Here is my statement. I am getting the following error.
Element SADDR1 is undefined in SESSION
SELECT [clv].[dbo].[UNIT].[HMY] ,[clv].[dbo].[UNITTYPE].[sdesc] ,[clv].[dbo].[UNIT].[SRENT]
,[clv].[dbo].[UNIT].[dtAvailable] , clv.dbo.property.saddr1, clv.dbo.unit.scode
FROM [clv].[dbo].[UNIT] inner join clv.dbo.PROPERTY on clv.dbo.property.hmy =
clv.dbo.unit.hproperty inner join clv.dbo.UNITTYPE on clv.dbo.UNITTYPE.hmy = clv.dbo.unit.hunittype
WHERE saddr1 = #session.saddr1# and ( hunittype='2' OR (hunittype='3') OR (hunittype='4')
OR (hunittype='5') OR (hunittype='6') OR (hunittype='7') OR (hunittype='8') OR
(hunittype='25') OR (hunittype='26') OR (hunittype='27') OR (hunittype='28') OR
(hunittype='29') OR (hunittype='30') OR (hunittype='31') OR (hunittype='32') OR
(hunittype='33') OR (hunittype='34') OR (hunittype='35') OR (hunittype='36') OR
(hunittype='37') OR (hunittype='39') OR (hunittype='41') OR (hunittype='42') OR
(hunittype='44') OR (hunittype='45') OR (hunittype='46') OR (hunittype='47') OR
(hunittype='48') OR (hunittype='49') OR (hunittype='50')
Thanks
Active X Scriopt Task Undefined
Feb 19, 2008
Recently I migrated one dts package from sql server 2000 to sql server 2005. I chnaged the connection string as well. when i run it in BIDS, I don't get any error. But when I execute it in SSMS (under Integration service) I am getting one error. It is showing :-
Error : The task "Active X Scriopt Task undefined " cannot run in this edition of Integration services. It requires higher level edition.
Task Active X Script Task undefined failed.
What does it mean? How to solve it? I am using SQL server standard edision.
Conditional Lookup && Returning Undefined Values On Error
May 30, 2007Hi,
I have a data flow task and trying to transform datas OLTP to STG db and i have lookup tables.
I do lookuping like this
first a lookup that lookup my table with connected input column parameter
second a derived column is connected to lookup's error output for when lookup can't find the value and this derived column returned "0" or "-1" this means that lookuped value can't find and insert this value to my table
third a union that union lookup and derived column
i want to ask this is there any different solution for doing this, because if i more than 5 or 6 lookup in my ssis package i add all of them derived columns and unions and when i change something i have to change or correct the unions step by step.
thanks
Error: Button Click Is Undefined - Simple If Statement With Sql Command Wont Work (c#)
Feb 2, 2008hello it seems lack of c# skills is getting the better of me here...iv been trying to get this to work for hours now without success. I have just started working in c# so i am a beginner :)
all i want to do it query the database, check to see if a title exists, if yes then populate textbox saying 'title in use' but if the title doesnt exists then continue executing rest of code to add the title.
You'll notice iv tried to use string variables and sqlDataAdapter but i cant get these to work either...please help
so far i have this that keeps giving me the error that my button click is undefined: protected void bookButton_Click(object sender, EventArgs e){
//string title;try{SqlConnection conn1 = new SqlConnection();
conn1.ConnectionString =
"Data Source=Gemma-PC\SQLEXPRESS;" +"Initial Catalog=SoSym;" +
"Integrated Security=SSPI;";SqlCommand findTitle = new SqlCommand("SELECT title FROM Publication WHERE title='" + titleTextBox.Text + "';", conn1);
conn1.Open();
findTitle.ExecuteNonQuery();
/*
DataSet myDataSetTitle = new DataSet("PublicationTitle");
myDataSetTitle.Clear();
myDataAdapterTitle.Fill(myDataSetTitle);//myDataSet contains results from above SELECT statement
title = myDataSetTitle.Tables[0].Rows[0]["title"].ToString();*/
}catch(Exception ex)
{TitleInvalidMessage.Text = "Title Not Accepted: This title is already in use by another publication" +ex.Message;
}
//title does not exist in table so continue and add to database
//rest of code here
Where Are DTS Packages Saved?
Jun 3, 1999Can someone tell me where DTS Packages are saved by default? Is it the MSSQL7/Binn directory?
Thank you,
Michelle Turner
Saved Reports - How Did They Do That?
Jun 2, 2008I recently viewed an application which included customizable savable reports. In the first step, the user selects from a very large (probably over a hundred) set of variables to include in the report (these would be the columns displayed in the report). In a second step, the user selects (from the same set of variables) which variables they want to set as criteria indicators (these would then be dropdowns and text boxes on the report that would filter the query results).
So, how do they do this? Lets take the AdventureWorks database as an example. Lets say the user can select the following variables to include in their report:
Product.Name
Product.ProductNumber
Product.Color
Product.Size
Product.ListPrice
WorkOrder.StartDate
WorkOrder.EndDate
WorkOrder.OrderQty
PurchaseOrderDetail.DueDate
PurchaseOrderDetail.UnitPrice
PurchaseOrderDetail.OrderQty
Vendor.Name
Etc…
How do you design this in the database? If you have a table that holds all of the possible variables, and a table that connects the user-selected variables to the user – how then do you construct the query that pulls it all together? For example, what if a user wants only these two variables in their report:
Product.Name
Vendor.Name
Here is the query:
select p.name as ProductName, v.name as VendorName
from Production.Product as p
inner join Purchasing.ProductVendor as pv on pv.ProductID = p.ProductId
inner join Purchasing.Vendor as v on v.VendorId = pv.VendorId
How do you build that query from just getting two variable names?
Trigger Is Not Saved
Apr 3, 2007ALTER TRIGGER Trigger1
ON countries
FOR UPDATE AS
begin
insert into country1 values(:deleted.cid,:deleted.cname,getdate(),,system_user,@@servername, host_id(),host_name(),DB_NAME())
--select * from country1
/*insert into country1
select * from deleted*/
i want to store data into country1 table as old data with all information
end
IF I WANT TO SAVE THE ABOVE TRIGGER ERROR OCCURS
IAM USING SQL SERVER 2005
HELP ME
Malathi Rao
Where Is The DTS Saved In 2005?
May 3, 2007I created a DTS by right clicking and exporting the data to a file and I also saved the DTS package. Where will the DTS Package be saved in SQL 2005 in case if I have to do any modifications later.
Thanks !
Where The Data Saved
Dec 22, 2006I don€™t understand what
my wrong is. I am trying to save data in to SQL Mobile Database. my Database is included in my project. after saved, i connect that database by VS2005 server explorer to view the data. But I don€™t found any data in Sdf file.
private void cmdSave_Click(object sender, EventArgs e)
{
SqlCeConnection objmycon = new SqlCeConnection(); objmycon.ConnectionString = ("Data Source =" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\SC.sdf;"));
SqlCeCommand objcmd = new SqlCeCommand();
objcmd.Connection = objmycon;
objcmd.CommandText = "Insert Into BenInfo (BenID, BenName, BenDOB, BenRegDate, BenExpDate) " +
" Values(@BenID, @BenName,@BenDOB,@BenRegDate,@BenExpDate)";
objcmd.Parameters.Add(new SqlCeParameter("@BenID", SqlDbType.NVarChar, 6));
objcmd.Parameters.Add(new SqlCeParameter("@BenName", SqlDbType.NVarChar, 50)); objcmd.Parameters.Add(new SqlCeParameter("@BenDOB", SqlDbType.DateTime, 8));
objcmd.Parameters.Add(new SqlCeParameter("@BenRegDate", SqlDbType.DateTime, 8));
objcmd.Parameters.Add(new SqlCeParameter("@BenExpDate", SqlDbType.DateTime, 8));
objcmd.Parameters["@BenID"].Value = this.txtID.Text;
objcmd.Parameters["@BenName"].Value = this.txtName.Text;
objcmd.Parameters["@BenDOB"].Value = this.dtpDOB.Text;
objcmd.Parameters["@BenRegDate"].Value = this.dtpRegDate.Text; objcmd.Parameters["@BenExpDate"].Value = this.dtpExpDate.Text;
objmycon.Open();
objcmd.ExecuteNonQuery();
MessageBox.Show("Beneficiary Information Save Successfully.");
objmycon.Close();
}
please advice me.. how can i over come this situation....
Why Can't The Password Be Saved??
Mar 3, 2006Hi!
I want to modify a package stored on the server from my client machine, and everything goes great.
The only problem I get is that when I try to run it by double-clicking it I have to re-write the password in the connection string, i.e. "pwd=asdasd", because it is not saved by the package itself even though the checkbox in the Connection Manager tab (in the SSIS Designer) is checked. What can I do to save it automatically??
Thanks
ASP 3.0 Record Is Getting Saved Twice.
Mar 1, 2007Hello All,
I am facing this unusual error. In My ASP Page I am submitting the Page and after submitting the form I am calling another ASP page, which contains sql command to insert the record.
My Problem is when I am submitting the Form. Record is getting inserted twice with same values.
What is the cause of this problem as I am facing this problem in every form.
With Regards
Sunil Dutt
Password Cannot Be Saved
Apr 10, 2007Hi, there;
I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..."
Did I do something wrong or anybody know how to save that password field?
Cheers
Dates Being Saved Incorrectly
Apr 10, 2006Hi,I've got a question about saving into datetime fields in a SQL Server table. A form I have create has two fields both for dates as well as other form fields, but the user may or may not fill in all the form fields, so when they click the save link I have a query which saves all the form fields whether they are blank or not. Unfortunately this is causing the two date fields to be saved in the database as "01/01/1900" even thoough they are blank fields.What is a good way to not save blank date fields as "01/01/1900"?ThanksStephen
View 1 Replies View RelatedSAVED DTS JOB ONLY EXECUTES FOR CREATOR???
Jun 7, 2000I have a developer using SQL 7.0 Enterprise Manager and the DTS Wizard to create and save simple DTS imports on the SQL Server. The DTS job runs only on his workstation using his NT logon ID. Server is set for mixed security.
Other users can edit the saved DTS job and resave it, then anyone can run the job. I tried having the developer log in with his NT logon ID on another workstation; he can't run the job from there if he was the last person to edit it from his workstation.
Any ideas, anyone? This is the only person having this problem in my shop.
Thanks!
Long Text Gets Cut Off When Saved
Sep 1, 2006I was trying to save a long text from asp.net application to "text" data type in sql database but it gets cut off at few hundred characters.
Does anyone know what the problem is?
Thanks for any help.
Date Format Cannot Be Saved
Mar 9, 2005Hi guys, I was doing some changes on my asp web pages, I added new field expiry date that will be scanned into the system in format ddmmyyyy but it can't save as i am gettting that message that char can't be converted into datetime as date time was out of range.
I have added this into my asp pages <% Session.LCID = 3081 %> and changed the sql server regional setting setting the date to dd/mm/yyyy I can't set it to ddmmyyyy as there is not option without "/".
Could somebody help me as this is quite frustrating.
Thanks
Run Saved DTS Package In 2005
Mar 31, 2006I have saved a DTS Package, in sql serv 2005. How do i run it ? I cant fiqure it out
View 5 Replies View RelatedDates Saved As Different Format
Dec 4, 2007I recently wrote a stored procedure to add the date and time to an existing table. The date is being stored as
Oct 29 2007 5:37PM
Instead of as
10/29/2007 5:37:23 PM
The column is a varchar(24) data type and I use GETDATE() in the stored procedure to supply the date.
What do I need to do to change to get this to save the date as mm/dd/yyyy
Miranda
Saved Package Gets Corrupted
Nov 7, 2006Hi,
I am facing a problem. I have custom data flow transformation.We have saved a package using component's earlier assembly version. Now when we install later version of the component the saved package fails to open. If I try creating new package it succeeds.
Error message :
Error 1 Validation error. Data Flow Task: DTS.Pipeline: The component metadata for "component "Oracle Destination" (153)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Package.dtsx 0 0
We tried overriding "perform upgrade" method but still I am facing the same issue.
Dharmbir
SSIS Saved In MSDB
Feb 17, 2006I ran the SSIS wizard in Management Studio and saved the file in MSDB. I want to look at the design of the package but even going to BI development studio, I can't seem to find where you can open and work with the packages which were created in Management Studio and saved in MSDB. Anyone find a way to look at them?
View 1 Replies View RelatedImporting Excel Saved As XML
Jun 19, 2007Hi guys!
I'm having troubles trying to import an excel file saved as XML.
Tried XML Source, Excel Source, OLEDB Source with no success.
Could someone point me to the right direction?
Thanks in advance.
Import Wizard, Where Saved?
Apr 25, 2007I created my first package using the import wizard and saved it to the server. And now I can't find it. In SQL Server Mgt Studio, I've browsed through every imaginable folder in the target database, in MSDB database, and in the global folders.
I read something that suggested there should be an Integration Services folder, but there isn't.
Once I locate the package, I understand that it's not editable. Can it be transferred to BI Studio for editing? TIA.
How To Execute A Saved Package?
Jul 27, 2006Sorry for such a simple question -
I ran the Import data wizard and chose to save the package to sql server. Now I would like to execute that package I saved again, but I can't find where to do it in the management studio. Help!
Error When File Is Saved To PDF
Feb 7, 2007I am calling a procedure that will save a file to PDF. It runs successfully. When I go to look at the PDF, I get a message, "Acrobat reader could not open 'Doc.pdf' because it is either not a support file or because the file has been damaged."
This is how I'm calling the procedure:
SaveFile(Dts.Variables("varSSRS_URL").Value.ToString() + "?/TestReports/MyReport&rs:Command=Render&rs:Format=PDF", "C:" + "MyReport.pdf")
Can Sql Server Know When The Row In Table Saved
Apr 22, 2008hi i have question
can sql server know when the row in table Saved
add new field call "date_row_save" date+time
inside the my table in the sql server
i need to know whan the row last Saved
evry row put date time
TNX
Type Of The Saved File In SQL Server
May 31, 2008Hi all,
I am not sure this is the right place to post this, but I could find a better place.
I uploaded a document in the SQL Server (image datatype), but I was not able to save file Type since there is no field for that, and cannot change the database.
Now I download the saved file. Is there any way to extract file Type from the saved file (like from file header?) and open it with an appropriate program such as doc file with MS Word?
Thanks,
J
Date Is Not Getting Saved In Propper Manner
Mar 23, 2006hi friends
In my form i am storing system's date in the database.
4 that i m using a variable of date like:
dim today as new date
today=now.date
but its storing the default date that is '1/1/1900'
how to overcome this problem?
Arabic Characters Are Not Saved (was A Serious Problem ...- Plz. Help
Jan 15, 2005Dear all ..
i have a serious problem & all ur comments will be appreciated..
i have bought an ASP .NET publishing tool which i receieved an sql script with it to execute on either Ms sql server or MSDE .
i executed it on MSDE as i don't have Ms sql server on my windows dedicated server .
I wanted the tool for publishing (Arabic Language)content for a highly traffic soccer website..
After executing the sql script i tested the tool but i found arabic characters are not saved when i add articles .. they were saved as question marks (??).
so i re-executed the sql script on a new db after modifying every code containg (varchar) to (nvarchar) to support unicode & thus arabic.
it worked & i succeeded in saving arabic articles
BUT >>>>>>>>>>>>>
i found that only short arabic articles r saved fine while any article that reaches around (1 microsoft word page) is not saved well with arabic characters but saved as question marks ( ??? ) .. !!
=======
so i checked the db tables using ASP.NET Enterprise manager & i found that
the field of article has (ntext) & infront of it number 16 ..
it seems that the (ntext) has a limit to wt it can save ..
so i believe there's a way which i don't know to make the (ntext) accepts long articles entry .
========
Here's the code in the original sql script i received with the tool & i hope u can guide me in details to any modification to do so that the ntext limit is raise to save any long arabic article.
========
code :
CREATE TABLE [dbo].[xlaANMarticles] (
[articleid] [int] IDENTITY (1, 1) NOT NULL ,
[posted] [nvarchar] (50) NOT NULL ,
[lastupdate] [nvarchar] (50) NOT NULL ,
[headline] [nvarchar] (350) NOT NULL ,
[headlinedate] [nvarchar] (255) NOT NULL ,
[startdate] [nvarchar] (50) NOT NULL ,
[enddate] [nvarchar] (50) NOT NULL ,
[source] [nvarchar] (255) NOT NULL ,
[summary] [nvarchar] (3000) NOT NULL ,
[articleurl] [nvarchar] (1000) NOT NULL ,
[article] [ntext] NOT NULL ,
[status] [tinyint] NOT NULL ,
[autoformat] [nvarchar] (50) NOT NULL ,
[publisherid] [int] NOT NULL ,
[clicks] [int] NOT NULL ,
[editor] [int] NOT NULL ,
[relatedid] [nvarchar] (2000) NOT NULL ,
[isfeatured] [nvarchar] (10) NULL ,
[keywords] [nvarchar] (255) NULL ,
[description] [nvarchar] (255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
i highlighted the specific column for the article field with red color ..
i tried making it (nvarchar) but the sql manager i use saud it can't be done coz. there has to be a field for TEXTIMAGE coz. it's set to be (on) in the code.
waiting for ur help plz. ... i am desperate .. :confused:
RUN A SAVED SSIS Package In 2005
Mar 30, 2006I saved a SSIS ( data Import package in SQL SERV 2005)
how can i run it????