I use Borland Delphi 3 and SQL Anywhere 5.5.01 (free 60 day trial version)
I have a table structure as shown in file attachment Table3.bmp.
If I use query:
SELECT CompanyID, ParentContactID, ContactID, SalutationID,
ChristianName, KnownAs, Surname, Initials, JobTitleID,
ContactStatusID, Notes, Responsibilities, AreaCovered,
PAName, ContactName, ExcludedFromMailshot
WHERE ContactID = :ContactIDFilter
The notes field always returns the same value regardless of the
:ContactIDFilter value and even if the value is null in the specified
record (the field value r...How to add users to a SQL Server DB used for authentication using SQL query
I am looking for a simple way to add users manually to a SQL Server DB (set up using aspnet_regsql.exe) via a SQL query. What are the required values, that have to be set in the different tables?
Thanks in advance,
By default SqlMembershipProvider calls the aspnet_Membership_CreateUser stored procedure to create a user, you can use T-SQL statment like sp_help aspnet_Membership_CreateUser to learn how to use it.Welcome to my SQL/ASPNET forum for Chinese http://51up.org/bbs/forumdisplay.php?fid=38...Problem inserting sql query into database float datatype field using SQL Transaction
I have this problem of inserting my query into database field. My code is as of below.
The @AVERAGESCORE parameter is derived from
Dim averagescore As Single = (122 * 1 + 159 * 2 + 18 * 3 + 3 * 4 + 0 * 5) / (122 + 159 + 18 + 3 + 0)
and the value returned is (averagescore.toString("0.00"))
However, I have error inserting the averagescore variable into a field of datatype float during the transaction. I have no problems when using non transactional sql insert methods. What could be the problem?
Dim i As Integer
...User.Identity.Name for use in Parameterized SQL Query.
Okay, what I'm trying to do is pull the user's login name and use it as a means of ensuring a user only can See and therefore edit database records they created. I think my problem is in how I'm trying to set @User to User.Identity.Name, however; after beating the problem around the bush for hours on end reading every tutorial, article, and forum I can find... I just need a little help getting the last pinch done. I've had others help me here and there to get this far, but still snagged. (Eventualy things like department will be automatically entered ...::massive sql query using dbi
Hello to all!
This is my first time posting to this group! But I'm in desperate need of
(BTW, thanks for all the emails from contributors to this list..I learn a
lot from you guys every day!)
I have two tables in a mySQL db, named users_old and users_new, both with
UserId and Email columns, no primary keys and no auto-increment columns.
The users_old table has numeric values for the UserId while the users_new
have NULL values.
The users_old table has 120,000 rows and the users_new has 910,000 rows.
I'm trying to find a simple, painless way of querying these two...Problems moving date fields between systems using DBI
I am attempting to move data from one database to another using perl. Things
work fine until I run into date fields. I have checked the fine manual as
well as Tim's book and I haven't found much of help in either. There is some
dicussion of how an insert works, where you hand craft the insert and have a
I have created a small test script that shows the problem.
use DBI qw( neat_list );
$ora_uid = 'XXXX';
$ora_pw = 'YYYY";
$ora_dbase = 'DDDD";
$ora_DSN = join ':','dbi','Oracle',$or...[perl5-dbi/DBI-Test] 9016ab: Replace %$DBD_DBM_SETTINGS our var with use of DBI...
Author: Tim Bunce <Tim.Bunce@pobox.com>
Date: 2014-01-08 (Wed, 08 Jan 2014)
Replace %$DBD_DBM_SETTINGS our var with us...HELP PLEASE! Problems using returning a cursor to DBI & DBD::Oracle using Stored Procedures
I hope this email does not irriatate you but I really need some help. I =
have an Oracle DBA I need to work with who doesn't seem to how to write =
PL/SQL for Perl DBI. He insists on writting stored procedures which loop =
through the results set =20
fetching the data into output variables. The problem is I can't seem to =
figure out how to get all the data from it.
I found an example of an oracle FUNCTION returning a cursor which =
allowed me to fetch the data from Perl. Unfortanely, the DBA is =
complaining that the return...problem when using DBI
I am trying to use DBI to connect to database. But I am getting
the folllowing error. Coudl you please help me out in this.
Can't locate loadable object for module DBI in @INC (@INC
contains: . . C:/Perl/lib C:/Perl/site/lib .) at
C:/Perl/site/lib/DBI.pm line 235
BEGIN failed--compilation aborted at C:/Perl/site/lib/DBI.pm line
Compilation failed in require at dbtest.pl line 1.
----- Original Message -----
From: "pawan reddy lingala" <firstname.lastname@example.org>
Sent: Tuesday, October 08, ...Problems using DBI !!!
I=B4ve already intalled the DBI and DBD for Oracle.
When I use the command " USE DBI " in my script occurs an error
The system doesn=B4t find the dynamic link to PerlCRT.dll in the path
Error:Can=B4t load C:/Perl/site/lib/auto/DBI/DBI.dll for module DBI: =
This error occurs at line 200 in c:/Perl/lib/DunaLoader.pm
Do I have to configure something after install DBI and DBD-Oracle ?
------=_NextPart_000_04C5_...Problem to use DBI
I try to use DBI for the first time with Linux RedHat9 and PERL 5.8.0.
I download DBI, DBD from CPAN and I try to connect text file.
When I run the script, I receive this Error Message:
DBI object version 1.32 does not match $DBI::VERSION 1.38 at =
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Dynaloader.pm line 249.
I'm not an expert with linux, so could you tell what I need to do use =
Thank for your help.
It would appear that you didn't actually install the newer version of
DBI. Possibly just copied the DBI.pm and/or have PERL5LIB/-I/use lib...Help using LoginName or User.Identity.Name as a variable/parameter in an sql select statement.
I am trying to create a SQL select statement that uses the LoginName or User.Identity.Name to filter the SQL statement to show only records for that user. This is just for a Time Clock DB I have on the server. I have been plagued with errors :D These are my attempts? Can anyone point me in the right direction?? Thanks In advance -
<!--- Doesn't Work -- Works if I take "QueryStringParameter DefaultValue='" & User.Identity.Name & "' " and replace it with QueryStringParameter DefaultVal...[perl5-dbi/dbi] 3ff23d: Travis uses a dist checkout, so lib/DBI/Test files...
Date: Sat, 17 Aug 2013 04:55:15 -0700
Author: H.Merijn Brand - Tux <email@example.com>
Date: 2013-08-17 (Sat, 17 Aug 2013)
C...Query logged in user
First, the obliquity I am a newbie to ASP! I have Googled for while now but cannot seem find a solution to my problem.
I am trying to display the details of the logged in user (UserName). Below is my code but nothing is displayed by the query. The Label ID="lblIdentity" does display the logged on users username correctly . Any help would be appreciated.
<asp:Label ID="lblIdentity" runat="server" Style="z-index: 104; left: 14px; position: absolute;
top: 28px" Text="Label">...