Databases

57K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am updating my database using this kind of command
UPDATE wp_posts SET post_content = REPLACE(post_content, '<a href="/product/aromaball_plug_in_diffuser_p_2/09"> HistaBlock </a>', '<a href="/product/histablock_p_209/"> HistaBlock </a>') WHERE post_content LIKE '%<a href="/product/aromaball_plug_in_diffuser_p_2/09"> HistaBlock </a>%';
UPDATE wp_posts SET post_content = REPLACE(post_content, '<a href="/product/aromaball_plug_in_diffuser_p_2/6"> Geranium </a>', '<a href="/product/geranium_15_ml_100_pure_essential_oil/"> Geranium </a>') WHERE post_content LIKE '%<a href="/product/aromaball_plug_in_diffuser_p_2/6"> Geranium </a>%';

Open in new window


This works fine if there is uniformity of spacing in the link identifier between "> and </a>

For example, sometimes there are spaces on each side of Geranium.  Another time there were 2 spaces on the left side of Geranium and one on the right.

">  Geranium </a>
">Geranium  </a>
">Geranium</a>

My question is can there be a regex or something similar to take care of the variable number of spaces or even lack of spacing?
0
Amazon Web Services
LVL 13
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Hi,

I am using Microsoft Access 2016 and trying to present access form to the end user and hid the "Ribbion" and the unnecessary options . I followed the steps that I found on the Internet but it did not work

I added below line on-load event.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Then

[x] Display Navigation Pane <-- uncheck this box.

[x] Use Access Special Keys <-- uncheck this box

Set access to use tabbed interface, and un-check the box to display tabs.

Any suggestion please?
0
I work for a small company and have been tasked with building a database application to help with some of our industry-specific tracking needs.  I am NOT a database developer or VB coder.  My experience is limited to industrial PLC programming and the occasional small Python script.  

The project includes a Form that executes an OnCurrent event which calls a Class Module (which I did not write the code for).  The purpose of the code is to acquire the Width and Height dimensions (in pixels) of an on-disk image file.  The code executes correctly if the record includes a valid image path.  However, if there is no valid path, I get the following error:
error_91.PNGat this line of code in my Form:
als315_Mod_Error.PNGHere is the code for the ImageDimensions class module:
Option Compare Database
Option Explicit

Private pPixelWidth As Long
Private pPixelHeight As Long
Private pImageFullPath As String

Public Property Get ImageFullPath() As String
  ImageFullPath = pImageFullPath
End Property
Public Property Let ImageFullPath(fullPath As String)
  pImageFullPath = fullPath
  Dim dimensionsText As String

  dimensionsText = GetImageDimensions(fullPath)
  pPixelWidth = Left$(dimensionsText, InStr(dimensionsText, ",") - 1)
  pPixelHeight = Mid$(dimensionsText, InStr(dimensionsText, ",") + 1)
End Property

Public Property Get PixelWidth() As Long
  PixelWidth = pPixelWidth
End Property
Private Property Let PixelWidth(value As Long)
  pPixelWidth = value

Open in new window

0
Hi,
Is there a way of checking if a csv file has been imported into a SQL table ?
I don't wish to duplicate it.
The file  would be the last one imported. There is a date field and that would determine if it was there.
Something like last record or equivalent.
Help much appreciated
Ian
0
I have a combo box in access .
I used for union.
Now I need union with autonumber.
Example
Autonumber. Primary contact. Alternative Contact
1.                      John.                     George
2.                      Sebastian.            Jack
I want the union as below
1 John
1 George
2 Sebastian
2 Jack

Anyone can help?
0
Hi,
I would like to truncate text in one of the columns in SQL as it uses a long string of text and would take up too much space.
I have 60 csv files to copy from Excel and have decided to do it manually with the use of the SQL GUI.
I have over 400 columns to import.
Is there a way to truncate the text column ?
Thanks
Ian
0
I have two MY SQL Databases with one table each.

Both have a key column "SteamId" and 3 other fields.

