linking a sql field to point to the value of another sql field
is it possible to create hyperlinks in powerbuilder such
that if you retrieve two fields from a database.. and want
to display the first field on the screen and have it link to
the value of the other field (when clicked) which is
actually a URL address, you can?
any help will be appreciated. thank you!
...How to save a picture in a SQL image field and how to show a picture from a SQL image field
I am searching now a real long time in the forum and I found a lot of stuff to this topic. But please help me it doesn't work!
On my webapplication there is a possibility to save a private picture.If a new user is saved in the database I want to save a fixed picture as startpicture.Dim picturePath As String = Request.ServerVariables("APPL_PHYSICAL_PATH") & "img\anonymous.jpg"
Please tell me the way how to save this anonymous.jpg from the picturePath into the database and after that how to display the picture.
...UserID field in SQL Express won't match to SQL 2000 field
Hi - I am using .net2, with Sql Express for the Users/Membership etc, and a SQL 2000 database for my actual web application.I want to associate my user in the aspnet_Users table of the SQL Express database, with records from the SQL 2000 database.In SQL Express the datatype for the UserID field is uniqueidentifier, length 16. In SQL 2000 therefore, I added a table, with a column name of UserID as uniqueidentifier, length 16.When I try to insert the UserID from SQL Express into the UserID field of the SQL 2000 table, I get the error: Guid should containt 32 digits with 4 dashes (xxxxxxx...How To -- Update Field In #Temp Table With Result From SQL Statement Inside Field
I have a stored procedure that creates a #Temp table. In this #Temp table, I have a combination of fields with normal data (such as account number, title, etc) and I also have some fields that are "calculated" fields. The "calculated" fields are generated by making a call to our SQL Server Functions that produce and return the literal SQL needed to arrive at the calculated amounts. So, when my stored procedure first runs, it populates the fields that have the function calls with literal SQL that, when executed, will produce the "calculated" amou...Database triggers - SQL Server
I would like to ensure data integrity in a column (actually multiple columns will need a trigger) in my table(s) by setting up a trigger which allows an update of my database field only if the value which is being written to the field in the database exists in another column (in another "check" table).eg. I only want values "Yes", "No" or "" in many of my fields, which I store in a column named "YesNoBlank" in another table.Does anyone know the easy way to do this? / Syntax for the trigger?
Why not use PK/FK instead of trigger? I ...How do I remove dashes or ( )'s from a variable that is going to be inputed into a SQL table under a Numeric field?
I have a form where a user will input phone numbers however the SQL Table is setup as an interger so if someone puts in ( ) or -'s it will throw it off. How can I trim this string so it will be viewed as an integer in SQL?
I am thinking maybe the remove command but I am not sure. THank you!
You can do in the following way:
Please do not forget to click Mark As Answer on the post that helped you. Regards,Iam...Create access table using sql table field
hi friends , i need create mdb file with table and data , the data will come from sql server 2005 table , for example i have table employee table contain some fields like name mobile number and others ,, now i need to create access mdb file with table and data , data is mobile numbers of employee(just only one field) , i m using ASP.net C# 2.0, plz help me yarTHANKS FOR ADVANCE
Hello Raghavendra, &nbs...How to call or retrieve fields from sql and display in table without using ADO.net, I'm using a dynamic link library....Is the coding different?
Help me! I'm doing my school project on Software Change Management Tool, CR Tracker. I want to display table in the webform, and the table data is retrieve form the sql server. So how do I call the sql so as to display the data in a table?
hy..What does that dll contain ?Does it already contains relevant code to connect to a database ?
Have a look hereThanksDinuj Nath
The easy way to do this is with the use of a data bound grid. The Grid can be customised to look and feel you like. You will need to add a data adapter to your page and a grid. When you setup the data adapter you will nee...How to define Comment fields with SQL
Using SQL Central I can define a comment as part of a column property.
How do I do it using either SQL or ODBC?
E-mail from: Steve Garland,Hyper Logic Resource Group http://netnow.micron.net/~sgarland
CAD Text Magician-CTM32 (Condoc Management), Paradox Infirmary & Resort (fix paradox files and more!)
Delphi Visual CADD (tm)Component (HVCADD)- View and Manipulate AutoCAD (c) DWG Files
See the COMMENT statement for adding comments programmatically.
Jim Egan [TeamPS]
Dealer Solutions, LLC
...Displaying fields from a SQL table
I am really new at both ASP.NET and VB so please be kind. I also am not sure I am posting to the appropriate forum.
I need to input a value on a web page and then find out if the record exists in the SQL database table or not. If the record exists, I need to format a display page with information from the record. If the record does not exist, I need to display a form that can be filled in to insert a new record in the table.
I know this is probably simple, but all I can find information on is using datagrids and datagrids will not work (boss does not like). I need to create a form ...Retrieving the description field or SQL Comment field from a view
I have managed to use the INFORMATION_SCHEMA.TABLES to retrieve a list of all my views.
I was wondering if it was possible to retrieve the Description or SQL Comment field from a view via ADO.NET, which can be found in the Enterprise Manager Design View properties (right click - properties)
I want to hopefully utilize this field for dynamic page titling of a datagrid bound view.
Many Thanks in anticipation!...Inserted records missing in sql table yet tables' primary key field has been incremented.
I have a sql sever 2005 express table with an automatically incremented primary key field. I use a Detailsview to insert new records and on the Detailsview itemInserted event, i send out automated notification emails.
I then received two automated emails(indicating two records have been inserted) but looking at the database, the records are not there. Whats confusing me is that even the tables primary key field had been incremented by two, an indication that indeed the two records should actually be in table. Recovering these records is not abig deal because i can re-enter them but ia...I imported a SQL Table into SQL DataBase, But I can not update this table even with SQL Server management Studio
I imported a SQL Table into SQL DataBase, But I can not update this table even with SQL Server management Studio
When I change any data on mentioned table above, Red exclamation sign appears left of the record .
How can I correct this problem?
Try running the UPDATE via Query Analyzer...and see if you get an error.***********************Dinakar NethiLife is short. Enjoy it.***********************...SQL table, key, field design
i am putting together an application for a client of mine that involves image heavy data handling. i have a couple of possible methods in mind of how to go about this, and would like some outside opinions, especially from any of you who may have done anything similar before.
to quickly sum up the application's desired results: a photo gallery that contains four sections of job before/after photos. 1)residential 2)comercial 3) automotive and 4)specialty. when a site browser clicks a section, it will bring up a gridview of the "key" or ideal photo (one each)from ...