6,934 Topics
 | |
| | Hey guys..... can someone tell me why when I pass a NULL value to this function, the logic comes back as NULL and not an empty string?...... Thanks, Ken [CODE]Public Function Field2Str(strValue As String) As String If IsNull(Trim(strValue)) Then Field2Str = " " Else Field2Str = Trim(strValue) End If End … |
| | I'm trying to get the following query both functional and controlled via inner joins rather than this format, as the way it is now will be slow once the db fills up I've never been good with joins and this is the first time for me working with MS SQL …  |
| | How do we go about doing a query under SQL server? And can i actually use the form in access to link to the tables on SQL server? Please advise. Thanks. |
| | Hi Im so nood in perl and i have a problem need. When i ever i run this dts_add.pl the run date is not backward compatible. I ran this program every month and and reference the date from which it was previously ran. I wanted to run a file dated … |
| | I have been debugging my application for 6 months. Now, when I try to run it I am getting "under the default settings SQL Server does not allow remote connections." My computer is not on a network. I recently went from Visual Studio 2005 Express Edition to the Professional edition. … |
| | i have 1 page for submit this code -----------------------PAGE1.ASP----------------------------------------- SEND DATA pro_id by using from to PAGE2.ASP ----------------------- PAGE2.ASP----------------------------------------- <input name="pro_id" type="text" id="pro_id" value="<%=pro_id%>" disabled="1"> ----------------------------------------------------------------------------- PAGE2 SUBMIT TO PAGE3.ASP BUT page3 doesn't get a data from PAGE2.ASP i don't know why how can i do .............................................................................. ................................................................................................. PS. variable … |
| | Hi guys I am doing my computer science dissertation on the complexity of navigation within mobile phones. Therefor for this i need to program a menu for a mobile phone which will help reduce time taken to locate functions within the phone. I wish to implement a search facilatated menu … |
| | [COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over … |
| | hi, i have installed sql-server 2000 on win-xp pc . but when i am using sql server it requires authentication from server ,but i do not have any server ,by this i am unable to use sql database in my vb application .is any method to use sqlserver 2000 without … |
| | Hi everybody, i m qcdms21 , i would like to know can we update in views , i m been told select can be used but not insert. How about update? For ex: i have loanview1 as view , inside it i have loan , guarantor and student db tables. … |
| | I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write: [CODE] SELECT * FROM table WHERE field like '%$val%' [/CODE] this will list all recoreds that the field contains sub-string "abc". Now the question is: if I have a … |
| | Hello, I am trying to implement a fulltext search on a MS SQL database. While I can query each table independently for a specific word, I didn't find a method to query the entire collection of tables for my search key. Is there a way to do this (using the … |
| | How to upload Images to SQL Server database using ASP.NET tools. Also how to retrieve those saved images from SQL Server and display them onto DataGrid. Visit: [URL="http://www.programmingknowledge.com/ImageUpload.aspx"]http://www.programmingknowledge.com/ImageUpload.aspx[/URL] |
| | Hi guys, Need some help in some query processing... Here goes,this is the results i have obtained so far |id |cat | name | 1 .....a apple 1 .....b banana 2 .....a austria 2 .....b brazil 2 .....c china 3 .....a abraham 3 .....c clinton Column cat can have at … |
| | Using a php generator "appgini" having a problem I believe with the script. 1 table with 4 fields, fields 2 & 3 are text and field 4 is an image field. Everything works but field 4, when you upload a image along with text in fields 2 & 3 it … |
| | When inserting/updating records do you prefer to use an SQL query, or just the cfinsert/cfupdate tags? I was just wondering Stewie |
| | Having built a work around for the counting feature not working, in any of the normal ways Ihave the following problem. [b]This works perfectly:[/b] [b][size=1][color=#ff0000][i] <%[/i][/b][/color][/size][size=1] [i][b]RSPage[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [b]TRIM[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]Request[/b][/i][/size][i][size=1][color=#008000].[/color][/size][b][size=1]QueryString[/b][/i][/size][i][size=1][color=#008000]([/color][/size][size=1]"page"[/size][size=1][color=#008000]))[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]Len[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]RSPage[/b][/i][/size][i][size=1][color=#008000])[/color][/size][size=1] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][/i][size=1] [i][b]Max[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]10[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]Offset[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] …  |
| | Primary responsibilities include providing technical and creative solutions for service delivery by visiting customer problems sites, while ensuring customer satisfaction with Microsoft SQL, Networking, BackOffice and Desktop software. The successful candidate will be capable of performing on-site support of on-going support activities including but not limited to Premier Support, supportability … |
| | hi, My Problem is when am deleting a row from the SQL Server Database....I need to check two conditions. For eg: While deleting a row from the database,i need to check based upon the Name of the Employee and The Employee Number. Because there might be Employees with the same … |
| | Hi I need to send a mail with text attachment from my PL/SQL procedure.I am using version 8i and tried with SMTP. I am able to send text mails but not attachments. Can any one help me!! it'l be great if you can share sample programs. Thanks HK:?: |
| | I am trying to migrate my MS Access database to MS SQL. My coding pattern is simple. Like this '--------------------- Data1.Database.Close Data1.DatabaseName = App.Path & "\Status.mdb" Data1.RecordSource = "Performance" Data1.Refresh C1 = "SlNo = 1" Data1.Recordset.FindFirst C1 If Data1.Recordset.NoMatch = False Then Data1.Recordset.Edit Data1.Recordset.Fields("Amount") = Format(mamt, "##,##0.00") Data1.Recordset.Fields("Upd") = Now … |
| | Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in … |
| | Hi, I'm using a GridView Control in which I wish to show thumbnail versions of images saved as binary data on a SQL DB. I have a page that accepts an ID parameter to use in finding the image on the database. The page uses the [inlinecode]Response.BinaryWrite()[/inlinecode] method to display … |
| | I am attempting to apply an SSL certificate on a per client basis in SQL 2000 (Windows 2000). I have read a number of MS Knowledgebase articles on the subject, and followed their directions, none of which seem to be working. After installing the certificate, the directions say to export … |
| | We are getting frequent error in display while processing through web, we are having higher end hardware , ML350G SERVER,with 4GM Ram, duel processer capable, 145x3 hard disk, We are having 30 GB Space in C: Drive and 240GB in D:Drive, we have sql database upto 17 GB, the process …  |
| | Hi all, Please help me in solving following query. Can we define in sql server the same parameter as input and output? How to do it? Thanks and regards, Swapnil. |
| | I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one … |
| | Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number … |
| | Hi All, My name is Marc and I live in Halifax, NS Canada. I have 2 great kids and my wife is OK as well. I own a small web site / hosting company and I had a hard drive failure and my back-ups didn't work perfectly. I have a … |
| | Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not … |
| | Sir, I had mysql file ss.sql. Now I want upload the file in the Database. Is there any way to do the same. Kindly help me in the matter. Ashwin Perti |
| | Hello, I'm inheriting a half-built web-site that has runs on IIS over an MS SQL database. The web pages are written in ASP and they are mostly a mess. Is it possible to use Perl scripts in an MS SQL and IIS environment? Thanks for any input or feedback. Silentiopk4 |
| | Hello. I'm seeking some advice from anyone currently working in IT. A few years back I was laid off from my IT job (nothing fancy; tech support for a global company). My youngest kid was having some problems so I took some time away. About six months later I tried …  |
 | how deposit a picture to MYSQL database below is the code : <?php $id=$_POST; $photo=$_POST; if ($photo<>""){ $fp=fopen($photo,"r"); $data=addslashes(fread($fp,filesize($photo))); } $sql="insert into product(id,pic) values('$id','$data')"; mysql_query($sql,$conn) or die ("插入数据失败: ".mysql_error()); ?> but always unsuccessful! why? plz help me! |
| | Dear all. l am Boateng from Ghana wast Africa and l am want someone to help to know how to use My SQL and MS SQL. l work at community wireless project at Ghana but l am using linux only and l want use ms SQL software but l don't …  |
| | Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i … |
| | I have a DB which have three types of users: students, admins, and volunteers. I am trying to use SQL Server Enterprise Manager 8.0 to set up those roles such that students can (where appropriate) select, insert, update, or delete from given tables/rows; similarly for admins and for volunteers. (The … |
| | Hi i try to sum two column in Sql, but don't get it.... this way is not working.... [COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#808080]+ [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])))[/COLOR] [COLOR=#808080],[/COLOR] and with that is not working to [COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#000000] as A ,[/COLOR][COLOR=#808080] [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])) as B[/COLOR][COLOR=#808080],[/COLOR] sum(A+B) as Result can someone … |
| | |
| | I am trying to Edit a Sql Row with the values of my textboxes. This is what I have. Can someone point me in the right direction? conn.Open(); SqlCommand command = [COLOR=#0000ff]new[/COLOR] SqlCommand(sqlString,conn); SqlDataReader myDataReader = command.ExecuteReader(); [COLOR=#0000ff]if[/COLOR](myDataReader.HasRows) { [COLOR=#0000ff]while[/COLOR] (myDataReader.Read()) { MarketName.Text=myDataReader["FileName"].ToString(); [COLOR=#008000]//HopName.Text=myDataReader["HopName"].ToString(); [/COLOR]SiteA.Text=myDataReader["SiteAName"].ToString(); SiteB.Text=myDataReader["SiteBName"].ToString(); ASRA.Text=myDataReader["ASRa"].ToString(); ASRB.Text=myDataReader["ASRb"].ToString(); GElevationA.Text=myDataReader["GroundElevA"].ToString(); GElevationB.Text=myDataReader["GroundElevB"].ToString(); …  |
| | hello I am new to sql and database design. I am looking for to learn diffrent ways of designing them and making them efficent. any tips or hints will be appreciated. Thank You All. |
| | Hi... How can i export one or more SQL tables to MS Access from VB .NET? |
| | How can I connect to SQL Server database using VB.I have received some errors during connection.Plz give me a replay as soon as possible |
| | I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I … |
| | I am trying to display a database into textboxes without using Datagrids. How do you give a value to a text box that corresponds with a Sql row. Thanks. |
| | [code] sql = "SELECT * FROM tblcsvdump" set rs = connection.execute(sql) records = rs.Fields.Count dim heading(100) dim pulled(100) dim i dim count dim VAL dim VEL i=0 count = 0 for i=0 to records heading(count) = rs.Fields(count) response.write(heading(count)) header = heading(count) '**** THIS ROW HAS ERROR pulled(count) = Request.Form(header) count=count+1 … |
| | hi... i create a new table with this code Dim SQLCreate As New SqlCommand Dim Conn As New SqlConnection Dim DA As New SqlDataAdapter Dim DS As New Data.DataSet 'Create DB SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)" SQLCreate.Connection = Conn Conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" … |
| | I just got this [B]Error Returned when i tryied Type the url of my site [/B] mySQL query error: SELECT e.*,b.blog_name, b.blog_friendly_url FROM ibf_blog_entries e,ibf_blog_blogs b LEFT JOIN ibf_blog_categories bc ON ( e.blog_id=bc.blog_id and e.category_id=bc.category_id ) WHERE e.entry_status='published' AND (b.blog_private=0 or b.blog_id = 1) AND ((bc.blog_id IS NULL) or (b.blog_id … |
| | When submitting a page via the internet, I get a 500 error and the location of a file in jsp. Are you able to help?? Basically I have an expense system implemented with JSP in JBuilder 4 using Oracle 9i and SQL Plus. When submitting any pages in the system, … |
| |
The End.