I'd like to combine the two tables into a third database with the same table name in it.
There would be duplicate SteamIds in both tables that would need to add the values of the "Points" table.

Databases:
Shop1, Shop2 into Shop3

Table: ShopPlayers
Columns:
Id - uniqueID
SteamId
Kits
Points
TotalSpent

The third database would need to have those tables merged and the columns for Points and TotalSpent need added together if the person found is in both tables.

Is that possible?
0
I need to get a result from two different databases

online Database
Item price table

Offline Database
item price table

In c# I need to join the above two tables and verify any price difference in the online and offline database.
And also verify any online table records missing in the offline and vice versa
I'm using visual studio 2017 and SQL Server 2014.  I need to use ado.net

The output should be like below

item       Online Price    OffLine price
A122         4.55                 5.55
A123         6.56                 4.55
A234         6.78                 Not Available
A235        Not Available    7.45


Here are the table columns
ItemPrice_table

ItemCode  char(20)
Price           decimal(10,2)
UpdateDate    DateTime


How to achieve this in ado.net? Since its two different databases, I don't know how to write a script
In c# I have the connection string "oneline" and connection string "Offline". Please let me know how to achieve this?
0
New to Expert Exchange so be gentle. Using VBA, I would like to delete the current linked Public Folders and then using VBA link different Public Folders. Before you ask, for ease of upgrading, revised Access databases are copied directly to other office workstations. Not packaged and installed. This method works well for me and has for several years. The only issue is that linked Public Folders retain the link to the original workstation and error out when accessed. This requires a visit to each workstation and manually relink the Public Folders. Switches are set and I could delete and relink the folders with the first execution on the subsequent workstation. We are using Server 2012, Exchange 2013 with Windows 7. I am aware that Public Folders is on it's way out and we will need to be upgrading parts of our system in the future. Just trying to delay for a while.
0
Typically, we upgrade our application about every 16 months and reinstall at the customer site. This includes changes to the database schema, e.g. new tables, deletion of other tables, new columns, deletion of some column, modifying some data types, modifying some table data, etc.  We call this our database migration, and this is not associated with an Oracle upgrade or patching.

My question during our database migration, should we take advantage of what I would call some standard maintenance?  Perhaps this would be a good time to rebuild all indexes, updating statistics, etc. What else could we do at this customer scheduled down-time to make sure the database is running optimally and efficient?
0
Your Guide to Achieving IT Business Success
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

I am developing a marine position database system in Perl on a Centos 6.5 server.
Users can email position reports to my system.  
My Perl script automatically processes each position report email, and sends a reply email back to the sender, acknowledging receipt of their position report.
I have also been working with the Garmin inreach explroer iridium messenger for position reporting.
I can easily configure the Garmin to send an email to my system, and my system can process the email with the position information without any problems, and store the information in my database.   This works great, but I can not send a reply back to the Garmin acknowledging receipt of the Garmin position report.
Sending the reply email to an alternate email address does not work if the sender is remove, and does not have access to email.
I need to send reply message back to the Garmin as an sms text message from an SMS phone number address.
To configure this, the Garmin would need to send the position report as an sms text message to my system, and  my system would need to reply back to the Garmin with an sms message.
The Garmin inReach Explorer can send 160 character messages to either an email addresses or to ans sms cell phone number.
Because Garmin charges for sms and email text messages, Garmin blocks all direct emails to the Garmin inReach Explorer.
Garmin will accept an sms reply message to the Garmin.
Because of this logic, I would like to find a way to send and receive …
0
We have a web site that connects to a database stored in Azure. This is an intermittent error we receive:

System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 52.xxx.xxx.xxx:443

Running netstat from our web server we get this result:
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT
TCP      172.17.x.xx:54432     52.xxx.xxx.xxx:443    SYN_SENT

Is this an issue on Microsoft's side?
0
I am executing a query in PyCharm connected to a PostgreSQL database. Here is the code in question:

sql_query = '''INSERT INTO "daily_performance_metrics"."employee_transactions" 
("WarehouseName", "Date", "EmployeeName", "00:00", "00:15", "00:30", "00:45", "01:00", "01:15", "01:30", "01:45", "02:00", "02:15", "02:30", "02:45", "03:00", "03:15", "03:30", "03:45", "04:00", "04:15", "04:30", "04:45", "05:00", "05:15", "05:30", "05:45", "06:00", "06:15", "06:30", "06:45", "07:00", "07:15", "07:30", "07:45", "08:00", "08:15", "08:30", "08:45", "09:00", "09:15", "09:30", "09:45", "10:00", "10:15", "10:30", "10:45", "11:00", "11:15", "11:30", "11:45", "12:00", "12:15", "12:30", "12:45", "13:00", "13:15", "13:30", "13:45", "14:00", "14:15", "14:30", "14:45", "15:00", "15:15", "15:30", "15:45", "16:00", "16:15", "16:30", "16:45", "17:00", "17:15", "17:30", "17:45", "18:00", "18:15", "18:30", "18:45", "19:00", "19:15", "19:30", "19:45", "20:00", "20:15", "20:30", "20:45", "21:00", "21:15", "21:30", "21:45", "22:00", "22:15", "22:30", "22:45", "23:00", "23:15", "23:30", "23:45", "ReceiveRate", "PutAwayRate", "PickRate", "PackRate", "ShipRate", "receiveptp", "putawayptp", "pickptp", "packptp","TOT") 
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 

Open in new window

0
I have an iSeries ODBC connection that I am using to send data from SQL Server to an iSeries. I can do a DELETE on a table, but I really need to do a TRUNCATE.

However, when I do a TRUNCATE, I get this error:

OLE DB provider "IBMDASQL" for linked server "AS400DV" returned message "SQL0104: Token TRUNCATE was not valid. Valid tokens: ( END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER.

Open in new window

How can I go about doing a TRUNCATE on the iSeries database table?
0
symantec database password error

i upgraded my symantec management console and i can't get pass  this error, keep getting wrong password, how do i reset the password for DBA user


Screen-Shot-2019-05-16-at-8.37.44-AM.png
0
i have web form using local storage to keep track of the form data. Assume I fill in the html form using my laptop, and now I use my phone. Is this still possible to get the local storage data back on the phone? I understood I can use database to store the information but I tried not to do that because I want to avoid round trip data in the database.
0
oracle dbms_datapump export run correctly in an anonym bloc and fail in a store procedure

I have a database and i can execute dbms_datapump.open to create job and do an export of table directly in anonym mode in sqldevelopper,
but since i try to use the same code with a store procedure i got an error and there is no job start or exist.

You 'll find joinded the screen capture of th result

Execution of the Script in a anonym block and successfullyExecution in a Store Procedure Which Don't work
0
Hi EE,

A VS query here:

The visual studio error I have been having is that when you select a data connector of Native 11 it was still showing Native 11 but deploying packages in Native 10.

To fix the issue I went to notepad and manually changed each file over, then reopen visual studio everything worked in Native 11 after that.   Not sure why the package files did not convert over when the connector was converted on a shared data source?

Attached is the screen where I am changing the data connector version details.

Any is assistance is welcome, let me know if require clarification.

Thank you.
SSIS-Package.png
VS-Version.png
0
Hello All;

(I asked a similar question for SQL Server, however. In this case, we are dealing with an Access Database. Though in the future we might convert this project over to SQL Server. For the time being, we are dealing with Access Database)
I tried, but could not use the SQL Server code. So...

I have a table where the column is a "Number".
In the column named = Years
It has the following example.

1978
1965
1985
2017
1962
1998
2012
2002
1958
1978

OK, What I need to do is the following.
For the years in the table, they need to output as

1950
1960
1970
1980
1990
2000
2010
etc...

Thanks.
Wayne
0
Introduction to Web Design
LVL 13
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Our LAMP stack website was failing to make connection to an azure database, very sporadically but very often, like every 3rd click that you'd hit where it needed to go out to azure for data. The exact errors in the Symfony prod.log was:

Connection Failed:[unixODBC][Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x274C

and

app.ERROR:  error : [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x68

We tired everything, our web host made sure our ODBC driver was the same on the production server (which had the issue) as it was on our staging server (exact same code base and it did not ever have the issue)... it is exactly the same. All Azure logs and settings looked fine. The production server disk space and RAM have plenty of room.

I finally out of desperation trashed the cache of Symfony on our production server. Since then, actually a bit before then, we haven't had the issue.

What could the issue have been? I need to know what it was to prevent it in the future.
0
I'm using the following query to get information about CLR assemblies attached to a SQL Server database.
SELECT
	[assemblies].[name],
	[assemblies].[principal_id],
	[database_principals].[name] AS [principal_name],
	[assemblies].[assembly_id],
	[permission_set_desc],
	[is_visible],
	[assembly_files].[name] AS [assembly_file_name],
	ASSEMBLYPROPERTY([sys].[assemblies].[name], 'SimpleName') AS [simple_name],
	[clr_name],
	[content],
	HASHBYTES(N'SHA2_512', [assembly_files].[content]) AS [SHA512HASH]
FROM
	[sys].[assemblies]
INNER JOIN
	[sys].[database_principals] ON
	[sys].[database_principals].[principal_id] = [sys].[assemblies].[principal_id]
INNER JOIN
	[sys].[assembly_files] ON
	[sys].[assembly_files].[assembly_id] = [sys].[assemblies].[assembly_id]
WHERE
	[is_user_defined] = 1

Open in new window

I have two identical databases (structurally, though the data they contain is different). One is attached to a SQL Server 2012 instance. The other is attached to a SQL Server 2016 instance. Here is the full @@Version information for each.
Microsoft SQL Server 2012 (SP1) - 11.0.3156.0 (X64)   May  4 2015 18:48:09   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) 

Open in new window

Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)   Mar 18 2018 09:11:49   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

Open in new window

I'm hoping that there's some kind of known bug with using HASHBYTES on a SQL Server 2012 instance but I can't find any documentation to that effect. Can anyone give me a clue as to why it fails on the 2012 instance but works fine on the 2016 instance?
0
Hi,

Someone know a tool to access data in cobol database files (Rmcobol), like management studio for sqlserver?

best regards
0
Hi,
I've got myself in a bit of a mess with my data loading into SQL Server and need to start over as some columns are missing.
Here is my question.
Is there a simpler way of loading 60+ files of back data from Excel in csv format to a table in SQL Server 2017 other than using the Management Studio GUI ?
..... and at the same time placing the columns in a preferred order ?
There are a total of 464 columns.
Many thanks
Ian
0
I seam not to see any error here , I have created a simple ms access databases , but whenever I try to group the query it does not do the grouping , kindly check.

SELECT DISTINCTROW tblEmployees.EMPID, tblEmployees.TaxID, tblEmployees.FirstName, tblEmployees.[Last name], tblPension.Rate, Sum(tblHours.Hours) AS SumOfHours, Sum(tblHours.OTime) AS SumOfOTime, Month(tblHours.HFDate) AS Mth
FROM tblPension INNER JOIN (tblEmployees INNER JOIN tblHours ON tblEmployees.EMPID = tblHours.EMPID) ON tblPension.PID = tblEmployees.PID
GROUP BY tblEmployees.EMPID, tblEmployees.TaxID, tblEmployees.FirstName, tblEmployees.[Last name], tblPension.Rate, Month(tblHours.HFDate), tblHours.HFDate;



Qrytesting.png


SmapleTest.png

Where is the problem now here!

Regards

Chris
0
Dynamics 365 CRM Online, version 9.1

We have an online Production database that we want to clean up before using it to refresh our Dev and Training environments.  Because of the size of the Prod database, we need to take it to another location (our server, etc) to run the clean-up process.  Exactly how do we move the Prod database to another server to clean-up?

Thanks
0

Databases

57K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.